0.0003 |
SELECT * FROM (`config`) WHERE `key` LIKE '%sm%'
|
0.0004 |
SELECT * FROM (`contact`) WHERE `id` = 1
|
0.0002 |
SELECT * FROM (`config`) WHERE `key` LIKE 'profile_%'
|
0.0001 |
SELECT contact.id as id, contact.company as name FROM (`contact`) LEFT JOIN `address` ON `address`.`contact_id` = `contact`.`id` WHERE `address`.`user_id` = 1 OR `contact`.`id` = 1 ORDER BY `contact`.`id` ASC
|
0.0002 |
SELECT * FROM (`contact`) LEFT JOIN `address` ON `address`.`contact_id` = `contact`.`id` WHERE `address`.`user_id` = 1 OR `contact`.`id` = 1 ORDER BY `contact`.`id` ASC
|
0.0001 |
SELECT * FROM (`form`) WHERE `popup` = 1
|
0.0002 |
SELECT * FROM (`form_field`) WHERE `form_id` = '9' ORDER BY `order` ASC
|
0.0002 |
SELECT * FROM (`form_field`) WHERE `form_id` = '10' ORDER BY `order` ASC
|
0.0003 |
SELECT * FROM (`form_field`) WHERE `form_id` = '11' ORDER BY `order` ASC
|
0.0001 |
SELECT * FROM (`form_field`) WHERE `form_id` = '12' ORDER BY `order` ASC
|
0.0002 |
SELECT * FROM (`pages`) WHERE `active` = 1 AND `location` LIKE '%footer%' ORDER BY `delete` asc LIMIT 8
|
0.0008 |
SELECT `brand_id`, `image`, `name` FROM (`brand`) WHERE `image` != '' ORDER BY RAND() LIMIT 8
|
0.0005 |
SELECT * FROM (`part`) WHERE `part_id` = '7175797'
|
0.0051 |
UPDATE `part` SET `page_count` = 8 WHERE `part_id` = '7175797'
|
0.0008 |
SELECT model.make_id, model.model_id, partnumbermodel.year, partnumber.partnumber FROM (`partnumbermodel`) JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumbermodel`.`partnumber_id` JOIN `model` ON `model`.`model_id` = `partnumbermodel`.`model_id` JOIN `partnumber` ON `partnumber`.`partnumber_id` = `partpartnumber`.`partnumber_id` WHERE `partpartnumber`.`part_id` = '7175797' GROUP BY `model`.`make_id`, `model`.`model_id`, `partnumbermodel`.`year` ORDER BY `model`.`make_id`, `model`.`model_id`, `partnumbermodel`.`year` DESC
|
0.0004 |
SELECT `part_id`, `name` as label, `image` FROM (`related`) JOIN `part` ON `part`.`part_id` = `related`.`related_part_id` WHERE `key_part_id` = '7175797'
|
0.0005 |
SELECT * FROM (`part_sizechart`) WHERE `part_id` = '7175797'
|
0.0004 |
SELECT * FROM (`part_video`) WHERE `part_id` = '7175797'
|
0.0003 |
SELECT model.make_id, model.model_id, partnumbermodel.year, partnumber.partnumber FROM (`partnumbermodel`) JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumbermodel`.`partnumber_id` JOIN `model` ON `model`.`model_id` = `partnumbermodel`.`model_id` JOIN `partnumber` ON `partnumber`.`partnumber_id` = `partpartnumber`.`partnumber_id` WHERE `partpartnumber`.`part_id` = '7175797' GROUP BY `model`.`make_id`, `model`.`model_id`, `partnumbermodel`.`year` ORDER BY `model`.`make_id`, `model`.`model_id`, `partnumbermodel`.`year` DESC
|
0.0005 |
SELECT * FROM (`part`) WHERE `part`.`part_id` = '7175797'
|
0.0002 |
SELECT * FROM (`partvariation`) JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partvariation`.`partnumber_id` WHERE `part_id` = '7175797' GROUP BY `stock_code`
|
0.0010 |
SELECT `partnumber`, `partnumber`.`dealer_sale`, `partnumber`.`price`, `partnumber`.`sale`, `partdealervariation`.`quantity_available` as dealer_quantity, `partvariation`.`quantity_available` FROM (`partnumber`) JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id` JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id` LEFT JOIN `partdealervariation` ON `partdealervariation`.`partnumber_id` = `partnumber`.`partnumber_id` WHERE `partnumber`.`price` > 0 AND (CASE WHEN partvariation.quantity_available = 0 AND partvariation.stock_code = 'Closeout' THEN CASE WHEN partdealervariation.quantity_available = 0 THEN 0 ELSE 1 END ELSE 1 END ) AND `partpartnumber`.`part_id` = '7175797'
|
0.0011 |
SELECT partnumber, partnumber.partnumber_id, MIN(partnumber.dealer_sale) AS dealer_sale_min, MAX(partnumber.dealer_sale) AS dealer_sale_max FROM (`partnumber`) JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id` LEFT JOIN `partnumbermodel` ON `partnumbermodel`.`partnumber_id` = `partpartnumber`.`partnumber_id` JOIN `partdealervariation` ON `partdealervariation`.`partnumber_id` = `partnumber`.`partnumber_id` WHERE `partnumber`.`price` > 0 AND `partdealervariation`.`quantity_available` > 0 AND `partpartnumber`.`part_id` = '7175797' GROUP BY `part_id`
|
0.0005 |
SELECT * FROM (`partdealervariation`) WHERE `partdealervariation`.`partnumber_id` = '8407267'
|
0.0012 |
SELECT `partvariation`.* FROM (`partvariation`) JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partvariation`.`partnumber_id` WHERE `partvariation`.`part_number` = '7102474' AND partpartnumber.part_id = 7175797 ORDER BY `partvariation`.`quantity_available` DESC
|
0.0014 |
SELECT MIN(category.mark_up) as markup FROM (`category`) JOIN `partcategory` ON `partcategory`.`category_id` = `category`.`category_id` WHERE `partcategory`.`part_id` = '7175797' AND `category`.`mark_up` > 0
|
0.0002 |
SELECT MIN(brand.mark_up) as markup, MAX(brand.exclude_market_place) as exclude_market_place, MAX(brand.closeout_market_place) as closeout_market_place FROM (`brand`) JOIN `partbrand` ON `partbrand`.`brand_id` = `brand`.`brand_id` WHERE `partbrand`.`part_id` = '7175797'
|
0.0003 |
SELECT SUM(rating) as rating, COUNT(id) as qty FROM (`reviews`) WHERE `part_id` = '7175797'
|
0.0002 |
SELECT partpartnumber.partnumber_id FROM (`partnumberpartquestion`) JOIN `partnumber` ON `partnumber`.`partnumber_id` = `partnumberpartquestion`.`partnumber_id` LEFT JOIN `partnumbermodel` ON `partnumbermodel`.`partnumber_id` = `partnumber`.`partnumber_id` JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id` JOIN `partquestion` ON `partquestion`.`partquestion_id` = `partnumberpartquestion`.`partquestion_id` WHERE `partquestion`.`part_id` = '7175797' AND `productquestion` = 0 AND (partnumber.universalfit > 0 OR partnumbermodel.partnumbermodel_id is not null) GROUP BY `question`
|
0.0037 |
SELECT * FROM (`partnumberpartquestion`) JOIN `partnumber` ON `partnumber`.`partnumber_id` = `partnumberpartquestion`.`partnumber_id` JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id` LEFT JOIN `partdealervariation` ON `partdealervariation`.`partnumber_id` = `partnumber`.`partnumber_id` LEFT JOIN `partnumbermodel` ON `partnumbermodel`.`partnumber_id` = `partnumber`.`partnumber_id` JOIN `partquestion` ON `partquestion`.`partquestion_id` = `partnumberpartquestion`.`partquestion_id` WHERE `partquestion`.`part_id` = '7175797' AND `productquestion` = 0 AND `answer` != '' AND (partnumber.universalfit > 0 OR partnumbermodel.partnumbermodel_id is not null) AND (CASE WHEN partdealervariation.quantity_available != 0 AND partdealervariation.stock_code = 'Closeout' THEN partnumber.dealer_sale != 0 ELSE partnumber.sale != 0 END ) AND (CASE WHEN partdealervariation.quantity_available = 0 AND partdealervariation.stock_code = 'Closeout' THEN CASE WHEN partvariation.quantity_available = 0 THEN 0 ELSE 1 END ELSE 1 END ) GROUP BY `partquestion`.`partquestion_id`, `answer` ORDER BY `partquestion`.`partquestion_id`, `answer`
|
0.0007 |
SELECT * FROM (`brand`) JOIN `partbrand` ON `partbrand`.`brand_id` = `brand`.`brand_id` WHERE `partbrand`.`part_id` = '7175797'
|
0.0005 |
SELECT `part`.`part_id`, `part`.`name` as label, `part`.`image`, `part`.`call_for_price`, `part`.`universal_fitment` FROM (`part`) WHERE `part`.`part_id` = '7175797'
|
0.0002 |
SELECT partpartnumber.partnumber_id FROM (`partnumberpartquestion`) JOIN `partnumber` ON `partnumber`.`partnumber_id` = `partnumberpartquestion`.`partnumber_id` LEFT JOIN `partnumbermodel` ON `partnumbermodel`.`partnumber_id` = `partnumber`.`partnumber_id` JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id` JOIN `partquestion` ON `partquestion`.`partquestion_id` = `partnumberpartquestion`.`partquestion_id` WHERE `partquestion`.`part_id` = '7175797' AND `productquestion` = 0 AND (partnumber.universalfit > 0 OR partnumbermodel.partnumbermodel_id is not null) GROUP BY `question`
|
0.0002 |
SELECT `partnumber`, `partnumber`.`dealer_sale`, `partnumber`.`price`, `partnumber`.`sale`, `partdealervariation`.`quantity_available` as dealer_quantity, `partvariation`.`quantity_available` FROM (`partnumber`) JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id` JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id` LEFT JOIN `partdealervariation` ON `partdealervariation`.`partnumber_id` = `partnumber`.`partnumber_id` WHERE `partnumber`.`price` > 0 AND (CASE WHEN partdealervariation.quantity_available = 0 AND partdealervariation.stock_code = 'Closeout' THEN CASE WHEN partvariation.quantity_available = 0 THEN 0 ELSE 1 END ELSE 1 END ) AND `partpartnumber`.`part_id` = '7175797'
|
0.0002 |
SELECT SUM(rating) as rating, COUNT(id) as qty FROM (`reviews`) WHERE `part_id` = '7175797'
|
0.0002 |
SELECT * FROM (`partvariation`) JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partvariation`.`partnumber_id` WHERE `part_id` = '7175797' GROUP BY `stock_code`
|
0.0009 |
SELECT `machinetype`.`machinetype_id`, `machinetype`.`label`, `machinetype`.`name` FROM (`machinetype`) JOIN `make` ON `make`.`machinetype_id` = `machinetype`.`machinetype_id` JOIN `model` ON `model`.`make_id` = `make`.`make_id` JOIN `partnumbermodel` ON `partnumbermodel`.`model_id` = `model`.`model_id` JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumbermodel`.`partnumber_id` WHERE `partpartnumber`.`part_id` = 7175797 GROUP BY `machinetype`.`machinetype_id`
|
0.0002 |
Select * from primarynavigation where active > 0 order by primarynavigation.ordinal
|
0.0009 |
Select category.* from category join partcategory using (category_id) where part_id = '7175797'
|
0.0005 |
SElect * from category where category_id = '66267'
|
0.0002 |
SElect * from category where category_id = '66164'
|
0.0002 |
SElect * from category where category_id = '20409'
|
0.0005 |
SELECT * FROM (`partcategory`) WHERE `part_id` = '7175797' ORDER BY `category_id` DESC LIMIT 1
|
0.0003 |
SELECT * FROM (`category`) WHERE `parent_category_id` = '20409'
|
0.0003 |
SELECT * FROM (`category`) WHERE `parent_category_id` = '66231'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66232'
|
0.0001 |
SELECT * FROM (`category`) WHERE `parent_category_id` = '66164'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66267'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66269'
|
0.0002 |
SELECT * FROM (`category`) WHERE `parent_category_id` = '66307'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66308'
|
0.0002 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66517'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66323'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66322'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66334'
|
0.0001 |
SELECT * FROM (`category`) WHERE `parent_category_id` = '66348'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66349'
|
0.0001 |
SELECT * FROM (`category`) WHERE `parent_category_id` = '66422'
|
0.0001 |
SELECT COUNT(*) AS `numrows` FROM (`partcategory`) WHERE `category_id` = '66497'
|
0.0008 |
SELECT * FROM (`brand_sizechart`) WHERE (find_in_set("66164", categories) OR find_in_set("66267", categories) OR find_in_set("66657", categories) OR find_in_set("66692", categories)) AND `brand_id` = '8475'
|
0.0003 |
SELECT * FROM (`config`) WHERE `key` LIKE '%sm%'
|
0.0007 |
SELECT COUNT(*) AS `numrows` FROM (`traffic`) WHERE `ip` = '13.58.184.197' AND `platform` = 'Unknown Platform' AND `date` < 1728153027
|
0.0008 |
SHOW COLUMNS FROM `traffic`
|
0.0023 |
INSERT INTO `traffic` (`date`, `ip`, `browser`, `version`, `platform`, `url`, `page`, `userAgent`, `new`, `session_id`) VALUES (1728239427, '13.58.184.197', 'Mozilla', '5.0', 'Unknown Platform', 'https://jessiedev.powersporttechnologies.com/shopping/item/7175797/bell-2019-qualifier-dlx-mips-street-bike-helmet', 'page', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1, 0)
|