title
description
keyword
products
subCategory
layout_page
og_image
filter_sort
categories
price
priceFinal
kind
paginator
elements
obLevel
__env
app
modelCmsCategory
modelCmsContent
sc_languages
sc_currencies
sc_blocksContent
sc_layoutsUrl
sc_templatePath
sc_templateFile
modelProduct
modelCategory
modelBanner
modelBrand
modelNews
modelPage
templatePathAdmin
errors
categoriesTop
bannerBreadcrumb
bannerImage
cartProduct
cart
queries
__currentLoopData
key
loop
category
ProductCount
scategory
ProductsubCount
product
final_price
product_price
diffrence
discount
layout
arrPage
select `name`, `code` from `sc_shop_currency` where `status` = 1
select * from `sc_shop_currency` where `code` = 'INR' limit 1
select * from `sc_shop_category` left join `sc_shop_category_description` on `sc_shop_category_description`.`category_id` = `sc_shop_category`.`id` where `sc_shop_category_description`.`lang` = 'en' and `alias` = 'special-packs' and `status` = 1 limit 1
select count(*) as aggregate from `sc_shop_product` left join `sc_shop_product_description` on `sc_shop_product_description`.`product_id` = `sc_shop_product`.`id` left join `sc_shop_product_category` on `sc_shop_product_category`.`product_id` = `sc_shop_product`.`id` where `sc_shop_product_description`.`lang` = 'en' and `sc_shop_product_category`.`category_id` in (6) and `sc_shop_product`.`status` = 1
select * from `sc_shop_product` left join `sc_shop_product_description` on `sc_shop_product_description`.`product_id` = `sc_shop_product`.`id` left join `sc_shop_product_category` on `sc_shop_product_category`.`product_id` = `sc_shop_product`.`id` where `sc_shop_product_description`.`lang` = 'en' and `sc_shop_product_category`.`category_id` in (6) and `sc_shop_product`.`status` = 1 order by `sort` asc, `sc_shop_product`.`id` desc limit 12 offset 0
select * from `sc_shop_product_promotion` where `sc_shop_product_promotion`.`product_id` in (5, 18, 19, 30, 31, 32, 33)
select count(*) as aggregate from `sc_shop_category` left join `sc_shop_category_description` on `sc_shop_category_description`.`category_id` = `sc_shop_category`.`id` where `sc_shop_category_description`.`lang` = 'en' and `status` = 1 and `parent` = 6
select * from `sc_shop_category` inner join `sc_shop_category_description` on `sc_shop_category`.`id` = `sc_shop_category_description`.`category_id` where `parent` = 0 and `status` = 1 order by `sort` asc
select * from `sc_shop_category` inner join `sc_shop_category_description` on `sc_shop_category`.`id` = `sc_shop_category_description`.`category_id` where `parent` = 1 and `status` = 1 order by `sort` asc
select * from `sc_shop_category` inner join `sc_shop_category_description` on `sc_shop_category`.`id` = `sc_shop_category_description`.`category_id` where `parent` = 3 and `status` = 1 order by `sort` asc
select * from `sc_shop_category` inner join `sc_shop_category_description` on `sc_shop_category`.`id` = `sc_shop_category_description`.`category_id` where `parent` = 2 and `status` = 1 order by `sort` asc
select * from `sc_shop_category` left join `sc_shop_category_description` on `sc_shop_category_description`.`category_id` = `sc_shop_category`.`id` where `sc_shop_category_description`.`lang` = 'en' and `status` = 1 and `top` = 1
select * from `sc_shop_banner` where `status` = 1 and `type` = 'breadcrumb' and `sc_shop_banner`.`store_id` = 1 limit 1
select `product_id` from `sc_shop_product_category` where (`category_id` = 1)
select `product_id` from `sc_shop_product_category` where (`category_id` = 3)
select `product_id` from `sc_shop_product_category` where (`category_id` = 5)
select `product_id` from `sc_shop_product_category` where (`category_id` = 6)
select `product_id` from `sc_shop_product_category` where (`category_id` = 7)
select `product_id` from `sc_shop_product_category` where (`category_id` = 2)
select * from `sc_shop_brand` where `status` = 1
select * from `sc_shop_product` left join `sc_shop_product_description` on `sc_shop_product_description`.`product_id` = `sc_shop_product`.`id` inner join `sc_shop_product_promotion` on `sc_shop_product`.`id` = `sc_shop_product_promotion`.`product_id` where `sc_shop_product_description`.`lang` = 'en' and `sc_shop_product_promotion`.`status_promotion` = 1 and (`sc_shop_product_promotion`.`date_end` >= '2025-05-25' or `sc_shop_product_promotion`.`date_end` is null) and (`sc_shop_product_promotion`.`date_start` <= '2025-05-25' or `sc_shop_product_promotion`.`date_start` is null) and `sc_shop_product`.`status` = 1 order by RAND() limit 4
select * from `sc_shop_product_promotion` where `sc_shop_product_promotion`.`product_id` in (26, 27, 30, 32)
200
[]
0 of 0 array:15 [▶ "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" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "host" => array:1 [▶ 0 => "www.maaimasale.com" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "priority" => array:1 [▶ 0 => "u=0, i" ] ]
0 of 0 array:53 [▶ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "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_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_HOST" => "www.maaimasale.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/u603748947/domains/maaimasale.com/public_html" "REMOTE_ADDR" => "18.116.61.169" "REMOTE_PORT" => "35462" "SERVER_ADDR" => "178.16.136.46" "SERVER_NAME" => "www.maaimasale.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/category/special-packs" "REDIRECT_URL" => "/category/special-packs" "REDIRECT_REQUEST_METHOD" => "GET" "HTTPS" => "on" "CRAWLER_USLEEP" => "1000" "CRAWLER_LOAD_LIMIT_ENFORCE" => "25" "H_PLATFORM" => "Hostinger" "H_TYPE" => "shared" "H_CANARY" => "false" "H_STAGING" => "false" "REDIRECT_STATUS" => "200" "X_SPDY" => "HTTP2" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256" "SSL_CIPHER_USEKEYSIZE" => "128" "SSL_CIPHER_ALGKEYSIZE" => "128" "SCRIPT_FILENAME" => "/home/u603748947/domains/maaimasale.com/public_html/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://www.maaimasale.com/category/special-packs" "SCRIPT_URL" => "/category/special-packs" "SCRIPT_NAME" => "/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on,crawler,esi,combine" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1748153849.2659 "REQUEST_TIME" => 1748153849 ]
0 of 0 array:5 [▶ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 25 May 2025 06:17:29 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlZDMm9VRDlJQmZZdHIyQ056MURMMnc9PSIsInZhbHVlIjoiWlJhTmZXM2ZaY1ZXZE53UjZUWWNvNWFkU3dpcTkrRFlWMUdYOHZOM3ZEWGNhWVArVE5kZTBOQWwxTVhiNEVldDRwMkpJM1BOS0VxK0xEUUJDWkppTFNVRnRWR2s1YytzN3Q2TXFtS3M0L2VtKzYvVnJabzNUc2ZyL3NKMzZtZTMiLCJtYWMiOiJmMjU3Y2JkMjUxMWMxOTNhMWE1YzlkMWRhOWExMjMzMDE5ZWQwNDE2NDRmZjJkZDFiZWRhZDY1MWJiNGFmYWJjIn0%3D; expires=Sun, 25-May-2025 08:17:29 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlZDMm9VRDlJQmZZdHIyQ056MURMMnc9PSIsInZhbHVlIjoiWlJhTmZXM2ZaY1ZXZE53UjZUWWNvNWFkU3dpcTkrRFlWMUdYOHZOM3ZEWGNhWVArVE5kZTBOQWwxTVhiNEVldDRwMkpJM ▶" 1 => "maai_masale_session=eyJpdiI6IjU0VW90a3BpQ1lLOWFNTHdlYzVNb3c9PSIsInZhbHVlIjoiWWZPblBwUHllZ0tVY0FKSS9XdGEzWUdxZi9BWExibHA1SUcySC9SWm80TVNkYjBvUTJDZk5yR1dpQjVhdlBWcGgzY1B2am1uVWlGZFpqRzZFR1FJRFhPejJjS2NqREFFd0IyVFhNZDZheFpROXcyY0VPc0Y3WHhpc3MxUVBJS2kiLCJtYWMiOiJjNGQ5YWNjYzIzMDg4ODFjNzhlOGJlZDI2YzcyZjU3MGQzNThlNjA2MWIyYWZhMjY0NWFkZjg2MmU2NzdhNjBiIn0%3D; expires=Sun, 25-May-2025 08:17:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀maai_masale_session=eyJpdiI6IjU0VW90a3BpQ1lLOWFNTHdlYzVNb3c9PSIsInZhbHVlIjoiWWZPblBwUHllZ0tVY0FKSS9XdGEzWUdxZi9BWExibHA1SUcySC9SWm80TVNkYjBvUTJDZk5yR1dpQjVhdlBW ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlZDMm9VRDlJQmZZdHIyQ056MURMMnc9PSIsInZhbHVlIjoiWlJhTmZXM2ZaY1ZXZE53UjZUWWNvNWFkU3dpcTkrRFlWMUdYOHZOM3ZEWGNhWVArVE5kZTBOQWwxTVhiNEVldDRwMkpJM1BOS0VxK0xEUUJDWkppTFNVRnRWR2s1YytzN3Q2TXFtS3M0L2VtKzYvVnJabzNUc2ZyL3NKMzZtZTMiLCJtYWMiOiJmMjU3Y2JkMjUxMWMxOTNhMWE1YzlkMWRhOWExMjMzMDE5ZWQwNDE2NDRmZjJkZDFiZWRhZDY1MWJiNGFmYWJjIn0%3D; expires=Sun, 25-May-2025 08:17:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlZDMm9VRDlJQmZZdHIyQ056MURMMnc9PSIsInZhbHVlIjoiWlJhTmZXM2ZaY1ZXZE53UjZUWWNvNWFkU3dpcTkrRFlWMUdYOHZOM3ZEWGNhWVArVE5kZTBOQWwxTVhiNEVldDRwMkpJM ▶" 1 => "maai_masale_session=eyJpdiI6IjU0VW90a3BpQ1lLOWFNTHdlYzVNb3c9PSIsInZhbHVlIjoiWWZPblBwUHllZ0tVY0FKSS9XdGEzWUdxZi9BWExibHA1SUcySC9SWm80TVNkYjBvUTJDZk5yR1dpQjVhdlBWcGgzY1B2am1uVWlGZFpqRzZFR1FJRFhPejJjS2NqREFFd0IyVFhNZDZheFpROXcyY0VPc0Y3WHhpc3MxUVBJS2kiLCJtYWMiOiJjNGQ5YWNjYzIzMDg4ODFjNzhlOGJlZDI2YzcyZjU3MGQzNThlNjA2MWIyYWZhMjY0NWFkZjg2MmU2NzdhNjBiIn0%3D; expires=Sun, 25-May-2025 08:17:29 GMT; path=/; httponly ◀maai_masale_session=eyJpdiI6IjU0VW90a3BpQ1lLOWFNTHdlYzVNb3c9PSIsInZhbHVlIjoiWWZPblBwUHllZ0tVY0FKSS9XdGEzWUdxZi9BWExibHA1SUcySC9SWm80TVNkYjBvUTJDZk5yR1dpQjVhdlBW ▶" ] ]
0 of 0 array:6 [▶ "_token" => "eytn1cPkyfAvnAq25WAj9Aima03X9Ps47gJtxeYl" "locale" => "en" "locale_id" => 1 "_previous" => array:1 [▶ "url" => "https://www.maaimasale.com/category/special-packs" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]