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` = 'pentru-auto-de-import-160172' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (160172)
select * from `categories` where `categories`.`id` = 160172 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (160172)
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` = 160172 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, 152728, 152823, 160172)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (35, 152728, 152823, 160172)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 160172 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` = 160172 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` = 160172 and `products`.`stock` > 0 and `products`.`deleted_at` is null limit 20 offset 120
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (95643, 98277, 98280, 98282, 99810, 99811, 99817, 99821, 99822, 99824, 99825, 99836, 99839, 99846, 99854, 99857, 99865, 99866, 99869, 99873)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (95643, 98277, 98280, 98282, 99810, 99811, 99817, 99821, 99822, 99824, 99825, 99836, 99839, 99846, 99854, 99857, 99865, 99866, 99869, 99873)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (95643, 98277, 98280, 98282, 99810, 99811, 99817, 99821, 99822, 99824, 99825, 99836, 99839, 99846, 99854, 99857, 99865, 99866, 99869, 99873)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 11, 14)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (95643, 98277, 98280, 98282, 99810, 99811, 99817, 99821, 99822, 99824, 99825, 99836, 99839, 99846, 99854, 99857, 99865, 99866, 99869, 99873)
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` = 95643 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 160172 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` = 98277 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (152759)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 152759 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, 152759)
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` = 98280 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` = 98282 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` = 99810 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` = 99811 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` = 99817 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (152689)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 152689 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, 152689, 152728)
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` = 99821 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` = 99822 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` = 99824 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` = 99825 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` = 99836 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` = 99839 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` = 99846 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` = 99854 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` = 99857 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` = 99865 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` = 99866 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (152758)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 152758 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, 152758)
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` = 99869 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` = 99873 limit 1
select `_lft`, `_rgt` from `categories` where `id` = 160172 limit 1
select * from `categories` where `categories`.`_lft` between 175810 and 175811 and `_depth` < 4
select `product_to_category`.* from `product_to_category` inner join `products` on `products`.`id` = `product_to_category`.`product_id` where 0 = 1 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:1 [▶ "page" => "7" ]
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.222.233.22" ] "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.222.233.22" ] "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" => "18.222.233.22" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "18.222.233.22" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "page=7" "REDIRECT_HTTPS" => "on" "REDIRECT_QUERY_STRING" => "page=7" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "aAWUIm0Ze3tSHukdNibASgAAARM" "REDIRECT_URL" => "/catalog/piese-de-schimb-35/piese-sistem-electric-152728/echipament-eluminare-152823/pentru-auto-de-import-160172" "REMOTE_ADDR" => "18.222.233.22" "REMOTE_PORT" => "51484" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-de-schimb-35/piese-sistem-electric-152728/echipament-eluminare-152823/pentru-auto-de-import-160172?page=7" "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" => "aAWUIm0Ze3tSHukdNibASgAAARM" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745196066.7638 "REQUEST_TIME" => 1745196066 "argv" => array:1 [▶ 0 => "page=7" ] "argc" => 1 ]
[]
0 of 0 array:8 [▶ "cache-control" => array:1 [▶ 0 => "max-age=2628000, public" ] "date" => array:1 [▶ 0 => "Mon, 21 Apr 2025 00:41:07 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 => ""6dceac4598847d34c3d3c5a06f6ff06c"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkpHTHJsM0xqTUxjSWhieTV5Mnp2bXc9PSIsInZhbHVlIjoidzBlbnhsWEpLbjVsK0ZvdUJVQjNUWU51bCtuMWkyQVcrYkNUUFp6UDFzRVdoeGpCeGZOekJ6d29iUTc1SEU5QSIsIm1hYyI6ImQyZTAwMGE4ZDY0NjAxYTQxZGU3MTZlYTVkYmIzOGY2ZGZlMmQ2OGEyZGM2N2Y5ODY3NDM5NDUxMWM2ZjY1YzIifQ%3D%3D; expires=Mon, 21-Apr-2025 02:41:08 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkpHTHJsM0xqTUxjSWhieTV5Mnp2bXc9PSIsInZhbHVlIjoidzBlbnhsWEpLbjVsK0ZvdUJVQjNUWU51bCtuMWkyQVcrYkNUUFp6UDFzRVdoeGpCeGZOekJ6d29iUTc1SEU5QSIsIm1hY ▶" 1 => "agropiesemd_session=eyJpdiI6InBhSWhJQ2dcL2pZM1ptSVl2MmV5TXVBPT0iLCJ2YWx1ZSI6IlhBcXJ4T1NIYUdsSXhVT0ZtMHBnUmxOOHMxSUhQTDY2dXU0bDdJWTdOOFBSaThmMDNkTEtGZFE5ZXZKVllSVWsiLCJtYWMiOiIyZTk3NDE0OTMzODYyYmYzYjA4MjEwNWYyYTZkMzE1ZmZlYTNkNTM4M2QyNWEzNjlmNzEzYjg0MjFiMTEzMzg4In0%3D; expires=Mon, 21-Apr-2025 02:41:08 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6InBhSWhJQ2dcL2pZM1ptSVl2MmV5TXVBPT0iLCJ2YWx1ZSI6IlhBcXJ4T1NIYUdsSXhVT0ZtMHBnUmxOOHMxSUhQTDY2dXU0bDdJWTdOOFBSaThmMDNkTEtGZFE5ZXZKVllS ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkpHTHJsM0xqTUxjSWhieTV5Mnp2bXc9PSIsInZhbHVlIjoidzBlbnhsWEpLbjVsK0ZvdUJVQjNUWU51bCtuMWkyQVcrYkNUUFp6UDFzRVdoeGpCeGZOekJ6d29iUTc1SEU5QSIsIm1hYyI6ImQyZTAwMGE4ZDY0NjAxYTQxZGU3MTZlYTVkYmIzOGY2ZGZlMmQ2OGEyZGM2N2Y5ODY3NDM5NDUxMWM2ZjY1YzIifQ%3D%3D; expires=Mon, 21-Apr-2025 02:41:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkpHTHJsM0xqTUxjSWhieTV5Mnp2bXc9PSIsInZhbHVlIjoidzBlbnhsWEpLbjVsK0ZvdUJVQjNUWU51bCtuMWkyQVcrYkNUUFp6UDFzRVdoeGpCeGZOekJ6d29iUTc1SEU5QSIsIm1hY ▶" 1 => "agropiesemd_session=eyJpdiI6InBhSWhJQ2dcL2pZM1ptSVl2MmV5TXVBPT0iLCJ2YWx1ZSI6IlhBcXJ4T1NIYUdsSXhVT0ZtMHBnUmxOOHMxSUhQTDY2dXU0bDdJWTdOOFBSaThmMDNkTEtGZFE5ZXZKVllSVWsiLCJtYWMiOiIyZTk3NDE0OTMzODYyYmYzYjA4MjEwNWYyYTZkMzE1ZmZlYTNkNTM4M2QyNWEzNjlmNzEzYjg0MjFiMTEzMzg4In0%3D; expires=Mon, 21-Apr-2025 02:41:08 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6InBhSWhJQ2dcL2pZM1ptSVl2MmV5TXVBPT0iLCJ2YWx1ZSI6IlhBcXJ4T1NIYUdsSXhVT0ZtMHBnUmxOOHMxSUhQTDY2dXU0bDdJWTdOOFBSaThmMDNkTEtGZFE5ZXZKVllS ▶" ] ]
0 of 0 array:7 [▶ "_token" => "UJfCUJXR2IVhKmAN7MXVgHrgEDRBlGMHDefE2w9t" "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-sistem-electric-152728/echipament-eluminare-152823/pentru-auto-de-import-160172?page=7" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
