Delete confirmation message
products
query
category_id
brand_id
sort_by
seller_id
min_price
max_price
attributes
selected_attribute_values
colors
selected_color
__env
app
errors
meta_title
meta_description
__currentLoopData
category
loop
key
attribute
brand
product
paginator
elements
locale
language
header_logo
select * from `attributes`
select * from `attribute_translations` where `attribute_translations`.`attribute_id` in (1, 2)
select * from `colors`
select count(*) as aggregate from `products` where (`published` = 1) and `published` = '1' and `auction_product` = 0 and `added_by` = 'admin' and `pharmastore_id` > 0 and `thumbnail_img` is not null and `current_stock` > 8
select * from `products` where (`published` = 1) and `published` = '1' and `auction_product` = 0 and `added_by` = 'admin' and `pharmastore_id` > 0 and `thumbnail_img` is not null and `current_stock` > 8 order by `id` desc limit 12 offset 2952
select * from `product_translations` where `product_translations`.`product_id` in (8126, 8127, 8131, 8132, 8134, 8135, 8151, 8154, 8156, 8166, 8182, 8183)
select * from `product_taxes` where `product_taxes`.`product_id` in (8126, 8127, 8131, 8132, 8134, 8135, 8151, 8154, 8156, 8166, 8182, 8183)
select * from `categories` where `level` = 0
select * from `category_translations` where `category_translations`.`category_id` in (1, 2, 4, 9, 19, 23, 30, 66)
select count(*) as aggregate from `products` where `pharmastore_id` > 0 and `thumbnail_img` is not null and `current_stock` > 8
select min(`unit_price`) as aggregate from `products` where `pharmastore_id` > 0 and `thumbnail_img` is not null and `current_stock` > 8
select max(`unit_price`) as aggregate from `products` where `pharmastore_id` > 0 and `thumbnail_img` is not null and `current_stock` > 8
select * from `attribute_values` where `attribute_values`.`attribute_id` = 1 and `attribute_values`.`attribute_id` is not null
select * from `attribute_values` where `attribute_values`.`attribute_id` = 2 and `attribute_values`.`attribute_id` is not null
select * from `brands`
select * from `brand_translations` where `brand_translations`.`brand_id` in (1, 2, 4, 5, 6, 7, 8, 9, 11, 12, 14, 15, 16, 19, 20, 21, 23, 24, 25, 26, 27, 28, 30, 31, 33, 36, 37, 38, 39, 41, 42, 43, 46, 47, 48, 49, 50, 52, 53, 54, 55, 56, 57, 58, 59, 60, 62, 63, 64, 68, 70, 71, 72, 73, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 285, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 469, 470, 472, 473, 474, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527)
select * from `uploads` where `uploads`.`id` = '60172' and `uploads`.`deleted_at` is null limit 1
select * from `uploads` where `uploads`.`id` = '60173' and `uploads`.`deleted_at` is null limit 1
select * from `uploads` where `uploads`.`id` = '' and `uploads`.`deleted_at` is null limit 1
select * from `uploads` where `uploads`.`id` = '60008' and `uploads`.`deleted_at` is null limit 1
select * from `uploads` where `uploads`.`id` = '60086' and `uploads`.`deleted_at` is null limit 1
select * from `uploads` where `uploads`.`id` = '59787' and `uploads`.`deleted_at` is null limit 1
select * from `languages` where `code` = 'en' limit 1
select * from `uploads` where `uploads`.`id` = '216' and `uploads`.`deleted_at` is null limit 1
select * from `languages` where `status` = 1
select * from `uploads` where `uploads`.`id` = '49425' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `level` = 0 order by `order_level` desc
select * from `uploads` where `uploads`.`id` = '49937' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `parent_id` = 1 order by `order_level` desc
select * from `category_translations` where `category_translations`.`category_id` in (153, 155, 157)
select * from `uploads` where `uploads`.`id` = '49939' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `parent_id` = 2 order by `order_level` desc
select * from `category_translations` where `category_translations`.`category_id` in (3, 52, 142, 145)
select * from `uploads` where `uploads`.`id` = '49943' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `parent_id` = 4 order by `order_level` desc
select * from `category_translations` where `category_translations`.`category_id` in (5, 44, 47, 103)
select * from `uploads` where `uploads`.`id` = '49941' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `parent_id` = 9 order by `order_level` desc
select * from `category_translations` where `category_translations`.`category_id` in (13, 113, 116, 118, 120, 123, 129, 130, 133)
select * from `uploads` where `uploads`.`id` = '49979' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `parent_id` = 19 order by `order_level` desc
select * from `category_translations` where `category_translations`.`category_id` in (151, 152)
select * from `uploads` where `uploads`.`id` = '49980' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `parent_id` = 23 order by `order_level` desc
select * from `category_translations` where `category_translations`.`category_id` in (24, 71)
select * from `uploads` where `uploads`.`id` = '49947' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `parent_id` = 30 order by `order_level` desc
select * from `category_translations` where `category_translations`.`category_id` in (31, 41, 106)
select * from `uploads` where `uploads`.`id` = '49956' and `uploads`.`deleted_at` is null limit 1
select * from `categories` where `parent_id` = 66 order by `order_level` desc
select * from `category_translations` where `category_translations`.`category_id` in (70, 147, 148)
200
0 of 0 array:1 [▼ "page" => "247" ]
0 of 0 array:15 [▼ "host" => array:1 [▶ 0 => "dev.waelsamirpharma.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => 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"" ] "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)" ] "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" ] "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" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0 array:45 [▼ "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "dev.waelsamirpharma.com" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "SSL_TLS_SNI" => "dev.waelsamirpharma.com" "HTTP_HOST" => "dev.waelsamirpharma.com" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "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_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "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_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.41 (Ubuntu) Server at dev.waelsamirpharma.com Port 443</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.41 (Ubuntu)" "SERVER_NAME" => "dev.waelsamirpharma.com" "SERVER_ADDR" => "185.193.66.134" "SERVER_PORT" => "443" "REMOTE_ADDR" => "18.226.94.15" "DOCUMENT_ROOT" => "/var/www/dev.waelsamirpharma.com/public_html" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/dev.waelsamirpharma.com/public_html" "SERVER_ADMIN" => "info@dev.waelsamirpharma.com" "SCRIPT_FILENAME" => "/var/www/dev.waelsamirpharma.com/public_html/index.php" "REMOTE_PORT" => "52106" "REDIRECT_URL" => "/search" "REDIRECT_QUERY_STRING" => "page=247" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "page=247" "REQUEST_URI" => "/search?page=247" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745780279.2897 "REQUEST_TIME" => 1745780279 ]
[]
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, 27 Apr 2025 18:57:59 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=7mKQxjVE2kGd3cfLb0Z8KHA8LCbLSB0S02xOgGn7; expires=Sun, 27-Apr-2025 20:58:00 GMT; Max-Age=7200; path=/" 1 => "sydlyat_oayl_smyr_session=27rxL8TpyYFqzg6rO0gavcdhLQKwmGnqbEToUsPi; expires=Sun, 27-Apr-2025 20:58:00 GMT; Max-Age=7200; path=/; httponly" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=7mKQxjVE2kGd3cfLb0Z8KHA8LCbLSB0S02xOgGn7; expires=Sun, 27-Apr-2025 20:58:00 GMT; path=/" 1 => "sydlyat_oayl_smyr_session=27rxL8TpyYFqzg6rO0gavcdhLQKwmGnqbEToUsPi; expires=Sun, 27-Apr-2025 20:58:00 GMT; path=/; httponly" ] ]
0 of 0 array:5 [▼ "_token" => "7mKQxjVE2kGd3cfLb0Z8KHA8LCbLSB0S02xOgGn7" "locale" => "en" "_previous" => array:1 [▶ "url" => "https://dev.waelsamirpharma.com/search?page=247" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
