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` = 'nituri-152717' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (152717)
select * from `categories` where `categories`.`id` = 152717 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (152717)
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` = 152717 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 (36, 152691, 152717)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (36, 152691, 152717)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 152717 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 (161282)
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` = 152717 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` = 152717 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 (2321, 5050, 5446, 5851, 6497, 7473, 7868, 8390, 10096, 10826, 12436, 13386, 13836, 15385, 15556, 41916, 41917, 41918, 41919, 41920)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (2321, 5050, 5446, 5851, 6497, 7473, 7868, 8390, 10096, 10826, 12436, 13386, 13836, 15385, 15556, 41916, 41917, 41918, 41919, 41920)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (2321, 5050, 5446, 5851, 6497, 7473, 7868, 8390, 10096, 10826, 12436, 13386, 13836, 15385, 15556, 41916, 41917, 41918, 41919, 41920)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 11, 12, 13, 14, 30, 31, 33, 35, 39, 64)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (2321, 5050, 5446, 5851, 6497, 7473, 7868, 8390, 10096, 10826, 12436, 13386, 13836, 15385, 15556, 41916, 41917, 41918, 41919, 41920)
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` = 2321 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (152691)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 152691 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 (36, 152691)
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` = 5050 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` = 5446 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` = 5851 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` = 6497 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` = 7473 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` = 7868 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` = 8390 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` = 10096 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` = 10826 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` = 12436 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` = 13386 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` = 13836 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` = 15385 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` = 15556 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` = 41916 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` = 41917 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` = 41918 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` = 41919 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` = 41920 limit 1
select `_lft`, `_rgt` from `categories` where `id` = 152717 limit 1
select * from `categories` where `categories`.`_lft` between 175943 and 175946 and `_depth` < 4
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (152717, 161282)
select `product_to_category`.* from `product_to_category` inner join `products` on `products`.`id` = `product_to_category`.`product_id` where `category_id` in (152717, 161282) 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 (5446, 6497, 7473, 10826, 13386, 15556, 41916, 41919, 41920, 45511, 50612, 64118) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (5446, 6497, 7473, 10826, 13386, 15556, 41916, 41919, 41920, 45511, 50612, 64118)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (5446, 6497, 7473, 10826, 13386, 15556, 41916, 41919, 41920, 45511, 50612, 64118)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (5446, 6497, 7473, 10826, 13386, 15556, 41916, 41919, 41920, 45511, 50612, 64118)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (5446, 6497, 7473, 10826, 13386, 15556, 41916, 41919, 41920, 45511, 50612, 64118)
select * from `products` where `products`.`id` in (2321, 5050, 10096, 10826, 12436, 13386, 13836, 41918, 41923, 41924, 50612, 239254) and `products`.`deleted_at` is null
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (2321, 5050, 10096, 10826, 12436, 13386, 13836, 41918, 41923, 41924, 50612, 239254)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (2321, 5050, 10096, 10826, 12436, 13386, 13836, 41918, 41923, 41924, 50612, 239254)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (2321, 5050, 10096, 10826, 12436, 13386, 13836, 41918, 41923, 41924, 50612, 239254)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (2321, 5050, 10096, 10826, 12436, 13386, 13836, 41918, 41923, 41924, 50612, 239254)
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` = 239254 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 161282 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 (36, 152691, 152717, 161282)
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` = 50612 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 152717 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` = 41924 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` = 41923 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.246.216" ] "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.246.216" ] "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.246.216" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "18.191.246.216" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z_PHh1Y55Kb1NG1dZR80dwAAAME" "REDIRECT_URL" => "/catalog/piese-standartezate-36/alte-piese-standartezate-152691/nituri-152717" "REMOTE_ADDR" => "18.191.246.216" "REMOTE_PORT" => "36706" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-standartezate-36/alte-piese-standartezate-152691/nituri-152717" "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_PHh1Y55Kb1NG1dZR80dwAAAME" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744029575.9614 "REQUEST_TIME" => 1744029575 "argv" => [] "argc" => 0 ]
0 of 0 array:8 [▶ "cache-control" => array:1 [▶ 0 => "max-age=2628000, public" ] "date" => array:1 [▶ 0 => "Mon, 07 Apr 2025 12:39:37 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 => ""00c992bb795dd2caf86aab84a74b84a9"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InYxd2JET2ZMbjNuVEdkMFVkVlNDdHc9PSIsInZhbHVlIjoiQXgyQ2xhRFlwZFwvamNiY2dubFNWeGhkUEphMGxDdHh1aXdKdXhIdUNscWxsaUYrQXZ3TzFpbWNLd2x0a3VLQk8iLCJtYWMiOiI3YWE0OTU1ZjU5MWNiMjA4OTBhZjhkMjgzNGQzMTU1YTljMTA1MjFjYWJlYmE0MjUyNjEzZTg5NDQ2M2U5MDk5In0%3D; expires=Mon, 07-Apr-2025 14:39:40 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InYxd2JET2ZMbjNuVEdkMFVkVlNDdHc9PSIsInZhbHVlIjoiQXgyQ2xhRFlwZFwvamNiY2dubFNWeGhkUEphMGxDdHh1aXdKdXhIdUNscWxsaUYrQXZ3TzFpbWNLd2x0a3VLQk8iLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6IlBZa0Z6TW92NVpBbUhEVW0xUzNYdnc9PSIsInZhbHVlIjoiTitsdDVRQmRyQ0Y5c1gxeklmTnNXN0g1OWJjRTRSRTcyaFlvcStSdzllNGlHRklQdTBPd1FTeGpIUUNFZTVTSyIsIm1hYyI6ImFiMzE1N2E2YmMxMWE0OTMwMWFkOWU5NWM0M2JkOTUwYTgzYWVmN2UxNjUxMDg3MjA3NmVhNjI0Yzk5ZGM1ZjkifQ%3D%3D; expires=Mon, 07-Apr-2025 14:39:40 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6IlBZa0Z6TW92NVpBbUhEVW0xUzNYdnc9PSIsInZhbHVlIjoiTitsdDVRQmRyQ0Y5c1gxeklmTnNXN0g1OWJjRTRSRTcyaFlvcStSdzllNGlHRklQdTBPd1FTeGpIUUNFZTVT ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InYxd2JET2ZMbjNuVEdkMFVkVlNDdHc9PSIsInZhbHVlIjoiQXgyQ2xhRFlwZFwvamNiY2dubFNWeGhkUEphMGxDdHh1aXdKdXhIdUNscWxsaUYrQXZ3TzFpbWNLd2x0a3VLQk8iLCJtYWMiOiI3YWE0OTU1ZjU5MWNiMjA4OTBhZjhkMjgzNGQzMTU1YTljMTA1MjFjYWJlYmE0MjUyNjEzZTg5NDQ2M2U5MDk5In0%3D; expires=Mon, 07-Apr-2025 14:39:40 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InYxd2JET2ZMbjNuVEdkMFVkVlNDdHc9PSIsInZhbHVlIjoiQXgyQ2xhRFlwZFwvamNiY2dubFNWeGhkUEphMGxDdHh1aXdKdXhIdUNscWxsaUYrQXZ3TzFpbWNLd2x0a3VLQk8iLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6IlBZa0Z6TW92NVpBbUhEVW0xUzNYdnc9PSIsInZhbHVlIjoiTitsdDVRQmRyQ0Y5c1gxeklmTnNXN0g1OWJjRTRSRTcyaFlvcStSdzllNGlHRklQdTBPd1FTeGpIUUNFZTVTSyIsIm1hYyI6ImFiMzE1N2E2YmMxMWE0OTMwMWFkOWU5NWM0M2JkOTUwYTgzYWVmN2UxNjUxMDg3MjA3NmVhNjI0Yzk5ZGM1ZjkifQ%3D%3D; expires=Mon, 07-Apr-2025 14:39:40 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6IlBZa0Z6TW92NVpBbUhEVW0xUzNYdnc9PSIsInZhbHVlIjoiTitsdDVRQmRyQ0Y5c1gxeklmTnNXN0g1OWJjRTRSRTcyaFlvcStSdzllNGlHRklQdTBPd1FTeGpIUUNFZTVT ▶" ] ]
0 of 0 array:7 [▶ "_token" => "2pcjr1Z3tViuwGiowEwsXVTWNNTCXTZbtndYMBZr" "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-standartezate-36/alte-piese-standartezate-152691/nituri-152717" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
