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` = 'ltz-72065' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (72065)
select * from `categories` where `categories`.`id` = 72065 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (72065)
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` = 72065 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, 72065, 152725)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (35, 72065, 152725)
select count(*) as aggregate from `pdf_catalogs` where `category_id` = 152725 and `locale` = 'ro' and `pdf_catalogs`.`deleted_at` is null
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 72065 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 (72066, 72260, 72459)
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` = 72065 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` = 72065 and `products`.`stock` > 0 and `products`.`deleted_at` is null limit 20 offset 0
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (272, 346, 2299, 2969, 4613, 5185, 5629, 6298, 6677, 7931, 8011, 8792, 9100, 9255, 11686, 11916, 11975, 12022, 13407, 13987)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (272, 346, 2299, 2969, 4613, 5185, 5629, 6298, 6677, 7931, 8011, 8792, 9100, 9255, 11686, 11916, 11975, 12022, 13407, 13987)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (272, 346, 2299, 2969, 4613, 5185, 5629, 6298, 6677, 7931, 8011, 8792, 9100, 9255, 11686, 11916, 11975, 12022, 13407, 13987)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 11, 12, 13, 14, 30, 31, 33, 34)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (272, 346, 2299, 2969, 4613, 5185, 5629, 6298, 6677, 7931, 8011, 8792, 9100, 9255, 11686, 11916, 11975, 12022, 13407, 13987)
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` = 272 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 72065 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` = 346 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` = 2299 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` = 2969 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` = 4613 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` = 5185 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` = 5629 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` = 6298 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` = 6677 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` = 7931 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` = 8011 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` = 8792 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` = 9100 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` = 9255 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` = 11686 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` = 11916 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` = 11975 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` = 12022 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` = 13407 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` = 13987 limit 1
select `_lft`, `_rgt` from `categories` where `id` = 72065 limit 1
select * from `categories` where `categories`.`_lft` between 131891 and 132556 and `_depth` < 4
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (72065, 72066, 72260, 72459)
select `product_to_category`.* from `product_to_category` inner join `products` on `products`.`id` = `product_to_category`.`product_id` where `category_id` in (72065, 72066, 72260, 72459) 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 (272, 346, 9255, 11686, 11975, 45050, 57397, 60849, 72209, 95560, 98404, 109391) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (272, 346, 9255, 11686, 11975, 45050, 57397, 60849, 72209, 95560, 98404, 109391)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (272, 346, 9255, 11686, 11975, 45050, 57397, 60849, 72209, 95560, 98404, 109391)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (272, 346, 9255, 11686, 11975, 45050, 57397, 60849, 72209, 95560, 98404, 109391)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (272, 346, 9255, 11686, 11975, 45050, 57397, 60849, 72209, 95560, 98404, 109391)
select * from `products` where `products`.`id` in (2299, 5185, 5629, 6298, 6677, 8011, 11916, 15842, 63090, 98403, 101003, 105656) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (2299, 5185, 5629, 6298, 6677, 8011, 11916, 15842, 63090, 98403, 101003, 105656)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (2299, 5185, 5629, 6298, 6677, 8011, 11916, 15842, 63090, 98403, 101003, 105656)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (2299, 5185, 5629, 6298, 6677, 8011, 11916, 15842, 63090, 98403, 101003, 105656)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (2299, 5185, 5629, 6298, 6677, 8011, 11916, 15842, 63090, 98403, 101003, 105656)
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` = 101003 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` = 15842 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` = 98403 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` = 63090 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` = 105656 limit 1
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.191.70.86" ] "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.191.70.86" ] "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.191.70.86" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "18.191.70.86" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z_ke4zxsIc49S7Wzkw48UgAAAMA" "REDIRECT_URL" => "/catalog/piese-de-schimb-35/piese-tractoare-152725/ltz-72065" "REMOTE_ADDR" => "18.191.70.86" "REMOTE_PORT" => "52372" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-de-schimb-35/piese-tractoare-152725/ltz-72065" "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_ke4zxsIc49S7Wzkw48UgAAAMA" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744379619.4771 "REQUEST_TIME" => 1744379619 "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 13:53:40 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 => ""9cf61b28d5db455289ca5ee139c0f00b"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InVnc1l3cHg3T0tPVlN3NnNCemdzNHc9PSIsInZhbHVlIjoiZk5Uc29CZ2tra2M3a1wvaDJUXC8xMmJtU0ZhTWt4TnBBVHg5RjdCRDljMnhLcWNrYkZsQmhvcDdyY1wvSHpLbG02YSIsIm1hYyI6Ijg5MjE3MTA0MzZhYzUzMzAwNzQ4MmQ5YjU2ODEyOTFjOTNiYjY4YmE0M2ExMTM5YjQ4Yzc5MTNhYjQ1YmZjMzAifQ%3D%3D; expires=Fri, 11-Apr-2025 15:53:41 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InVnc1l3cHg3T0tPVlN3NnNCemdzNHc9PSIsInZhbHVlIjoiZk5Uc29CZ2tra2M3a1wvaDJUXC8xMmJtU0ZhTWt4TnBBVHg5RjdCRDljMnhLcWNrYkZsQmhvcDdyY1wvSHpLbG02YSIsI ▶" 1 => "agropiesemd_session=eyJpdiI6InRicUVha0ZGUHg3MkxFaUtoYTh4TXc9PSIsInZhbHVlIjoieUFBUURhcGpwSXpyaVhoMGlMUFU5YWlvWnV1a29ITm9YSnQ2ejRaYklYZ3FqN1pNU1hCeFJDXC84SVlWUE9cL1Y2IiwibWFjIjoiY2ViMTMwNTAxYWNhNDRjODM4NTU5NzIwNDliNTQ2ZWU1Yjc0MWU3NTRkMDllMzAyZjQzNTUwNTdhOTIxZjUxZCJ9; expires=Fri, 11-Apr-2025 15:53:41 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6InRicUVha0ZGUHg3MkxFaUtoYTh4TXc9PSIsInZhbHVlIjoieUFBUURhcGpwSXpyaVhoMGlMUFU5YWlvWnV1a29ITm9YSnQ2ejRaYklYZ3FqN1pNU1hCeFJDXC84SVlWUE9c ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InVnc1l3cHg3T0tPVlN3NnNCemdzNHc9PSIsInZhbHVlIjoiZk5Uc29CZ2tra2M3a1wvaDJUXC8xMmJtU0ZhTWt4TnBBVHg5RjdCRDljMnhLcWNrYkZsQmhvcDdyY1wvSHpLbG02YSIsIm1hYyI6Ijg5MjE3MTA0MzZhYzUzMzAwNzQ4MmQ5YjU2ODEyOTFjOTNiYjY4YmE0M2ExMTM5YjQ4Yzc5MTNhYjQ1YmZjMzAifQ%3D%3D; expires=Fri, 11-Apr-2025 15:53:41 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InVnc1l3cHg3T0tPVlN3NnNCemdzNHc9PSIsInZhbHVlIjoiZk5Uc29CZ2tra2M3a1wvaDJUXC8xMmJtU0ZhTWt4TnBBVHg5RjdCRDljMnhLcWNrYkZsQmhvcDdyY1wvSHpLbG02YSIsI ▶" 1 => "agropiesemd_session=eyJpdiI6InRicUVha0ZGUHg3MkxFaUtoYTh4TXc9PSIsInZhbHVlIjoieUFBUURhcGpwSXpyaVhoMGlMUFU5YWlvWnV1a29ITm9YSnQ2ejRaYklYZ3FqN1pNU1hCeFJDXC84SVlWUE9cL1Y2IiwibWFjIjoiY2ViMTMwNTAxYWNhNDRjODM4NTU5NzIwNDliNTQ2ZWU1Yjc0MWU3NTRkMDllMzAyZjQzNTUwNTdhOTIxZjUxZCJ9; expires=Fri, 11-Apr-2025 15:53:41 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6InRicUVha0ZGUHg3MkxFaUtoYTh4TXc9PSIsInZhbHVlIjoieUFBUURhcGpwSXpyaVhoMGlMUFU5YWlvWnV1a29ITm9YSnQ2ejRaYklYZ3FqN1pNU1hCeFJDXC84SVlWUE9c ▶" ] ]
0 of 0 array:7 [▶ "_token" => "3vtgtbtAfIcIrRreTp99xxch7XU6K087FNSXenUo" "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-tractoare-152725/ltz-72065" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
