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` = 'seturi-cu-pistoane-56' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (56)
select * from `categories` where `categories`.`id` = 56 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (56)
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` = 56 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, 56)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (36, 56)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 56 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 (152692, 152693)
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` = 56 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` = 56 and `products`.`stock` > 0 and `products`.`deleted_at` is null limit 20 offset 140
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (120337, 122576, 122595, 123664, 123665, 124421, 124926, 125441, 126050, 126051, 126052, 126053, 126055, 126056, 126057, 126058, 126612, 126613, 126614, 127564)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (120337, 122576, 122595, 123664, 123665, 124421, 124926, 125441, 126050, 126051, 126052, 126053, 126055, 126056, 126057, 126058, 126612, 126613, 126614, 127564)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (120337, 122576, 122595, 123664, 123665, 124421, 124926, 125441, 126050, 126051, 126052, 126053, 126055, 126056, 126057, 126058, 126612, 126613, 126614, 127564)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 11, 12, 13, 14, 30, 31, 33, 34, 236)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (120337, 122576, 122595, 123664, 123665, 124421, 124926, 125441, 126050, 126051, 126052, 126053, 126055, 126056, 126057, 126058, 126612, 126613, 126614, 127564)
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` = 120337 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 56 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` = 122576 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` = 122595 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` = 123664 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` = 123665 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` = 124421 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` = 124926 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` = 125441 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` = 126050 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` = 126051 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` = 126052 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` = 126053 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` = 126055 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` = 126056 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` = 126057 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` = 126058 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` = 126612 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` = 126613 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` = 126614 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` = 127564 limit 1
select `_lft`, `_rgt` from `categories` where `id` = 56 limit 1
select * from `categories` where `categories`.`_lft` between 175836 and 175841 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" => "8" ]
0 of 0 array:21 [▶ "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" ] "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjBHRTgrbVpYb1wvVVBuYVVac0RpNDFBPT0iLCJ2YWx1ZSI6IlNUXC96N2wzcW5MeDR3M3ZNUytxOFhWZXFUSjhkSnlMQXZYWm9RN3J0M1p5YTJ6MHQ5bms1S0pXY2toS0Q0RzEyIiwibWFjIjoiNmJlZDJiNmEzMjg2YjUzNWE4MmU0ZDA1MDJjMTM1M2JmZDFmNTFjNzkyY2FmMjZmY2MwODk2YjZhNWViNGFkNiJ9; agropiesemd_session=eyJpdiI6IlNYaHp1YUhtU1wvNFd2S3RSOXRDTE9nPT0iLCJ2YWx1ZSI6IjFxdzRMR1NXRURtKzMwamRLYVllOEhhY2U4NGFuQ1duU1hmc0JIbHZEUWx3RGRYVjg3R2hjbldNSEF5MEdsckQiLCJtYWMiOiIxZmI5NTY4OTMxN2ZlM2NiZjY0ZjViM2QxNzNhMDg4YjY0NjQyY2UxNGM5M2UzNzdkZDkzZGNiMThlNjM0NTNmIn0%3D ◀XSRF-TOKEN=eyJpdiI6IjBHRTgrbVpYb1wvVVBuYVVac0RpNDFBPT0iLCJ2YWx1ZSI6IlNUXC96N2wzcW5MeDR3M3ZNUytxOFhWZXFUSjhkSnlMQXZYWm9RN3J0M1p5YTJ6MHQ5bms1S0pXY2toS0Q0RzEyIiwib ▶" ] "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.138.183.117" ] "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.138.183.117" ] "if-none-match" => array:1 [▶ 0 => "" ] ]
0 of 0 array:53 [▶ "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_COOKIE" => "XSRF-TOKEN=eyJpdiI6IjBHRTgrbVpYb1wvVVBuYVVac0RpNDFBPT0iLCJ2YWx1ZSI6IlNUXC96N2wzcW5MeDR3M3ZNUytxOFhWZXFUSjhkSnlMQXZYWm9RN3J0M1p5YTJ6MHQ5bms1S0pXY2toS0Q0RzEyIiwibWFjIjoiNmJlZDJiNmEzMjg2YjUzNWE4MmU0ZDA1MDJjMTM1M2JmZDFmNTFjNzkyY2FmMjZmY2MwODk2YjZhNWViNGFkNiJ9; agropiesemd_session=eyJpdiI6IlNYaHp1YUhtU1wvNFd2S3RSOXRDTE9nPT0iLCJ2YWx1ZSI6IjFxdzRMR1NXRURtKzMwamRLYVllOEhhY2U4NGFuQ1duU1hmc0JIbHZEUWx3RGRYVjg3R2hjbldNSEF5MEdsckQiLCJtYWMiOiIxZmI5NTY4OTMxN2ZlM2NiZjY0ZjViM2QxNzNhMDg4YjY0NjQyY2UxNGM5M2UzNzdkZDkzZGNiMThlNjM0NTNmIn0%3D ◀XSRF-TOKEN=eyJpdiI6IjBHRTgrbVpYb1wvVVBuYVVac0RpNDFBPT0iLCJ2YWx1ZSI6IlNUXC96N2wzcW5MeDR3M3ZNUytxOFhWZXFUSjhkSnlMQXZYWm9RN3J0M1p5YTJ6MHQ5bms1S0pXY2toS0Q0RzEyIiwib ▶" "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.138.183.117" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "3.138.183.117" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "page=8" "REDIRECT_HTTPS" => "on" "REDIRECT_QUERY_STRING" => "page=8" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z_hQyC3rbQ3rooZHCj614gAAANI" "REDIRECT_URL" => "/catalog/piese-standartezate-36/seturi-cu-pistoane-56" "REMOTE_ADDR" => "3.138.183.117" "REMOTE_PORT" => "46634" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-standartezate-36/seturi-cu-pistoane-56?page=8" "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_hQyC3rbQ3rooZHCj614gAAANI" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744326856.6426 "REQUEST_TIME" => 1744326856 "argv" => array:1 [▶ 0 => "page=8" ] "argc" => 1 ]
0 of 0 array:2 [▶ "XSRF-TOKEN" => "gcl0xNDZScN1yBgoR5wL1zDumZVwZ3zt5EPNkH3M" "agropiesemd_session" => "DigqV4kP4pYeLDfT5fIxBVBvw0gOUzon0QCItvAe" ]
0 of 0 array:8 [▶ "cache-control" => array:1 [▶ 0 => "max-age=2628000, public" ] "date" => array:1 [▶ 0 => "Thu, 10 Apr 2025 23:14:17 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 => ""8de3b9ab38c5b40841b74d352ac46684"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjRzRkpKS1Y0T0pCZGtmalIyMERuN3c9PSIsInZhbHVlIjoiN0JSVzlKTVNMVjZqNHVPa2M4a2FCT1ZVdHI3TVh5ZGdONHpcL0s5VUF6dGI1RmNUMVwvd2o3RUFpXC9XdTRxVm14dCIsIm1hYyI6IjY2NmU3ZTAwMjg5Yjk3OTNkZjcwMTNiOGVjNzgxNTc4MjE3ZjBhNTA5YmNkZmM2ZTdiYzVlZTAxMmNlNWEyZjEifQ%3D%3D; expires=Fri, 11-Apr-2025 01:14:17 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRzRkpKS1Y0T0pCZGtmalIyMERuN3c9PSIsInZhbHVlIjoiN0JSVzlKTVNMVjZqNHVPa2M4a2FCT1ZVdHI3TVh5ZGdONHpcL0s5VUF6dGI1RmNUMVwvd2o3RUFpXC9XdTRxVm14dCIsI ▶" 1 => "agropiesemd_session=eyJpdiI6Im5YbnA1XC80czRSUmJaR1FDZjl2N0VnPT0iLCJ2YWx1ZSI6Im5pcHpLT0NSYXBFRUd2VXk3bVNNbjg1Sk1yQWlvbExLSmZuK2kxdUwxT3d1dk45bXFRcExGK3BrNnEzblluU1YiLCJtYWMiOiIxYTQ0Y2RkOGJhM2Q3ZjlkNTYwMzBkYjAxNDViNmQzYTE4YzcwNWM2NTAwYmMxMWJhMDVlOGFkOWMzNmQxNTE3In0%3D; expires=Fri, 11-Apr-2025 01:14:17 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6Im5YbnA1XC80czRSUmJaR1FDZjl2N0VnPT0iLCJ2YWx1ZSI6Im5pcHpLT0NSYXBFRUd2VXk3bVNNbjg1Sk1yQWlvbExLSmZuK2kxdUwxT3d1dk45bXFRcExGK3BrNnEzbllu ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjRzRkpKS1Y0T0pCZGtmalIyMERuN3c9PSIsInZhbHVlIjoiN0JSVzlKTVNMVjZqNHVPa2M4a2FCT1ZVdHI3TVh5ZGdONHpcL0s5VUF6dGI1RmNUMVwvd2o3RUFpXC9XdTRxVm14dCIsIm1hYyI6IjY2NmU3ZTAwMjg5Yjk3OTNkZjcwMTNiOGVjNzgxNTc4MjE3ZjBhNTA5YmNkZmM2ZTdiYzVlZTAxMmNlNWEyZjEifQ%3D%3D; expires=Fri, 11-Apr-2025 01:14:17 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRzRkpKS1Y0T0pCZGtmalIyMERuN3c9PSIsInZhbHVlIjoiN0JSVzlKTVNMVjZqNHVPa2M4a2FCT1ZVdHI3TVh5ZGdONHpcL0s5VUF6dGI1RmNUMVwvd2o3RUFpXC9XdTRxVm14dCIsI ▶" 1 => "agropiesemd_session=eyJpdiI6Im5YbnA1XC80czRSUmJaR1FDZjl2N0VnPT0iLCJ2YWx1ZSI6Im5pcHpLT0NSYXBFRUd2VXk3bVNNbjg1Sk1yQWlvbExLSmZuK2kxdUwxT3d1dk45bXFRcExGK3BrNnEzblluU1YiLCJtYWMiOiIxYTQ0Y2RkOGJhM2Q3ZjlkNTYwMzBkYjAxNDViNmQzYTE4YzcwNWM2NTAwYmMxMWJhMDVlOGFkOWMzNmQxNTE3In0%3D; expires=Fri, 11-Apr-2025 01:14:17 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6Im5YbnA1XC80czRSUmJaR1FDZjl2N0VnPT0iLCJ2YWx1ZSI6Im5pcHpLT0NSYXBFRUd2VXk3bVNNbjg1Sk1yQWlvbExLSmZuK2kxdUwxT3d1dk45bXFRcExGK3BrNnEzbllu ▶" ] ]
0 of 0 array:7 [▶ "_token" => "gcl0xNDZScN1yBgoR5wL1zDumZVwZ3zt5EPNkH3M" "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/seturi-cu-pistoane-56?page=8" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]