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` = 'piese-de-schimb-pentru-demaroare-si-generatoare-152822' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (152822)
select * from `categories` where `categories`.`id` = 152822 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (152822)
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` = 152822 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, 152822)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (35, 152728, 152822)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 152822 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` = 152822 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` = 152822 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 (1043, 2250, 2641, 14790, 21888, 43692, 44377, 44379, 44380, 44381, 47304, 48411, 52308, 52309, 53499, 57972, 57973, 57974, 57975, 57976)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (1043, 2250, 2641, 14790, 21888, 43692, 44377, 44379, 44380, 44381, 47304, 48411, 52308, 52309, 53499, 57972, 57973, 57974, 57975, 57976)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (1043, 2250, 2641, 14790, 21888, 43692, 44377, 44379, 44380, 44381, 47304, 48411, 52308, 52309, 53499, 57972, 57973, 57974, 57975, 57976)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 11, 12, 13, 14, 30, 31, 33)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (1043, 2250, 2641, 14790, 21888, 43692, 44377, 44379, 44380, 44381, 47304, 48411, 52308, 52309, 53499, 57972, 57973, 57974, 57975, 57976)
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` = 1043 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` = 2250 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` = 2641 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` = 14790 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` = 21888 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (140276)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 140276 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, 140084, 140085, 140253, 140269, 140276, 146112)
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` = 43692 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` = 44377 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` = 44379 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (118425)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 118425 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, 118333, 118423, 118424, 118425, 146111)
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` = 44380 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` = 44381 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` = 47304 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (74933)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 74933 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, 73093, 74804, 74926, 74932, 74933, 152725)
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` = 48411 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` = 52308 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` = 52309 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` = 53499 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` = 57972 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (116035)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 116035 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, 115447, 116003, 116033, 116034, 116035, 146111)
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` = 57973 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` = 57974 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` = 57975 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` = 57976 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (115583)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 115583 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, 115447, 115554, 115581, 115582, 115583, 146111)
select `_lft`, `_rgt` from `categories` where `id` = 152822 limit 1
select * from `categories` where `categories`.`_lft` between 175805 and 175806 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: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 => "13.58.64.128" ] "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 => "13.58.64.128" ] "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" => "13.58.64.128" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "13.58.64.128" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z_h18rPh5RhQGc-zdb1jEAAAAAk" "REDIRECT_URL" => "/catalog/piese-de-schimb-35/piese-sistem-electric-152728/piese-de-schimb-pentru-demaroare-si-generatoare-152822" "REMOTE_ADDR" => "13.58.64.128" "REMOTE_PORT" => "40060" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-de-schimb-35/piese-sistem-electric-152728/piese-de-schimb-pentru-demaroare-si-generatoare-152822" "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_h18rPh5RhQGc-zdb1jEAAAAAk" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744336370.6984 "REQUEST_TIME" => 1744336370 "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 01:52:51 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 => ""0534a136341f072d4b5b2bb60ddf1e79"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxzQ01GNzhYWEV2dWdDZmcrN0ljSWc9PSIsInZhbHVlIjoiZGE4WTFuSG0wR0g5T21oS09cL1VhVjJUOHJxNXFiSlpjV2tjaTVFeXVhYXRTZlQxdE5CSXlCRjdrVlVmak92TnMiLCJtYWMiOiI5NTBmZTVhOWMxYjNjYmZmNWFjY2IyZDYyMWZkZTM5NWZmMjYzYWEzYWQ5NGU5NTdhM2I5MWQzY2JiYjhhZmRiIn0%3D; expires=Fri, 11-Apr-2025 03:52:52 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxzQ01GNzhYWEV2dWdDZmcrN0ljSWc9PSIsInZhbHVlIjoiZGE4WTFuSG0wR0g5T21oS09cL1VhVjJUOHJxNXFiSlpjV2tjaTVFeXVhYXRTZlQxdE5CSXlCRjdrVlVmak92TnMiLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6Ik5yZ2FWd1dHXC96K0xEN2l3RFpnckt3PT0iLCJ2YWx1ZSI6InU1Y0Vrb1ZrMThoSGgzclRjZ2pCSUJzbU56OE80STFXZ01JWWhjZTJscHphdFlST2YrSG8wTnQ1MXduazh4UHkiLCJtYWMiOiIxN2UyYjdkNDU3MGM5ZThiNjY0MzFmNWY1YjUzNjI4NzAxODgyY2MyOGMxY2M2MjJlMTEzOTgzNGViYmFhMmEwIn0%3D; expires=Fri, 11-Apr-2025 03:52:52 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6Ik5yZ2FWd1dHXC96K0xEN2l3RFpnckt3PT0iLCJ2YWx1ZSI6InU1Y0Vrb1ZrMThoSGgzclRjZ2pCSUJzbU56OE80STFXZ01JWWhjZTJscHphdFlST2YrSG8wTnQ1MXduazh4 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkxzQ01GNzhYWEV2dWdDZmcrN0ljSWc9PSIsInZhbHVlIjoiZGE4WTFuSG0wR0g5T21oS09cL1VhVjJUOHJxNXFiSlpjV2tjaTVFeXVhYXRTZlQxdE5CSXlCRjdrVlVmak92TnMiLCJtYWMiOiI5NTBmZTVhOWMxYjNjYmZmNWFjY2IyZDYyMWZkZTM5NWZmMjYzYWEzYWQ5NGU5NTdhM2I5MWQzY2JiYjhhZmRiIn0%3D; expires=Fri, 11-Apr-2025 03:52:52 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxzQ01GNzhYWEV2dWdDZmcrN0ljSWc9PSIsInZhbHVlIjoiZGE4WTFuSG0wR0g5T21oS09cL1VhVjJUOHJxNXFiSlpjV2tjaTVFeXVhYXRTZlQxdE5CSXlCRjdrVlVmak92TnMiLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6Ik5yZ2FWd1dHXC96K0xEN2l3RFpnckt3PT0iLCJ2YWx1ZSI6InU1Y0Vrb1ZrMThoSGgzclRjZ2pCSUJzbU56OE80STFXZ01JWWhjZTJscHphdFlST2YrSG8wTnQ1MXduazh4UHkiLCJtYWMiOiIxN2UyYjdkNDU3MGM5ZThiNjY0MzFmNWY1YjUzNjI4NzAxODgyY2MyOGMxY2M2MjJlMTEzOTgzNGViYmFhMmEwIn0%3D; expires=Fri, 11-Apr-2025 03:52:52 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6Ik5yZ2FWd1dHXC96K0xEN2l3RFpnckt3PT0iLCJ2YWx1ZSI6InU1Y0Vrb1ZrMThoSGgzclRjZ2pCSUJzbU56OE80STFXZ01JWWhjZTJscHphdFlST2YrSG8wTnQ1MXduazh4 ▶" ] ]
0 of 0 array:7 [▶ "_token" => "CLQ2putPtZso1OH6XuPpALKx8OtD26R4xjUAhLkJ" "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/piese-de-schimb-pentru-demaroare-si-generatoare-152822" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
