Product information:
Material: Alloy
Style: Korean style/Korean style
Style: Women's
Shape: Letters/Numbers/Text
Treatment process: electroplating
Applicable gift-giving occasions: advertising promotion
Hairpin classification: a word clip
Color: letter F
Packaging Information:
Hairpin x1
Someone from recently purchased
1 hour ago| 1 x Application (95.39%) | 2.50s |
| 1 x Booting (4.6%) | 120.88ms |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
select * from `slugs` where `key` = 'korean-ins-metal-letter-hairpin-sablebeauty' and `reference_type` = 'Botble\Ecommerce\Models\Product' and `prefix` = 'products' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_currencies` order by `order` asc| Metadata | |
|---|---|
| Backtrace |
|
select distinct `ec_products`.*, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_count`, (select avg(star) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_avg` from `ec_products` inner join
(
SELECT DISTINCT
`ec_products`.id,
CASE
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price <> 0
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price = 0
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
(
ec_products.start_date > '2025-04-13 09:14:27' OR
ec_products.end_date < '2025-04-13 09:14:27'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-04-13 09:14:27' AND
ec_products.end_date >= '2025-04-13 09:14:27'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-04-13 09:14:27'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-04-13 09:14:27' AND
ec_products.end_date IS NULL
) THEN ec_products.sale_price
ELSE ec_products.price
END AS final_price
FROM `ec_products`
) AS products_with_final_price
on `products_with_final_price`.`id` = `ec_products`.`id` where `ec_products`.`id` = 209892 and `ec_products`.`status` = 'published' order by `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (209892) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\Product'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_tags`.*, `ec_product_tag_product`.`product_id` as `pivot_product_id`, `ec_product_tag_product`.`tag_id` as `pivot_tag_id` from `ec_product_tags` inner join `ec_product_tag_product` on `ec_product_tags`.`id` = `ec_product_tag_product`.`tag_id` where `ec_product_tag_product`.`product_id` in (209892)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_categories`.*, `ec_product_category_product`.`product_id` as `pivot_product_id`, `ec_product_category_product`.`category_id` as `pivot_category_id` from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_product_category_product`.`product_id` in (209892)| Metadata | |
|---|---|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (515) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_options` where `ec_options`.`product_id` in (209892) order by `order` asc| Metadata | |
|---|---|
| Backtrace |
|
update `ec_products` set `views` = `views` + 1, `ec_products`.`updated_at` = '2025-04-13 09:14:28' where `id` = 209892| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id` from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 209892 and `ec_product_variations`.`configurable_product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id` from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 209892 and `ec_product_variations`.`configurable_product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
update `ec_products` set `name` = 'Korean Ins Metal Letter Hairpin', `ec_products`.`updated_at` = '2025-04-13 09:14:28' where `id` in (209893) and `is_variation` = 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` = 209892| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_discounts` where `type` = 'promotion' and `start_date` <= '2025-04-13 09:14:28' and (`end_date` is null or `end_date` >= '2025-04-13 09:14:28') and (`target` in ('all-orders', 'amount-minimum-order') or (`target` in ('customer', 'group-products', 'specific-product', 'product-variant') and `product_quantity` = 1))| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_flash_sales` where `status` = 'published' and date(`end_date`) > '2025-04-13' order by `created_at` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `ec_product_categories`.`id` = 514 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `ec_product_categories`.`id` = 506 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `ec_product_categories`.`id` = 0 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory' and `slugs`.`reference_id` = 506 and `slugs`.`reference_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory' and `slugs`.`reference_id` = 514 and `slugs`.`reference_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (209892) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\Product'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 209892 and `ec_product_variations`.`configurable_product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 209892 and `ec_product_variations`.`configurable_product_id` is not null and `ec_product_variations`.`is_default` = 1 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_attributes`.*, `ec_product_variation_items`.`variation_id` as `pivot_variation_id`, `ec_product_variation_items`.`attribute_id` as `pivot_attribute_id` from `ec_product_attributes` inner join `ec_product_variation_items` on `ec_product_attributes`.`id` = `ec_product_variation_items`.`attribute_id` where `ec_product_variation_items`.`variation_id` = 189957| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select distinct * from `ec_product_variations` where `configurable_product_id` = 209892| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_variation_items` where `ec_product_variation_items`.`variation_id` in (189957)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_products`.`id`, `ec_products`.`name`, `ec_products`.`quantity`, `ec_products`.`price`, `ec_products`.`sale_price`, `ec_products`.`allow_checkout_when_out_of_stock`, `ec_products`.`with_storehouse_management`, `ec_products`.`stock_status`, `ec_products`.`images`, `ec_products`.`sku`, `ec_products`.`description`, `ec_products`.`is_variation` from `ec_products` inner join `ec_product_variations` on `ec_product_variations`.`product_id` = `ec_products`.`id` and `ec_product_variations`.`configurable_product_id` = 209892 inner join `ec_products` as `original_products` on `ec_product_variations`.`configurable_product_id` = `original_products`.`id` where `ec_product_variations`.`id` = 189957 and `original_products`.`status` = 'published' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where (`status` = 'published') and (`parent_id` is null or `parent_id` = 0) order by `order` asc, `created_at` desc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `status` = 'published' and `ec_product_categories`.`parent_id` in (1, 2, 16, 17, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 74, 399, 409, 469, 506, 551, 594, 631, 672, 705, 749, 787, 832, 869)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (3, 12, 18, 23, 83, 98, 400, 403, 410, 422, 428, 434, 445, 458, 470, 474, 485, 493, 499, 507, 514, 516, 518, 525, 531, 537, 544, 559, 570, 577, 580, 587, 595, 596, 603, 610, 617, 624, 632, 639, 646, 653, 659, 666, 673, 675, 681, 692, 698, 706, 710, 716, 721, 732, 740, 750, 756, 757, 758, 759, 766, 773, 779, 788, 817, 823, 827, 836, 837, 843, 850, 857, 863, 870, 877, 892, 899) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `status` = 'published' and `ec_product_categories`.`parent_id` in (3, 12, 18, 23, 83, 98, 400, 403, 410, 422, 428, 434, 445, 458, 470, 474, 485, 493, 499, 507, 514, 516, 518, 525, 531, 537, 544, 559, 570, 577, 580, 587, 595, 596, 603, 610, 617, 624, 632, 639, 646, 653, 659, 666, 673, 675, 681, 692, 698, 706, 710, 716, 721, 732, 740, 750, 756, 757, 758, 759, 766, 773, 779, 788, 817, 823, 827, 836, 837, 843, 850, 857, 863, 870, 877, 892, 899)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 19, 20, 21, 22, 24, 25, 26, 27, 85, 100, 102, 104, 411, 412, 413, 414, 415, 416, 423, 424, 425, 426, 427, 429, 430, 431, 432, 433, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 471, 472, 473, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 486, 487, 488, 489, 490, 491, 492, 494, 495, 496, 497, 498, 500, 501, 502, 503, 504, 505, 508, 509, 510, 511, 512, 513, 515, 517, 519, 520, 521, 522, 523, 524, 526, 527, 528, 529, 530, 532, 533, 534, 535, 536, 538, 539, 540, 541, 542, 543, 545, 546, 547, 548, 549, 550, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 571, 572, 573, 574, 575, 576, 578, 579, 581, 582, 583, 584, 585, 586, 588, 589, 590, 591, 592, 593, 597, 598, 599, 600, 601, 602, 604, 605, 606, 607, 608, 609, 611, 612, 613, 614, 615, 616, 618, 619, 620, 621, 622, 623, 625, 626, 627, 628, 629, 630, 633, 634, 635, 636, 637, 638, 640, 641, 642, 643, 644, 645, 647, 648, 649, 650, 651, 652, 654, 655, 656, 657, 658, 660, 661, 662, 663, 664, 665, 667, 668, 669, 670, 671, 674, 676, 677, 678, 679, 680, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 693, 694, 695, 696, 697, 699, 700, 701, 702, 703, 704, 707, 708, 709, 711, 712, 713, 714, 715, 717, 718, 719, 720, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 733, 735, 736, 737, 738, 739, 741, 742, 743, 744, 745, 746, 747, 748, 751, 752, 753, 754, 755, 760, 761, 762, 763, 764, 765, 767, 768, 769, 770, 771, 772, 774, 775, 776, 777, 778, 780, 781, 782, 783, 784, 785, 786, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 810, 811, 812, 813, 814, 815, 816, 818, 819, 820, 821, 822, 824, 825, 826, 828, 829, 830, 831, 833, 834, 835, 838, 839, 840, 841, 842, 844, 845, 846, 847, 848, 849, 851, 852, 853, 854, 855, 856, 858, 859, 860, 861, 862, 864, 865, 866, 867, 868, 871, 872, 873, 874, 875, 876, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 893, 894, 895, 896, 897, 898, 900, 901, 902, 903, 904) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `status` = 'published' and `ec_product_categories`.`parent_id` in (4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 19, 20, 21, 22, 24, 25, 26, 27, 85, 100, 102, 104, 411, 412, 413, 414, 415, 416, 423, 424, 425, 426, 427, 429, 430, 431, 432, 433, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 471, 472, 473, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 486, 487, 488, 489, 490, 491, 492, 494, 495, 496, 497, 498, 500, 501, 502, 503, 504, 505, 508, 509, 510, 511, 512, 513, 515, 517, 519, 520, 521, 522, 523, 524, 526, 527, 528, 529, 530, 532, 533, 534, 535, 536, 538, 539, 540, 541, 542, 543, 545, 546, 547, 548, 549, 550, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 571, 572, 573, 574, 575, 576, 578, 579, 581, 582, 583, 584, 585, 586, 588, 589, 590, 591, 592, 593, 597, 598, 599, 600, 601, 602, 604, 605, 606, 607, 608, 609, 611, 612, 613, 614, 615, 616, 618, 619, 620, 621, 622, 623, 625, 626, 627, 628, 629, 630, 633, 634, 635, 636, 637, 638, 640, 641, 642, 643, 644, 645, 647, 648, 649, 650, 651, 652, 654, 655, 656, 657, 658, 660, 661, 662, 663, 664, 665, 667, 668, 669, 670, 671, 674, 676, 677, 678, 679, 680, 682, 683, 684, 685, 686, 687, 688, 689, 690, 691, 693, 694, 695, 696, 697, 699, 700, 701, 702, 703, 704, 707, 708, 709, 711, 712, 713, 714, 715, 717, 718, 719, 720, 722, 723, 724, 725, 726, 727, 728, 729, 730, 731, 733, 735, 736, 737, 738, 739, 741, 742, 743, 744, 745, 746, 747, 748, 751, 752, 753, 754, 755, 760, 761, 762, 763, 764, 765, 767, 768, 769, 770, 771, 772, 774, 775, 776, 777, 778, 780, 781, 782, 783, 784, 785, 786, 789, 790, 791, 792, 793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 810, 811, 812, 813, 814, 815, 816, 818, 819, 820, 821, 822, 824, 825, 826, 828, 829, 830, 831, 833, 834, 835, 838, 839, 840, 841, 842, 844, 845, 846, 847, 848, 849, 851, 852, 853, 854, 855, 856, 858, 859, 860, 861, 862, 864, 865, 866, 867, 868, 871, 872, 873, 874, 875, 876, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 893, 894, 895, 896, 897, 898, 900, 901, 902, 903, 904)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (38, 417, 418, 419, 420, 421, 552, 553, 554, 555, 556, 557, 558, 804, 805, 806, 807, 808, 809) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_categories` where `status` = 'published' and `ec_product_categories`.`parent_id` in (38, 417, 418, 419, 420, 421, 552, 553, 554, 555, 556, 557, 558, 804, 805, 806, 807, 808, 809)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (1, 2, 16, 17, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 74, 399, 409, 469, 506, 551, 594, 631, 672, 705, 749, 787, 832, 869) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (1, 2, 16, 17, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 74, 399, 409, 469, 506, 551, 594, 631, 672, 705, 749, 787, 832, 869) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `mp_stores` where `mp_stores`.`id` = 41 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `slugs` where `slugs`.`reference_type` = 'Botble\Marketplace\Models\Store' and `slugs`.`reference_id` = 41 and `slugs`.`reference_id` is not null limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_flash_sales`.*, `ec_flash_sale_products`.`product_id` as `pivot_product_id`, `ec_flash_sale_products`.`flash_sale_id` as `pivot_flash_sale_id`, `ec_flash_sale_products`.`price` as `pivot_price`, `ec_flash_sale_products`.`quantity` as `pivot_quantity`, `ec_flash_sale_products`.`sold` as `pivot_sold` from `ec_flash_sales` inner join `ec_flash_sale_products` on `ec_flash_sales`.`id` = `ec_flash_sale_products`.`flash_sale_id` where `ec_flash_sale_products`.`product_id` = 209892 and `status` = 'published' and date(`end_date`) > '2025-04-13' order by `created_at` desc limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `ec_product_variations` where `ec_product_variations`.`configurable_product_id` = 209892 and `ec_product_variations`.`configurable_product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_product_attribute_sets`.*, `ec_product_with_attribute_set`.`product_id` as `pivot_product_id`, `ec_product_with_attribute_set`.`attribute_set_id` as `pivot_attribute_set_id` from `ec_product_attribute_sets` inner join `ec_product_with_attribute_set` on `ec_product_attribute_sets`.`id` = `ec_product_with_attribute_set`.`attribute_set_id` where `ec_product_with_attribute_set`.`product_id` = 209892 order by `order` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select distinct `ec_product_attributes`.* from `ec_product_attributes` inner join `ec_product_variation_items` on `ec_product_variation_items`.`attribute_id` = `ec_product_attributes`.`id` inner join `ec_product_variations` on `ec_product_variation_items`.`variation_id` = `ec_product_variations`.`id` where `configurable_product_id` = 209892 and `ec_product_attributes`.`status` = 'published'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_product_variations` where `configurable_product_id` = 209892| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_products` where `ec_products`.`id` in (209893)| Metadata | |
|---|---|
| Backtrace |
|
select `ec_product_attributes`.*, `ec_product_variation_items`.`variation_id` as `pivot_variation_id`, `ec_product_variation_items`.`attribute_id` as `pivot_attribute_id` from `ec_product_attributes` inner join `ec_product_variation_items` on `ec_product_attributes`.`id` = `ec_product_variation_items`.`attribute_id` where `ec_product_variation_items`.`variation_id` in (189957)| Metadata | |
|---|---|
| Backtrace |
|
select distinct `ec_product_variation_items`.`variation_id`, `ec_product_attributes`.*, `ec_product_attribute_sets`.`title` as `attribute_set_title`, `ec_product_attribute_sets`.`slug` as `attribute_set_slug` from `ec_product_variation_items` inner join `ec_product_attributes` on `ec_product_attributes`.`id` = `ec_product_variation_items`.`attribute_id` inner join `ec_product_attribute_sets` on `ec_product_attribute_sets`.`id` = `ec_product_attributes`.`attribute_set_id` where `ec_product_variation_items`.`variation_id` in (189957)| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `ec_options` where `ec_options`.`product_id` = 209892 and `ec_options`.`product_id` is not null| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ads` where `status` = 'published' and (date(`expired_at`) >= '2025-04-13')| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 38, 40, 41, 42, 43, 44, 45, 46) and `meta_boxes`.`reference_type` = 'Botble\Ads\Models\Ads'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `ec_products`.*, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_count`, (select avg(star) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_avg`, `ec_product_cross_sale_relations`.`from_product_id` as `pivot_from_product_id`, `ec_product_cross_sale_relations`.`to_product_id` as `pivot_to_product_id` from `ec_products` inner join `ec_product_cross_sale_relations` on `ec_products`.`id` = `ec_product_cross_sale_relations`.`to_product_id` where `ec_product_cross_sale_relations`.`from_product_id` = 209892 limit 7| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `ec_brands` where `ec_brands`.`id` = 0 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `meta_value` from `meta_boxes` where `meta_key` = 'faq_schema_config' and `reference_id` = 209892 and `reference_type` = 'Botble\Ecommerce\Models\Product' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` inner join `language_meta` on `language_meta`.`reference_id` = `menus`.`id` where `status` = 'published' and `language_meta`.`reference_type` = 'Botble\Menu\Models\Menu' and `language_meta`.`lang_meta_code` = 'en_US'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menu_nodes` where `menu_nodes`.`menu_id` in (1, 2, 3, 4)| Metadata | |
|---|---|
| Backtrace |
|
select * from `menu_nodes` where `menu_nodes`.`parent_id` in (2, 8, 12, 13, 14, 17, 18, 19, 21, 24, 25, 26, 27, 28, 57) order by `position` asc| Metadata | |
|---|---|
| Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (2, 8, 12, 13, 14, 17, 18, 19, 21, 24, 25, 26, 27, 28, 57) and `meta_boxes`.`reference_type` = 'Botble\Menu\Models\MenuNode'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menu_locations` where `menu_locations`.`menu_id` in (1, 2, 3, 4)| Metadata | |
|---|---|
| Backtrace |
|
select * from `widgets` where `theme` = 'martfury'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:23 [▼ "cf-ray" => array:1 [▶ 0 => "92f9da70181410d3-ORD" ] "x-forwarded-for" => array:1 [▶ 0 => "18.119.139.161" ] "host" => array:1 [▶ 0 => "updates.tradezy.io" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "cf-connecting-ip" => array:1 [▶ 0 => "18.119.139.161" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "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" ] "connection" => array:1 [▶ 0 => "Keep-Alive" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "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" ] ]
0 of 0array:54 [▼ "REDIRECT_UNIQUE_ID" => "Z-uAc4WdlCkGbUJDO74jeQAAAAE" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "updates.tradezy.io" "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "Z-uAc4WdlCkGbUJDO74jeQAAAAE" "HTTPS" => "on" "SSL_TLS_SNI" => "updates.tradezy.io" "HTTP_CF_RAY" => "92f9da70181410d3-ORD" "HTTP_X_FORWARDED_FOR" => "18.119.139.161" "HTTP_HOST" => "updates.tradezy.io" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_CDN_LOOP" => "cloudflare; loops=1" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_CF_CONNECTING_IP" => "18.119.139.161" "HTTP_CF_IPCOUNTRY" => "US" "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_CONNECTION" => "Keep-Alive" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "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" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "SERVER_SIGNATURE" => "<address> Server at updates.tradezy.io Port 443</address>\n" "SERVER_SOFTWARE" => " " "SERVER_NAME" => "updates.tradezy.io" "SERVER_ADDR" => "89.117.48.129" "SERVER_PORT" => "443" "REMOTE_ADDR" => "172.69.58.224" "DOCUMENT_ROOT" => "/var/www/updates-staging-code/public" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/updates-staging-code/public" "SERVER_ADMIN" => "webmaster@localhost" "SCRIPT_FILENAME" => "/var/www/updates-staging-code/public/index.php" "REMOTE_PORT" => "56040" "REDIRECT_URL" => "/products/korean-ins-metal-letter-hairpin-sablebeauty" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/products/korean-ins-metal-letter-hairpin-sablebeauty" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744535667.4833 "REQUEST_TIME" => 1744535667 ]
[]
0 of 0array:8 [▼ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 13 Apr 2025 09:14:30 GMT" ] "cms-version" => array:1 [▶ 0 => "5.30.3" ] "authorization-at" => array:1 [▶ 0 => "2025-04-07 09:41:56" ] "activated-license" => array:1 [▶ 0 => "Yes" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkhYYmFYUEc3MVAxSm9UZVJaL2tKcVE9PSIsInZhbHVlIjoiSDdEYjRTOHpTT1QyWHNERUQvLzdSV1ZqTGhXd29NRTlmaEJ5cEc1SWRhMzNBUVlqcTNKM2JNSWFoRlBrYU9aR2tXbzJTOHJCaUo5Nm1jZy8vYW5WN3dPVHBGcFExZzcxT290WDduUS9sL2xldUlhblJ1cDV6OGp0ZDlLVkhmYjMiLCJtYWMiOiJkYTY3NzM4M2QyMjRlOGM0YTZjMGJjZGQyZTU0NzBlODljOTIwNjgwYWJkNzhiNjVjY2ZiYzJkMzg5ZjNkM2NlIiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 11:14:30 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkhYYmFYUEc3MVAxSm9UZVJaL2tKcVE9PSIsInZhbHVlIjoiSDdEYjRTOHpTT1QyWHNERUQvLzdSV1ZqTGhXd29NRTlmaEJ5cEc1SWRhMzNBUVlqcTNKM2JNSWFoRlBrYU9aR2tXbzJTO ▶" 1 => "botble_session=eyJpdiI6IndQL0RmZDNrTjdMb09XSlVlRVlzWVE9PSIsInZhbHVlIjoiVkFzSkxFUWZLL0x3ZkNYcjh1cDJoSldQTzhUaDQvcnFDMFVDV1NaWU42MG1WcWRsY1lMTlhoOGx6UzJXOE9qMFdYNXZsWk9tam5qcnc1WW1NV3RBSndtQW9PclJBRkphbGFINTQ4YlRsYm1sNE9rSXpxcmVjanVlaThRU1VLd1UiLCJtYWMiOiIyMTg3Y2VlY2U4YWVhMGJmODIwNDNkYjFhM2EwNmNjYWZkOGMzZDg3MTgxZWZlYTFhY2MwZjg4NTIxMDI3MDRkIiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 11:14:30 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀botble_session=eyJpdiI6IndQL0RmZDNrTjdMb09XSlVlRVlzWVE9PSIsInZhbHVlIjoiVkFzSkxFUWZLL0x3ZkNYcjh1cDJoSldQTzhUaDQvcnFDMFVDV1NaWU42MG1WcWRsY1lMTlhoOGx6UzJXOE9qMFdYN ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkhYYmFYUEc3MVAxSm9UZVJaL2tKcVE9PSIsInZhbHVlIjoiSDdEYjRTOHpTT1QyWHNERUQvLzdSV1ZqTGhXd29NRTlmaEJ5cEc1SWRhMzNBUVlqcTNKM2JNSWFoRlBrYU9aR2tXbzJTOHJCaUo5Nm1jZy8vYW5WN3dPVHBGcFExZzcxT290WDduUS9sL2xldUlhblJ1cDV6OGp0ZDlLVkhmYjMiLCJtYWMiOiJkYTY3NzM4M2QyMjRlOGM0YTZjMGJjZGQyZTU0NzBlODljOTIwNjgwYWJkNzhiNjVjY2ZiYzJkMzg5ZjNkM2NlIiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 11:14:30 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkhYYmFYUEc3MVAxSm9UZVJaL2tKcVE9PSIsInZhbHVlIjoiSDdEYjRTOHpTT1QyWHNERUQvLzdSV1ZqTGhXd29NRTlmaEJ5cEc1SWRhMzNBUVlqcTNKM2JNSWFoRlBrYU9aR2tXbzJTO ▶" 1 => "botble_session=eyJpdiI6IndQL0RmZDNrTjdMb09XSlVlRVlzWVE9PSIsInZhbHVlIjoiVkFzSkxFUWZLL0x3ZkNYcjh1cDJoSldQTzhUaDQvcnFDMFVDV1NaWU42MG1WcWRsY1lMTlhoOGx6UzJXOE9qMFdYNXZsWk9tam5qcnc1WW1NV3RBSndtQW9PclJBRkphbGFINTQ4YlRsYm1sNE9rSXpxcmVjanVlaThRU1VLd1UiLCJtYWMiOiIyMTg3Y2VlY2U4YWVhMGJmODIwNDNkYjFhM2EwNmNjYWZkOGMzZDg3MTgxZWZlYTFhY2MwZjg4NTIxMDI3MDRkIiwidGFnIjoiIn0%3D; expires=Sun, 13-Apr-2025 11:14:30 GMT; path=/; httponly ◀botble_session=eyJpdiI6IndQL0RmZDNrTjdMb09XSlVlRVlzWVE9PSIsInZhbHVlIjoiVkFzSkxFUWZLL0x3ZkNYcjh1cDJoSldQTzhUaDQvcnFDMFVDV1NaWU42MG1WcWRsY1lMTlhoOGx6UzJXOE9qMFdYN ▶" ] ]
0 of 0array:7 [▼ "_token" => "FJkeFHFhG67t62pZPlYAE4Jm1zeB2uesJpHRg1E7" "language" => "en" "viewed_product" => array:1 [▶ 209892 => 1744535668 ] "cart" => array:2 [▶ "recently_viewed_updated_at" => Carbon\Carbon @1744535668 {#3488 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "0000000000000da00000000000000000" #localMonthsOverflow: null #localYearsOverflow: null #localStrictModeEnabled: null #localHumanDiffOptions: null #localToStringFormat: null #localSerializer: null #localMacros: null #localGenericMacros: null #localFormatFunction: null #localTranslator: null #dumpProperties: array:3 [▶ 0 => "date" 1 => "timezone_type" 2 => "timezone" ] #dumpLocale: null #dumpDateProperties: null date: 2025-04-13 09:14:28.244931 UTC (+00:00) } "recently_viewed" => Illuminate\Support\Collection {#3487 ▶ #items: array:1 [▶ "41e5ea885eecdb55a05cb125e1519620" => Botble\Ecommerce\Cart\CartItem {#3490 ▶ +rowId: "41e5ea885eecdb55a05cb125e1519620" +id: 209892 +qty: 1 +name: "Korean Ins Metal Letter Hairpin" +price: 2.0 +options: Botble\Ecommerce\Cart\CartItemOptions {#3486 ▶ #items: [] #escapeWhenCastingToString: false } #associatedModel: "Botble\Ecommerce\Models\Product" #taxRate: 0 +"created_at": Carbon\Carbon @1744535668 {#3485 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "0000000000000d9d0000000000000000" #localMonthsOverflow: null #localYearsOverflow: null #localStrictModeEnabled: null #localHumanDiffOptions: null #localToStringFormat: null #localSerializer: null #localMacros: null #localGenericMacros: null #localFormatFunction: null #localTranslator: null #dumpProperties: array:3 [▶ 0 => "date" 1 => "timezone_type" 2 => "timezone" ] #dumpLocale: null #dumpDateProperties: null date: 2025-04-13 09:14:28.244782 UTC (+00:00) } +"updated_at": Carbon\Carbon @1744535668 {#3484 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "0000000000000d9c0000000000000000" #localMonthsOverflow: null #localYearsOverflow: null #localStrictModeEnabled: null #localHumanDiffOptions: null #localToStringFormat: null #localSerializer: null #localMacros: null #localGenericMacros: null #localFormatFunction: null #localTranslator: null #dumpProperties: array:3 [▶ 0 => "date" 1 => "timezone_type" 2 => "timezone" ] #dumpLocale: null #dumpDateProperties: null date: 2025-04-13 09:14:28.244796 UTC (+00:00) } } ] #escapeWhenCastingToString: false } ] "_previous" => array:1 [▶ "url" => "https://updates.tradezy.io/products/korean-ins-metal-letter-hairpin-sablebeauty" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]