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-masini-de-tratat-seminte-159019' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (159019)
select * from `categories` where `categories`.`id` = 159019 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (159019)
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` = 159019 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, 152726, 159019)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (35, 152726, 159019)
select count(*) as aggregate from `pdf_catalogs` where `category_id` = 152726 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` = 159019 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` = 159019 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` = 159019 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 (110074, 112335, 112338, 112339, 112340, 112344, 112345, 112346, 112347, 112349, 112350, 112351, 112353, 112354, 112355, 123587, 123588, 123589, 123591, 123592)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (110074, 112335, 112338, 112339, 112340, 112344, 112345, 112346, 112347, 112349, 112350, 112351, 112353, 112354, 112355, 123587, 123588, 123589, 123591, 123592)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (110074, 112335, 112338, 112339, 112340, 112344, 112345, 112346, 112347, 112349, 112350, 112351, 112353, 112354, 112355, 123587, 123588, 123589, 123591, 123592)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 12, 14, 303)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (110074, 112335, 112338, 112339, 112340, 112344, 112345, 112346, 112347, 112349, 112350, 112351, 112353, 112354, 112355, 123587, 123588, 123589, 123591, 123592)
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` = 110074 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 159019 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` = 112335 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` = 112338 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` = 112339 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` = 112340 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` = 112344 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` = 112345 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` = 112346 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` = 112347 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` = 112349 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` = 112350 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` = 112351 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` = 112353 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` = 112354 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` = 112355 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` = 123587 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` = 123588 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` = 123589 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` = 123591 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` = 123592 limit 1
select `_lft`, `_rgt` from `categories` where `id` = 159019 limit 1
select * from `categories` where `categories`.`_lft` between 168481 and 168482 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 (159019) 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 (112338, 112340, 112344, 112345, 112350, 112354, 123588, 123597, 123602, 132383, 133359, 247909) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (112338, 112340, 112344, 112345, 112350, 112354, 123588, 123597, 123602, 132383, 133359, 247909)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (112338, 112340, 112344, 112345, 112350, 112354, 123588, 123597, 123602, 132383, 133359, 247909)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (112338, 112340, 112344, 112345, 112350, 112354, 123588, 123597, 123602, 132383, 133359, 247909)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (112338, 112340, 112344, 112345, 112350, 112354, 123588, 123597, 123602, 132383, 133359, 247909)
select * from `products` where `products`.`id` in (112335, 112338, 112340, 112354, 123588, 123589, 123597, 123599, 134716, 134718, 140269, 247909) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (112335, 112338, 112340, 112354, 123588, 123589, 123597, 123599, 134716, 134718, 140269, 247909)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (112335, 112338, 112340, 112354, 123588, 123589, 123597, 123599, 134716, 134718, 140269, 247909)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (112335, 112338, 112340, 112354, 123588, 123589, 123597, 123599, 134716, 134718, 140269, 247909)
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 (112335, 112338, 112340, 112354, 123588, 123589, 123597, 123599, 134716, 134718, 140269, 247909)
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` = 134718 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` = 140269 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` = 247909 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` = 123599 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` = 134716 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` = 123597 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 => "52.14.88.125" ] "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 => "52.14.88.125" ] "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" => "52.14.88.125" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "52.14.88.125" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z_inRzxsIc49S7Wzkw7wngAAANg" "REDIRECT_URL" => "/catalog/piese-de-schimb-35/piese-tehnica-agricola-152726/piese-masini-de-tratat-seminte-159019" "REMOTE_ADDR" => "52.14.88.125" "REMOTE_PORT" => "42404" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-de-schimb-35/piese-tehnica-agricola-152726/piese-masini-de-tratat-seminte-159019" "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_inRzxsIc49S7Wzkw7wngAAANg" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744348999.6074 "REQUEST_TIME" => 1744348999 "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 05:23:20 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 => ""1216374fd57460aaec65c2a1baa87974"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkJzU1hGb1d2YU80Tm9DS0ZaNEV1S2c9PSIsInZhbHVlIjoiT1FwbXpsc0MzM1ZqQUtVNmpqVmZhYkpOb1hWeHRYZkhkZXVQNFZvZDFkS1lRcnZoWHQ0Tisxa1ZSQnAwb1pnayIsIm1hYyI6IjExODE0MDhhNmVmMWQ0Y2EyZGY1ZjMxMDdkYzAxNDYyZWRlZDk3MTk2MDgzMTk2ZWU2YjRiNTlhMDI5OTE0MzUifQ%3D%3D; expires=Fri, 11-Apr-2025 07:23:21 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJzU1hGb1d2YU80Tm9DS0ZaNEV1S2c9PSIsInZhbHVlIjoiT1FwbXpsc0MzM1ZqQUtVNmpqVmZhYkpOb1hWeHRYZkhkZXVQNFZvZDFkS1lRcnZoWHQ0Tisxa1ZSQnAwb1pnayIsIm1hY ▶" 1 => "agropiesemd_session=eyJpdiI6Ilc4XC9RODRxMVwvc0Izb2d6RDByVEpkQT09IiwidmFsdWUiOiJjRWFHVW01Q0pBeExTWTBrUlV6Q1lmYktlaFpCK09Tc3FoeUZkOG1vWVVDUGtpajNXajBmMmZwRjRsRlM2REpTIiwibWFjIjoiYmFlNDYzNTQzNDRkZmI1MDNjNWZlOTZkZWQ3ODlkMTU5NjVjZTllMzc0ZmUwNTMyYjU2MWNkMjMwYmM3ZmZhZCJ9; expires=Fri, 11-Apr-2025 07:23:21 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6Ilc4XC9RODRxMVwvc0Izb2d6RDByVEpkQT09IiwidmFsdWUiOiJjRWFHVW01Q0pBeExTWTBrUlV6Q1lmYktlaFpCK09Tc3FoeUZkOG1vWVVDUGtpajNXajBmMmZwRjRsRlM2 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkJzU1hGb1d2YU80Tm9DS0ZaNEV1S2c9PSIsInZhbHVlIjoiT1FwbXpsc0MzM1ZqQUtVNmpqVmZhYkpOb1hWeHRYZkhkZXVQNFZvZDFkS1lRcnZoWHQ0Tisxa1ZSQnAwb1pnayIsIm1hYyI6IjExODE0MDhhNmVmMWQ0Y2EyZGY1ZjMxMDdkYzAxNDYyZWRlZDk3MTk2MDgzMTk2ZWU2YjRiNTlhMDI5OTE0MzUifQ%3D%3D; expires=Fri, 11-Apr-2025 07:23:21 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJzU1hGb1d2YU80Tm9DS0ZaNEV1S2c9PSIsInZhbHVlIjoiT1FwbXpsc0MzM1ZqQUtVNmpqVmZhYkpOb1hWeHRYZkhkZXVQNFZvZDFkS1lRcnZoWHQ0Tisxa1ZSQnAwb1pnayIsIm1hY ▶" 1 => "agropiesemd_session=eyJpdiI6Ilc4XC9RODRxMVwvc0Izb2d6RDByVEpkQT09IiwidmFsdWUiOiJjRWFHVW01Q0pBeExTWTBrUlV6Q1lmYktlaFpCK09Tc3FoeUZkOG1vWVVDUGtpajNXajBmMmZwRjRsRlM2REpTIiwibWFjIjoiYmFlNDYzNTQzNDRkZmI1MDNjNWZlOTZkZWQ3ODlkMTU5NjVjZTllMzc0ZmUwNTMyYjU2MWNkMjMwYmM3ZmZhZCJ9; expires=Fri, 11-Apr-2025 07:23:21 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6Ilc4XC9RODRxMVwvc0Izb2d6RDByVEpkQT09IiwidmFsdWUiOiJjRWFHVW01Q0pBeExTWTBrUlV6Q1lmYktlaFpCK09Tc3FoeUZkOG1vWVVDUGtpajNXajBmMmZwRjRsRlM2 ▶" ] ]
0 of 0 array:7 [▶ "_token" => "jumOcknNNzsA5j9R53uK7JQ3SqRJYjAVmtQXWzUW" "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-tehnica-agricola-152726/piese-masini-de-tratat-seminte-159019" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
