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
obLevel
__env
app
breadCrumbList
breadCrumbHtml
errors
__currentLoopData
loop
category
localBussiness
rootCategories
seoBlockContent
select * from `category_den` where `url` = 'iamz-116876' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (116876)
select * from `categories` where `categories`.`id` = 116876 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (116876)
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` = 116876 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, 116876, 146111)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (35, 116876, 146111)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 116876 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 (116877, 116979, 117081, 117148, 117215, 117318, 117421, 117495, 117569, 117637, 118024, 118106, 118188, 118259, 118333, 118430, 118532, 118613, 118694, 118713, 118780, 118849, 118892, 118959, 119023, 119089, 119155, 119225, 119283, 119398, 119496, 119569, 119643, 119753, 119805, 119883, 119952, 120027, 120116, 120181, 120246, 120353, 120460, 120533, 120603, 120673, 120743, 120849, 120908, 120987, 121066, 121145, 121224, 121310, 121396, 121482, 121537, 121604, 121656, 121711, 121763, 121810, 121880)
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` = 116876 and `products`.`stock` > 0 and `products`.`deleted_at` is null
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 `_lft`, `_rgt` from `categories` where `id` = 116876 limit 1
select * from `categories` where `categories`.`_lft` between 104291 and 110818 and `_depth` < 4
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (116876, 116877, 116979, 117081, 117148, 117215, 117318, 117421, 117495, 117569, 117637, 118024, 118106, 118188, 118259, 118333, 118430, 118532, 118613, 118694, 118713, 118780, 118849, 118892, 118959, 119023, 119089, 119155, 119225, 119283, 119398, 119496, 119569, 119643, 119753, 119805, 119883, 119952, 120027, 120116, 120181, 120246, 120353, 120460, 120533, 120603, 120673, 120743, 120849, 120908, 120987, 121066, 121145, 121224, 121310, 121396, 121482, 121537, 121604, 121656, 121711, 121763, 121810, 121880)
select `product_to_category`.* from `product_to_category` inner join `products` on `products`.`id` = `product_to_category`.`product_id` where `category_id` in (116876, 116877, 116979, 117081, 117148, 117215, 117318, 117421, 117495, 117569, 117637, 118024, 118106, 118188, 118259, 118333, 118430, 118532, 118613, 118694, 118713, 118780, 118849, 118892, 118959, 119023, 119089, 119155, 119225, 119283, 119398, 119496, 119569, 119643, 119753, 119805, 119883, 119952, 120027, 120116, 120181, 120246, 120353, 120460, 120533, 120603, 120673, 120743, 120849, 120908, 120987, 121066, 121145, 121224, 121310, 121396, 121482, 121537, 121604, 121656, 121711, 121763, 121810, 121880) 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 `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: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 => "18.119.139.161" ] "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 => "18.119.139.161" ] "if-none-match" => array:1 [▶ 0 => "" ] ]
0 of 0 array:51 [▶ "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" => "18.119.139.161" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "18.119.139.161" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z_jjcez3UrhHJOSvGiWaJQAAAE8" "REDIRECT_URL" => "/catalog/piese-de-schimb-35/piese-motoare-146111/iamz-116876" "REMOTE_ADDR" => "18.119.139.161" "REMOTE_PORT" => "34294" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-de-schimb-35/piese-motoare-146111/iamz-116876" "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" => "Z_jjcez3UrhHJOSvGiWaJQAAAE8" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744364401.093 "REQUEST_TIME" => 1744364401 "argv" => [] "argc" => 0 ]
0 of 0 array:8 [▶ "cache-control" => array:1 [▶ 0 => "max-age=2628000, public" ] "date" => array:1 [▶ 0 => "Fri, 11 Apr 2025 09:40:01 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 => ""aeff2b42394b7a94b150b19c24524809"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlwvS0hTbTQyUVJMOTBtbVg1QnZROGd3PT0iLCJ2YWx1ZSI6Iit0MzFuUjlOblYrTTRYdUNZalU3U096RnZYSXY0Y0lqVjBpdW0yR3Z1U3RXMkdNc29VV3ZDSm5HVmRtYXJyc2QiLCJtYWMiOiJhZDI5YjNmYjRmYzE4MjYxMTM3NzZkNWY0YjMyMDFhZTk0YzlmZDllYTI1YmVmMjM1NWQzNTNkMzQzNjY0NTdiIn0%3D; expires=Fri, 11-Apr-2025 11:40:01 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlwvS0hTbTQyUVJMOTBtbVg1QnZROGd3PT0iLCJ2YWx1ZSI6Iit0MzFuUjlOblYrTTRYdUNZalU3U096RnZYSXY0Y0lqVjBpdW0yR3Z1U3RXMkdNc29VV3ZDSm5HVmRtYXJyc2QiLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6ImxsTnhvQTlib1krZXlSNzRUUWVVaUE9PSIsInZhbHVlIjoiTURzaVFCQ2pZbnhZNERVRitEN1cxNXhxQThkYTNVRW5wRVRzdGdpbHdxRWtBUEpacEJGUjVVdEQxUldlcElVZiIsIm1hYyI6IjQ1MjY5YjQzN2QzNTI3OTdhNzU0YjQ4ZmJjMjJkMWYxNmQ1ZjliN2JjNTYzZTQyMDRhNjkyMDM2ZGJhZjIxMGUifQ%3D%3D; expires=Fri, 11-Apr-2025 11:40:01 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImxsTnhvQTlib1krZXlSNzRUUWVVaUE9PSIsInZhbHVlIjoiTURzaVFCQ2pZbnhZNERVRitEN1cxNXhxQThkYTNVRW5wRVRzdGdpbHdxRWtBUEpacEJGUjVVdEQxUldlcElV ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlwvS0hTbTQyUVJMOTBtbVg1QnZROGd3PT0iLCJ2YWx1ZSI6Iit0MzFuUjlOblYrTTRYdUNZalU3U096RnZYSXY0Y0lqVjBpdW0yR3Z1U3RXMkdNc29VV3ZDSm5HVmRtYXJyc2QiLCJtYWMiOiJhZDI5YjNmYjRmYzE4MjYxMTM3NzZkNWY0YjMyMDFhZTk0YzlmZDllYTI1YmVmMjM1NWQzNTNkMzQzNjY0NTdiIn0%3D; expires=Fri, 11-Apr-2025 11:40:01 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlwvS0hTbTQyUVJMOTBtbVg1QnZROGd3PT0iLCJ2YWx1ZSI6Iit0MzFuUjlOblYrTTRYdUNZalU3U096RnZYSXY0Y0lqVjBpdW0yR3Z1U3RXMkdNc29VV3ZDSm5HVmRtYXJyc2QiLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6ImxsTnhvQTlib1krZXlSNzRUUWVVaUE9PSIsInZhbHVlIjoiTURzaVFCQ2pZbnhZNERVRitEN1cxNXhxQThkYTNVRW5wRVRzdGdpbHdxRWtBUEpacEJGUjVVdEQxUldlcElVZiIsIm1hYyI6IjQ1MjY5YjQzN2QzNTI3OTdhNzU0YjQ4ZmJjMjJkMWYxNmQ1ZjliN2JjNTYzZTQyMDRhNjkyMDM2ZGJhZjIxMGUifQ%3D%3D; expires=Fri, 11-Apr-2025 11:40:01 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImxsTnhvQTlib1krZXlSNzRUUWVVaUE9PSIsInZhbHVlIjoiTURzaVFCQ2pZbnhZNERVRitEN1cxNXhxQThkYTNVRW5wRVRzdGdpbHdxRWtBUEpacEJGUjVVdEQxUldlcElV ▶" ] ]
0 of 0 array:7 [▶ "_token" => "lbXhKr62dqAr5JvDLnZreVrdEvMbc3a3vagMloTj" "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-motoare-146111/iamz-116876" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]