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
pageUrl
switchUrl
alternateLang
model
reviews
mProducts
categoryDen
obLevel
__env
app
breadCrumbList
breadCrumbHtml
errors
isManufacturerCountryExists
__currentLoopData
product
loop
param
localBussiness
rootCategories
seoBlockContent
select * from `category_den` where `url` = 'competus-h-p3' and `lang` = 'ro' limit 1
select * from `product_data` where `url` = 'competus-h-p3' and `lang` = 'ro' limit 1
select * from `models` where `url` = 'competus-h-p3' limit 1
select * from `model_descriptions` where `lang` = 'ro' and `model_descriptions`.`model_id` in (2100)
select * from `category_den` where `url` = 'autoturisme-12' and `lang` = 'ro' limit 1
select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (12)
select * from `categories` where `categories`.`id` = 12 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (12)
select * from `manufacturers` where `manufacturers`.`id` = 46 limit 1
select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 12 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 (5, 12)
select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (5, 12)
select count(*) as aggregate from `model_reviews` where `model_reviews`.`model_id` = 2100 and `model_reviews`.`model_id` is not null and `published` = 1
select `products`.*, `radius`.`param_value` as `radius`, `width`.`param_value` as `width`, `height`.`param_value` as `height` from `products` left join `product_params` as `radius` on `products`.`id` = `radius`.`product_id` and `radius`.`param_id` = 74 left join `product_params` as `width` on `products`.`id` = `width`.`product_id` and `width`.`param_id` = 7 left join `product_params` as `height` on `products`.`id` = `height`.`product_id` and `height`.`param_id` = 5 where `model_id` = 2100 and (`radius`.`param_value` is not null and `width`.`param_value` is not null and `height`.`param_value` is not null) and `products`.`deleted_at` is null group by `products`.`id` order by `radius`.`param_value` asc, `width`.`param_value` asc, `height`.`param_value` asc
select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (262371, 262372, 263506, 263664, 263665, 264118, 264119, 264138, 264139, 264140, 264141, 266913, 266914, 268102, 268103)
select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (262371, 262372, 263506, 263664, 263665, 264118, 264119, 264138, 264139, 264140, 264141, 266913, 266914, 268102, 268103)
select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (262371, 262372, 263506, 263664, 263665, 264118, 264119, 264138, 264139, 264140, 264141, 266913, 266914, 268102, 268103)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 5, 7, 10, 12, 14, 15, 16, 17, 74, 164, 203, 204, 205, 367)
select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (262371, 262372, 263506, 263664, 263665, 264118, 264119, 264138, 264139, 264140, 264141, 266913, 266914, 268102, 268103)
select * from `params` where `lang` = 'ro' and `params`.`param_id` in (10)
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
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` = 268103 limit 1
select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (13)
200
[]
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=eyJpdiI6Ik1qSmY1bnlEZHg4WlwvUkZrbnVVbCtRPT0iLCJ2YWx1ZSI6IjRaTjVKZW5jWU9YYlI0bTdRKzRQN1wvM0FRWXRSMVdIMDBmOWZDTE1qenJWWDZ5VGVzd2FJSHE2d1ppZlEwUnJCIiwibWFjIjoiMGY1MDBkZTk5M2QzNjY1OTQ4Yzg4YTE0OWVkZTIxNTYwNTQ2NmU5YjIzODUxMTQwNzQ4ODkzZWY0MjQ2ZTlhMyJ9; agropiesemd_session=eyJpdiI6ImxCQThcL1hiaDJ3dHBzRGZDMGpVMDVnPT0iLCJ2YWx1ZSI6IlRpZzBEcDM0b1l0a0hib1k3b3lqMHA5R05ibjluSndEYjVvbDZxME9xNzQ4U3dSVmFCUDNaMHc1YjhcL0hLelQyIiwibWFjIjoiOWUwMGNhZTZkMDNlOWM1ZTViNzFkYjAyOTU5MjkwYTdmMWY1OTQxNmI0YTUyMDJjZGVlNDVjOGYzZjFmODdmZSJ9 ◀XSRF-TOKEN=eyJpdiI6Ik1qSmY1bnlEZHg4WlwvUkZrbnVVbCtRPT0iLCJ2YWx1ZSI6IjRaTjVKZW5jWU9YYlI0bTdRKzRQN1wvM0FRWXRSMVdIMDBmOWZDTE1qenJWWDZ5VGVzd2FJSHE2d1ppZlEwUnJCIiwib ▶" ] "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.219.215.35" ] "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.219.215.35" ] "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_COOKIE" => "XSRF-TOKEN=eyJpdiI6Ik1qSmY1bnlEZHg4WlwvUkZrbnVVbCtRPT0iLCJ2YWx1ZSI6IjRaTjVKZW5jWU9YYlI0bTdRKzRQN1wvM0FRWXRSMVdIMDBmOWZDTE1qenJWWDZ5VGVzd2FJSHE2d1ppZlEwUnJCIiwibWFjIjoiMGY1MDBkZTk5M2QzNjY1OTQ4Yzg4YTE0OWVkZTIxNTYwNTQ2NmU5YjIzODUxMTQwNzQ4ODkzZWY0MjQ2ZTlhMyJ9; agropiesemd_session=eyJpdiI6ImxCQThcL1hiaDJ3dHBzRGZDMGpVMDVnPT0iLCJ2YWx1ZSI6IlRpZzBEcDM0b1l0a0hib1k3b3lqMHA5R05ibjluSndEYjVvbDZxME9xNzQ4U3dSVmFCUDNaMHc1YjhcL0hLelQyIiwibWFjIjoiOWUwMGNhZTZkMDNlOWM1ZTViNzFkYjAyOTU5MjkwYTdmMWY1OTQxNmI0YTUyMDJjZGVlNDVjOGYzZjFmODdmZSJ9 ◀XSRF-TOKEN=eyJpdiI6Ik1qSmY1bnlEZHg4WlwvUkZrbnVVbCtRPT0iLCJ2YWx1ZSI6IjRaTjVKZW5jWU9YYlI0bTdRKzRQN1wvM0FRWXRSMVdIMDBmOWZDTE1qenJWWDZ5VGVzd2FJSHE2d1ppZlEwUnJCIiwib ▶" "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.219.215.35" "HTTP_X_FORWARDED_HOST" => "agropiese.md" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_SERVER" => "agropiese.md" "HTTP_X_REAL_IP" => "18.219.215.35" "PATH" => "/bin:/usr/bin:/usr/local/php/bin" "PHPRC" => "/home/agropie" "QUERY_STRING" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_STATUS" => "200" "REDIRECT_UNIQUE_ID" => "Z_tj4EoHlUVDzFDB__s8UgAAAM8" "REDIRECT_URL" => "/catalog/anvelope-5/autoturisme-12/competus-h-p3" "REMOTE_ADDR" => "18.219.215.35" "REMOTE_PORT" => "44570" "REQUEST_METHOD" => "GET" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/catalog/anvelope-5/autoturisme-12/competus-h-p3" "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_tj4EoHlUVDzFDB__s8UgAAAM8" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744528352.494 "REQUEST_TIME" => 1744528352 "argv" => [] "argc" => 0 ]
0 of 0 array:2 [▶ "XSRF-TOKEN" => "Tb62uTP6paTPoPF0VMlnvnwotdMPM6poGwnarWwp" "agropiesemd_session" => "JNQHgykfOnltGFGPD6JhxmwdLu11JR5ONpyduUC6" ]
0 of 0 array:8 [▶ "cache-control" => array:1 [▶ 0 => "max-age=2628000, public" ] "date" => array:1 [▶ 0 => "Sun, 13 Apr 2025 07:12:32 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 => ""08e9eb97b5054f0cc95c03915c3869e4"" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Imd2TWxmeTBGcDh1RkNtazkwN1VWbmc9PSIsInZhbHVlIjoiSVQ0d1RpM2NuVmpleUJ1Q3F1QjlFSVFjWUF2R2F1YThhUlg5NjRRWUM3YXNRdjNVbVwvRHN2MlJaRmdUdmVUVE8iLCJtYWMiOiJkMTlmZGYzMTE0ZDA1Y2VkZTQxOWM3NDA3ZWE5Njc1NjE2Mjc4YWM2NTg3NTQ1ZDcwZTI1ZGM3Mzg0ZmJmYTAwIn0%3D; expires=Sun, 13-Apr-2025 09:12:32 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Imd2TWxmeTBGcDh1RkNtazkwN1VWbmc9PSIsInZhbHVlIjoiSVQ0d1RpM2NuVmpleUJ1Q3F1QjlFSVFjWUF2R2F1YThhUlg5NjRRWUM3YXNRdjNVbVwvRHN2MlJaRmdUdmVUVE8iLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6IlRqb3FweUQyMTNtUTk2c1N6ZmxJV2c9PSIsInZhbHVlIjoiTGpXVFl2ZWY2eGVzNUt6b2dFV2czU3pObFJLNjZmWHVTSU5cL0VSYU5oZHlPbXNxU083dzZSQzFwMmpzbUFQVm0iLCJtYWMiOiJlMzM4NzdlOGIzNjc3YzJkOTcxMDk3ZmVkOThhMzRhNGQ1OTU2NGU1OTgxYWUzMzYxYmFhM2IzOGIzM2Q5Nzk2In0%3D; expires=Sun, 13-Apr-2025 09:12:32 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6IlRqb3FweUQyMTNtUTk2c1N6ZmxJV2c9PSIsInZhbHVlIjoiTGpXVFl2ZWY2eGVzNUt6b2dFV2czU3pObFJLNjZmWHVTSU5cL0VSYU5oZHlPbXNxU083dzZSQzFwMmpzbUFQ ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Imd2TWxmeTBGcDh1RkNtazkwN1VWbmc9PSIsInZhbHVlIjoiSVQ0d1RpM2NuVmpleUJ1Q3F1QjlFSVFjWUF2R2F1YThhUlg5NjRRWUM3YXNRdjNVbVwvRHN2MlJaRmdUdmVUVE8iLCJtYWMiOiJkMTlmZGYzMTE0ZDA1Y2VkZTQxOWM3NDA3ZWE5Njc1NjE2Mjc4YWM2NTg3NTQ1ZDcwZTI1ZGM3Mzg0ZmJmYTAwIn0%3D; expires=Sun, 13-Apr-2025 09:12:32 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Imd2TWxmeTBGcDh1RkNtazkwN1VWbmc9PSIsInZhbHVlIjoiSVQ0d1RpM2NuVmpleUJ1Q3F1QjlFSVFjWUF2R2F1YThhUlg5NjRRWUM3YXNRdjNVbVwvRHN2MlJaRmdUdmVUVE8iLCJtY ▶" 1 => "agropiesemd_session=eyJpdiI6IlRqb3FweUQyMTNtUTk2c1N6ZmxJV2c9PSIsInZhbHVlIjoiTGpXVFl2ZWY2eGVzNUt6b2dFV2czU3pObFJLNjZmWHVTSU5cL0VSYU5oZHlPbXNxU083dzZSQzFwMmpzbUFQVm0iLCJtYWMiOiJlMzM4NzdlOGIzNjc3YzJkOTcxMDk3ZmVkOThhMzRhNGQ1OTU2NGU1OTgxYWUzMzYxYmFhM2IzOGIzM2Q5Nzk2In0%3D; expires=Sun, 13-Apr-2025 09:12:32 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6IlRqb3FweUQyMTNtUTk2c1N6ZmxJV2c9PSIsInZhbHVlIjoiTGpXVFl2ZWY2eGVzNUt6b2dFV2czU3pObFJLNjZmWHVTSU5cL0VSYU5oZHlPbXNxU083dzZSQzFwMmpzbUFQ ▶" ] ]
0 of 0 array:7 [▶ "_token" => "Tb62uTP6paTPoPF0VMlnvnwotdMPM6poGwnarWwp" "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/anvelope-5/autoturisme-12/competus-h-p3" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
Catalog
Promoții
Contacte
Plata și livrarea
Sistem de reduceri
Procurarea în credit
Produse
