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
product
ix
localBussiness
rootCategories
seoBlockContent
select * from `category_den` where `url` = 'aripi-plastic-161271' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (161271)
select * from `categories` where `categories`.`id` = 161271 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (161271)
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` = 161271 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, 146108, 161271)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (35, 146108, 161271)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 161271 and `is_visible` = 1 order by COALESCE(co.order, 999) asc, `categories`.`id` asc
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` = 161271 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` = 161271 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 (232953, 232954, 232955, 232956, 232958, 232959, 232960, 232961, 232962, 232963, 232965, 232966, 232967, 232968, 232969, 232970, 232971, 232972, 233607, 233608)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (232953, 232954, 232955, 232956, 232958, 232959, 232960, 232961, 232962, 232963, 232965, 232966, 232967, 232968, 232969, 232970, 232971, 232972, 233607, 233608)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (232953, 232954, 232955, 232956, 232958, 232959, 232960, 232961, 232962, 232963, 232965, 232966, 232967, 232968, 232969, 232970, 232971, 232972, 233607, 233608)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (232953, 232954, 232955, 232956, 232958, 232959, 232960, 232961, 232962, 232963, 232965, 232966, 232967, 232968, 232969, 232970, 232971, 232972, 233607, 233608)
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` = 232953 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 161271 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` = 232954 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` = 232955 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` = 232956 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` = 232958 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` = 232959 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` = 232960 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` = 232961 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` = 232962 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` = 232963 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` = 232965 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` = 232966 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` = 232967 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` = 232968 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` = 232969 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` = 232970 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` = 232971 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` = 232972 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` = 233607 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` = 233608 limit 1
select `_lft`, `_rgt` from `categories` where `id` = 161271 limit 1
select * from `categories` where `categories`.`_lft` between 100615 and 100616 and `_depth` < 4
select `product_to_category`.* from `product_to_category` inner join `products` on `products`.`id` = `product_to_category`.`product_id` where `category_id` in (161271) 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 (232953, 232954, 232959, 232965, 232966, 232970, 233607, 249811, 249813, 249817, 249818, 249820) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (232953, 232954, 232959, 232965, 232966, 232970, 233607, 249811, 249813, 249817, 249818, 249820)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (232953, 232954, 232959, 232965, 232966, 232970, 233607, 249811, 249813, 249817, 249818, 249820)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (232953, 232954, 232959, 232965, 232966, 232970, 233607, 249811, 249813, 249817, 249818, 249820)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (232953, 232954, 232959, 232965, 232966, 232970, 233607, 249811, 249813, 249817, 249818, 249820)
select * from `products` where `products`.`id` in (232955, 232956, 232965, 232969, 232972, 233608, 249814, 249815, 249816, 249819, 249820, 249821) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (232955, 232956, 232965, 232969, 232972, 233608, 249814, 249815, 249816, 249819, 249820, 249821)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (232955, 232956, 232965, 232969, 232972, 233608, 249814, 249815, 249816, 249819, 249820, 249821)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (232955, 232956, 232965, 232969, 232972, 233608, 249814, 249815, 249816, 249819, 249820, 249821)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (232955, 232956, 232965, 232969, 232972, 233608, 249814, 249815, 249816, 249819, 249820, 249821)
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` = 249816 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` = 249815 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` = 249819 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` = 249821 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` = 249820 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` = 249814 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 => "3.143.214.6" ] "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.143.214.6" ] "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" => "3.143.214.6" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "3.143.214.6" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z_oPRvKoHy-RvIydU09CWAAAANc" "REDIRECT_URL" => "/catalog/piese-de-schimb-35/piese-camioane-146108/aripi-plastic-161271" "REMOTE_ADDR" => "3.143.214.6" "REMOTE_PORT" => "41936" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-de-schimb-35/piese-camioane-146108/aripi-plastic-161271" "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_oPRvKoHy-RvIydU09CWAAAANc" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744441158.9582 "REQUEST_TIME" => 1744441158 "argv" => [] "argc" => 0 ]
0 of 0 array:8 [▶ "cache-control" => array:1 [▶ 0 => "max-age=2628000, public" ] "date" => array:1 [▶ 0 => "Sat, 12 Apr 2025 06:59:19 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 => ""4fa6fe72186a4d53457a99f7818bbc66"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik5yMDh4dkc2OGtocXZkUEtJVmRCbEE9PSIsInZhbHVlIjoiWWVnVVJCZHdhSnkwSTJRK3FIZ1ZITUNCQlBUMmdBbTVhK0VvNE1vUWFLbW80QSthY29qZnVVazNWQitHbUFuXC8iLCJtYWMiOiJkMjBkMjY1MjdjYWRhOWY3ZDkzYzFmMDEyNTdiMTgyMDdjNjcwNmZjYzliNDhjYmNkMWQ0N2JlNmJmNDc2NWQ5In0%3D; expires=Sat, 12-Apr-2025 08:59:20 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik5yMDh4dkc2OGtocXZkUEtJVmRCbEE9PSIsInZhbHVlIjoiWWVnVVJCZHdhSnkwSTJRK3FIZ1ZITUNCQlBUMmdBbTVhK0VvNE1vUWFLbW80QSthY29qZnVVazNWQitHbUFuXC8iLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6ImZaXC9PK3lhODdnRkF5aWwwVGdUaUxBPT0iLCJ2YWx1ZSI6IndPTktZREUzalR1YXVyV0U5XC9qRWUyb1JsQVFCQWtJdis2cUZqcVVDXC9oVk1Rcmw2QWR5TWVkYWlneG9CVm13RSIsIm1hYyI6IjQ4NDg1NWM5OTEwOTEwMjQ4NTM2ZGMyM2EwZThhMjE3ZjQ0MjY4ZWQ1NDU0OGYxZGI3MDVmYjM4ODcxM2NjOGEifQ%3D%3D; expires=Sat, 12-Apr-2025 08:59:20 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImZaXC9PK3lhODdnRkF5aWwwVGdUaUxBPT0iLCJ2YWx1ZSI6IndPTktZREUzalR1YXVyV0U5XC9qRWUyb1JsQVFCQWtJdis2cUZqcVVDXC9oVk1Rcmw2QWR5TWVkYWlneG9C ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik5yMDh4dkc2OGtocXZkUEtJVmRCbEE9PSIsInZhbHVlIjoiWWVnVVJCZHdhSnkwSTJRK3FIZ1ZITUNCQlBUMmdBbTVhK0VvNE1vUWFLbW80QSthY29qZnVVazNWQitHbUFuXC8iLCJtYWMiOiJkMjBkMjY1MjdjYWRhOWY3ZDkzYzFmMDEyNTdiMTgyMDdjNjcwNmZjYzliNDhjYmNkMWQ0N2JlNmJmNDc2NWQ5In0%3D; expires=Sat, 12-Apr-2025 08:59:20 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik5yMDh4dkc2OGtocXZkUEtJVmRCbEE9PSIsInZhbHVlIjoiWWVnVVJCZHdhSnkwSTJRK3FIZ1ZITUNCQlBUMmdBbTVhK0VvNE1vUWFLbW80QSthY29qZnVVazNWQitHbUFuXC8iLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6ImZaXC9PK3lhODdnRkF5aWwwVGdUaUxBPT0iLCJ2YWx1ZSI6IndPTktZREUzalR1YXVyV0U5XC9qRWUyb1JsQVFCQWtJdis2cUZqcVVDXC9oVk1Rcmw2QWR5TWVkYWlneG9CVm13RSIsIm1hYyI6IjQ4NDg1NWM5OTEwOTEwMjQ4NTM2ZGMyM2EwZThhMjE3ZjQ0MjY4ZWQ1NDU0OGYxZGI3MDVmYjM4ODcxM2NjOGEifQ%3D%3D; expires=Sat, 12-Apr-2025 08:59:20 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImZaXC9PK3lhODdnRkF5aWwwVGdUaUxBPT0iLCJ2YWx1ZSI6IndPTktZREUzalR1YXVyV0U5XC9qRWUyb1JsQVFCQWtJdis2cUZqcVVDXC9oVk1Rcmw2QWR5TWVkYWlneG9C ▶" ] ]
0 of 0 array:7 [▶ "_token" => "Vogo3EuvEwJkZIx96EDwJPlgEPZYjcOjmphDfAnS" "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-camioane-146108/aripi-plastic-161271" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
