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
tyreCategory
loop
category
product
ix
localBussiness
rootCategories
seoBlockContent
select * from `category_den` where `url` = 'rulmenti-de-rostogolire-cu-bile-161290' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (161290)
select * from `categories` where `categories`.`id` = 161290 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (161290)
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` = 161290 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, 54, 161290)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (36, 54, 161290)
select `categories`.* from `categories` left join `category_orders` as `co` on `categories`.`id` = `co`.`category_id` where `parent_id` = 161290 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` = 161290 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` = 161290 and `products`.`stock` > 0 and `products`.`deleted_at` is null limit 20 offset 200
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (23520, 23521, 23522, 23524, 23536, 23815, 41573, 43233, 43234, 44361, 45373, 45374, 45375, 45376, 45377, 45378, 45379, 45380, 45381, 45382)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (23520, 23521, 23522, 23524, 23536, 23815, 41573, 43233, 43234, 44361, 45373, 45374, 45375, 45376, 45377, 45378, 45379, 45380, 45381, 45382)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (23520, 23521, 23522, 23524, 23536, 23815, 41573, 43233, 43234, 44361, 45373, 45374, 45375, 45376, 45377, 45378, 45379, 45380, 45381, 45382)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 7, 12, 13, 14, 17, 239, 240, 348, 352, 355, 356)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (23520, 23521, 23522, 23524, 23536, 23815, 41573, 43233, 43234, 44361, 45373, 45374, 45375, 45376, 45377, 45378, 45379, 45380, 45381, 45382)
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 `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, `co`.`order` asc
select * from `product_params` where `param_id` = 240
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (240)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 161290 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 161291 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, 54, 161291)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 161298 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, 54, 161298)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 161293 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, 54, 161293)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 161294 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, 54, 161294)
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` = 23520 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (113927)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 113927 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, 113631, 113855, 113906, 113919, 113927, 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` = 23521 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` = 23522 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` = 23524 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` = 23536 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` = 23815 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (5656)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 5656 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, 3215, 3216, 5644, 5654, 5656, 146108)
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` = 41573 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (109108)
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 109108 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, 104584, 109048, 109049, 109050, 109108, 152727)
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` = 43233 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` = 43234 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` = 44361 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` = 45373 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` = 45374 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` = 45375 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` = 45376 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` = 45377 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` = 45378 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` = 45379 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` = 45380 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` = 45381 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` = 45382 limit 1
select `_lft`, `_rgt` from `categories` where `id` = 161290 limit 1
select * from `categories` where `categories`.`_lft` between 175819 and 175820 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" => "11" ]
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 => "3.16.165.149" ] "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.16.165.149" ] "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" => "3.16.165.149" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "3.16.165.149" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "page=11" "REDIRECT_HTTPS" => "on" "REDIRECT_QUERY_STRING" => "page=11" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "aArvyh_JaPPd9WwzdKtJ0QAAAIw" "REDIRECT_URL" => "/catalog/piese-standartezate-36/rulmenti-54/rulmenti-de-rostogolire-cu-bile-161290" "REMOTE_ADDR" => "3.16.165.149" "REMOTE_PORT" => "41880" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/piese-standartezate-36/rulmenti-54/rulmenti-de-rostogolire-cu-bile-161290?page=11" "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" => "aArvyh_JaPPd9WwzdKtJ0QAAAIw" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745547210.7606 "REQUEST_TIME" => 1745547210 "argv" => array:1 [▶ 0 => "page=11" ] "argc" => 1 ]
[]
0 of 0 array:8 [▶ "cache-control" => array:1 [▶ 0 => "max-age=2628000, public" ] "date" => array:1 [▶ 0 => "Fri, 25 Apr 2025 02:13:31 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 => ""168139ad88e723d5c86117e537735caf"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImZsOXJHUEZJckZpN2FQXC9RWU1LVWpRPT0iLCJ2YWx1ZSI6IlBpUE45NUJONGhFQXJlMytcL3hJWHF5VEc5V1VRODVFcHdyNGNrRVVGZkVzdVlyRU1yWFg2cndEbEFCbGN1MkNtIiwibWFjIjoiNDdhODU1OThmMjRjMTAxYjc4MzlhZTc4NGQxMjFmMGViYjEzZjVjNGVkMmFhMzhlMWNjNDUzOWNhMjVlYWIzMiJ9; expires=Fri, 25-Apr-2025 04:13:32 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImZsOXJHUEZJckZpN2FQXC9RWU1LVWpRPT0iLCJ2YWx1ZSI6IlBpUE45NUJONGhFQXJlMytcL3hJWHF5VEc5V1VRODVFcHdyNGNrRVVGZkVzdVlyRU1yWFg2cndEbEFCbGN1MkNtIiwib ▶" 1 => "agropiesemd_session=eyJpdiI6ImgyM2dPNE1vRzhkTk9uZnR5UjZCZ3c9PSIsInZhbHVlIjoieGxFeEQwTlZXaHFoeUZGS2ZRM0N4bG9mdW43b3dKTERjeXo2M0dqc3NVUmVBcDl6V3lqMGVYaStDOVVMQVhRdiIsIm1hYyI6ImM4MTczZTM0NjM0NjY1Nzg4YWI3NTVmZmJhOTgyOTM1ODNhMDQ0N2Y4ZmZiY2I2ZjU3ODI0NWEwNWYwMmE3YjkifQ%3D%3D; expires=Fri, 25-Apr-2025 04:13:32 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImgyM2dPNE1vRzhkTk9uZnR5UjZCZ3c9PSIsInZhbHVlIjoieGxFeEQwTlZXaHFoeUZGS2ZRM0N4bG9mdW43b3dKTERjeXo2M0dqc3NVUmVBcDl6V3lqMGVYaStDOVVMQVhR ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImZsOXJHUEZJckZpN2FQXC9RWU1LVWpRPT0iLCJ2YWx1ZSI6IlBpUE45NUJONGhFQXJlMytcL3hJWHF5VEc5V1VRODVFcHdyNGNrRVVGZkVzdVlyRU1yWFg2cndEbEFCbGN1MkNtIiwibWFjIjoiNDdhODU1OThmMjRjMTAxYjc4MzlhZTc4NGQxMjFmMGViYjEzZjVjNGVkMmFhMzhlMWNjNDUzOWNhMjVlYWIzMiJ9; expires=Fri, 25-Apr-2025 04:13:32 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImZsOXJHUEZJckZpN2FQXC9RWU1LVWpRPT0iLCJ2YWx1ZSI6IlBpUE45NUJONGhFQXJlMytcL3hJWHF5VEc5V1VRODVFcHdyNGNrRVVGZkVzdVlyRU1yWFg2cndEbEFCbGN1MkNtIiwib ▶" 1 => "agropiesemd_session=eyJpdiI6ImgyM2dPNE1vRzhkTk9uZnR5UjZCZ3c9PSIsInZhbHVlIjoieGxFeEQwTlZXaHFoeUZGS2ZRM0N4bG9mdW43b3dKTERjeXo2M0dqc3NVUmVBcDl6V3lqMGVYaStDOVVMQVhRdiIsIm1hYyI6ImM4MTczZTM0NjM0NjY1Nzg4YWI3NTVmZmJhOTgyOTM1ODNhMDQ0N2Y4ZmZiY2I2ZjU3ODI0NWEwNWYwMmE3YjkifQ%3D%3D; expires=Fri, 25-Apr-2025 04:13:32 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImgyM2dPNE1vRzhkTk9uZnR5UjZCZ3c9PSIsInZhbHVlIjoieGxFeEQwTlZXaHFoeUZGS2ZRM0N4bG9mdW43b3dKTERjeXo2M0dqc3NVUmVBcDl6V3lqMGVYaStDOVVMQVhR ▶" ] ]
0 of 0 array:7 [▶ "_token" => "GgWJRrYGZdU8h3awo6A1tzerx3laamNCjSMruF4Y" "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/rulmenti-54/rulmenti-de-rostogolire-cu-bile-161290?page=11" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
