R. Moldova, mun. Chișinău
șos. Muncești 271/7
Cabinetul personal
(022) 81 92 41
078 644 644
© Agropiese.md 2025
Depozit: MDL
Suma creditului: MDL
Plata lunară: ~ MDLPlata lunară este aproximativă și nu prezintă informație contractuală.
Suma creditului nu poate fi mai mică de 1000 de lei
pageTitle
pageMeta
h1
canonical
pageUrl
linkUrl
switchUrl
alternateLang
subCategories
models
isTyresCat
isOilCat
isBatteriesCat
isRulmentiCat
rulCategories
rulParCategories
products
categoryDen
currentCategory
tyresCategories
manufacturers
widths
heights
radius
vendors
showPdfCatalogsLink
haveFilters
filterKeys
paginator
elements
obLevel
__env
app
breadCrumbList
breadCrumbHtml
errors
__currentLoopData
loop
category
product
ix
localBussiness
rootCategories
seoBlockContent
select * from `category_den` where `url` = 'altele-160166' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (160166)
select * from `categories` where `categories`.`id` = 160166 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (160166)
select *, (select count(1) - 1 from `categories` as `_d` where `categories`.`_lft` between `_d`.`_lft` and `_d`.`_rgt`) as `depth` from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 160166 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 49, 160166)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (35, 49, 160166)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 160166 and `is_visible` = 1 order by COALESCE(co.order, 999) asc, `categories`.`id` asc
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (161204, 161302)
select count(*) as aggregate from `products` inner join `product_to_category` on `product_to_category`.`product_id` = `products`.`id` where `product_to_category`.`category_id` = 160166 and `products`.`stock` > 0 and `products`.`deleted_at` is null
select `products`.*, `product_to_category`.`category_id` as `laravel_through_key` from `products` inner join `product_to_category` on `product_to_category`.`product_id` = `products`.`id` where `product_to_category`.`category_id` = 160166 and `products`.`stock` > 0 and `products`.`deleted_at` is null limit 20 offset 140
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (197238, 197239, 197240, 197241, 197242, 197243, 197244, 197418, 197419, 197420, 204454, 204946, 206198, 208327)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (197238, 197239, 197240, 197241, 197242, 197243, 197244, 197418, 197419, 197420, 204454, 204946, 206198, 208327)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (197238, 197239, 197240, 197241, 197242, 197243, 197244, 197418, 197419, 197420, 204454, 204946, 206198, 208327)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 17, 304)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (197238, 197239, 197240, 197241, 197242, 197243, 197244, 197418, 197419, 197420, 204454, 204946, 206198, 208327)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 54 and `is_visible` = 1 order by COALESCE(co.order, 999) asc, `categories`.`id` asc
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (161290, 161291, 161293, 161294, 161298)
select * from `product_params` where `param_id` = 240
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (240)
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197238 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 160166 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197239 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197240 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197241 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197242 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197243 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197244 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197418 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197419 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197420 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 204454 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 204946 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 206198 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 208327 limit 1
select `_lft`, `_rgt` from `categories` where `id` = 160166 limit 1
select * from `categories` where `categories`.`_lft` between 179 and 184 and `_depth` < 4
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (160166, 161204, 161302)
select `product_to_category`.* from `product_to_category` inner join `products` on `products`.`id` = `product_to_category`.`product_id` where `category_id` in (160166, 161204, 161302) and `products`.`stock` > 0 and exists (select * from `products` where `product_to_category`.`product_id` = `products`.`id` and `products`.`deleted_at` is null) group by `product_to_category`.`product_id` order by RAND() limit 12
select * from `products` where `products`.`id` in (121950, 131482, 139485, 139524, 146301, 149449, 149482, 149506, 155345, 166317, 184306, 184313) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (121950, 131482, 139485, 139524, 146301, 149449, 149482, 149506, 155345, 166317, 184306, 184313)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (121950, 131482, 139485, 139524, 146301, 149449, 149482, 149506, 155345, 166317, 184306, 184313)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (121950, 131482, 139485, 139524, 146301, 149449, 149482, 149506, 155345, 166317, 184306, 184313)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 14, 17, 33, 164, 304)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (121950, 131482, 139485, 139524, 146301, 149449, 149482, 149506, 155345, 166317, 184306, 184313)
select * from `products` where `products`.`id` in (19703, 139524, 142039, 149474, 149475, 149478, 149480, 194262, 197229, 197238, 197239, 197240) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (19703, 139524, 142039, 149474, 149475, 149478, 149480, 194262, 197229, 197238, 197239, 197240)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (19703, 139524, 142039, 149474, 149475, 149478, 149480, 194262, 197229, 197238, 197239, 197240)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (19703, 139524, 142039, 149474, 149475, 149478, 149480, 194262, 197229, 197238, 197239, 197240)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (19703, 139524, 142039, 149474, 149475, 149478, 149480, 194262, 197229, 197238, 197239, 197240)
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 19703 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 139524 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 149475 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (160128)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 160128 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 49, 160118, 160124, 160128)
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 149478 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 149474 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 197229 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 149480 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 194262 limit 1
select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 142039 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (161204)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 161204 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 49, 160166, 161204)
select * from `categories` where `parent_id` is null
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (5, 6, 19, 31, 34, 35, 36, 37, 38, 39, 40, 159115, 160195)
select * from `seo_text` where (`route_name` = 'ro.catalog.subcategory') limit 1
select min(`price`) as aggregate from `products` where `stock` > 0 and `products`.`deleted_at` is null
select max(`price`) as aggregate from `products` where `stock` > 0 and `products`.`deleted_at` is null
200
0 of 0 array:1 [▶ "page" => "8" ]
0 of 0 array:20 [▶ "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "close" ] "host" => array:1 [▶ 0 => "agropiese.md" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "x-forwarded-for" => array:1 [▶ 0 => "3.145.0.168" ] "x-forwarded-host" => array:1 [▶ 0 => "agropiese.md" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-server" => array:1 [▶ 0 => "agropiese.md" ] "x-real-ip" => array:1 [▶ 0 => "3.145.0.168" ] "if-none-match" => array:1 [▶ 0 => "" ] ]
0 of 0 array:52 [▶ "CONTEXT_DOCUMENT_ROOT" => "/home/agropie/public_html" "CONTEXT_PREFIX" => "" "DOCUMENT_ROOT" => "/home/agropie/public_html" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_CONNECTION" => "close" "HTTP_HOST" => "agropiese.md" "HTTP_PRAGMA" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_X_FORWARDED_FOR" => "3.145.0.168" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "3.145.0.168" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "page=8" "REDIRECT_HTTPS" => "on" "REDIRECT_QUERY_STRING" => "page=8" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "aAkXYBQXsPT4w2-nrhp8GQAAAMg" "REDIRECT_URL" => "/catalog/piese-de-schimb-35/piese-pentru-autoturisme-49/altele-160166" "REMOTE_ADDR" => "3.145.0.168" "REMOTE_PORT" => "45518" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-de-schimb-35/piese-pentru-autoturisme-49/altele-160166?page=8" "SCRIPT_FILENAME" => "/home/agropie/public_html/index.php" "SCRIPT_NAME" => "/index.php" "SERVER_ADDR" => "95.217.22.64" "SERVER_ADMIN" => "webmaster@agropiese.md" "SERVER_NAME" => "agropiese.md" "SERVER_PORT" => "443" "SERVER_PROTOCOL" => "HTTP/1.0" "SERVER_SIGNATURE" => "" "SERVER_SOFTWARE" => "Apache/2.4.57 (Unix) OpenSSL/1.1.1k" "UNIQUE_ID" => "aAkXYBQXsPT4w2-nrhp8GQAAAMg" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745426272.1948 "REQUEST_TIME" => 1745426272 "argv" => array:1 [▶ 0 => "page=8" ] "argc" => 1 ]
[]
0 of 0 array:8 [▶ "cache-control" => array:1 [▶ 0 => "max-age=2628000, public" ] "date" => array:1 [▶ 0 => "Wed, 23 Apr 2025 16:37:52 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => -1 ] "etag" => array:1 [▶ 0 => ""7332f34ae4b5d58c42df8adc8ccb46d9"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjlZYzVpeXRHVzZwaVwvVUdsb1dLeUd3PT0iLCJ2YWx1ZSI6IitDNFFkQVwvUk1xYzJiUjhwOXhncm5VRWFYb0hqeFJhMnZHZzE2elBQbDF2YUFENzlZT2w2VElDdmNiYlZCUGw3IiwibWFjIjoiM2M0N2Q2NGQ3Nzc3MTE5ODM0ZDE2NDRkNDAyNDQ0ZmExOGQzMGU4NDJkOGQ4MTYzNGJjMDA5YjdjNGE0YjdmNyJ9; expires=Wed, 23-Apr-2025 18:37:52 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjlZYzVpeXRHVzZwaVwvVUdsb1dLeUd3PT0iLCJ2YWx1ZSI6IitDNFFkQVwvUk1xYzJiUjhwOXhncm5VRWFYb0hqeFJhMnZHZzE2elBQbDF2YUFENzlZT2w2VElDdmNiYlZCUGw3Iiwib ▶" 1 => "agropiesemd_session=eyJpdiI6IklvSDczeU1MQlBGWVp1b0c1ZTVmTWc9PSIsInZhbHVlIjoiVXRhQ29BcUJJXC96T3E1U015XC9MSVVDZ2pqYW92cTM4bFwvcXAxV0dhc2xZZkJtYWV5Q3VvdytwaTNvM3lSaUhJdyIsIm1hYyI6IjAzNDZjZDY0YTBjNjY0ZWI1YzJkYzUwYThiMTUxNDcxOGVjOGViMDYzODY3ZDk2YzlhMTE1ZjM2YTIxMjc0MzAifQ%3D%3D; expires=Wed, 23-Apr-2025 18:37:52 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6IklvSDczeU1MQlBGWVp1b0c1ZTVmTWc9PSIsInZhbHVlIjoiVXRhQ29BcUJJXC96T3E1U015XC9MSVVDZ2pqYW92cTM4bFwvcXAxV0dhc2xZZkJtYWV5Q3VvdytwaTNvM3lS ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjlZYzVpeXRHVzZwaVwvVUdsb1dLeUd3PT0iLCJ2YWx1ZSI6IitDNFFkQVwvUk1xYzJiUjhwOXhncm5VRWFYb0hqeFJhMnZHZzE2elBQbDF2YUFENzlZT2w2VElDdmNiYlZCUGw3IiwibWFjIjoiM2M0N2Q2NGQ3Nzc3MTE5ODM0ZDE2NDRkNDAyNDQ0ZmExOGQzMGU4NDJkOGQ4MTYzNGJjMDA5YjdjNGE0YjdmNyJ9; expires=Wed, 23-Apr-2025 18:37:52 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjlZYzVpeXRHVzZwaVwvVUdsb1dLeUd3PT0iLCJ2YWx1ZSI6IitDNFFkQVwvUk1xYzJiUjhwOXhncm5VRWFYb0hqeFJhMnZHZzE2elBQbDF2YUFENzlZT2w2VElDdmNiYlZCUGw3Iiwib ▶" 1 => "agropiesemd_session=eyJpdiI6IklvSDczeU1MQlBGWVp1b0c1ZTVmTWc9PSIsInZhbHVlIjoiVXRhQ29BcUJJXC96T3E1U015XC9MSVVDZ2pqYW92cTM4bFwvcXAxV0dhc2xZZkJtYWV5Q3VvdytwaTNvM3lSaUhJdyIsIm1hYyI6IjAzNDZjZDY0YTBjNjY0ZWI1YzJkYzUwYThiMTUxNDcxOGVjOGViMDYzODY3ZDk2YzlhMTE1ZjM2YTIxMjc0MzAifQ%3D%3D; expires=Wed, 23-Apr-2025 18:37:52 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6IklvSDczeU1MQlBGWVp1b0c1ZTVmTWc9PSIsInZhbHVlIjoiVXRhQ29BcUJJXC96T3E1U015XC9MSVVDZ2pqYW92cTM4bFwvcXAxV0dhc2xZZkJtYWV5Q3VvdytwaTNvM3lS ▶" ] ]
0 of 0 array:7 [▶ "_token" => "4vZprbmWca7P24xQ6AGgX9LRsny3kr58S17IMbfH" "phone_number_petricani" => "(022) 81 92 41" "phone_number_botanica" => "078 644 644" "internet_magazin" => "078 644 644" "_previous" => array:1 [▶ "url" => "https://agropiese.md/catalog/piese-de-schimb-35/piese-pentru-autoturisme-49/altele-160166?page=8" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
