| 0.0003 |
SELECT *
FROM (`config`)
WHERE `key` LIKE '%sm%'
|
| 0.0002 |
SELECT *
FROM (`contact`)
WHERE `id` = 1
|
| 0.0001 |
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.0002 |
SELECT *
FROM (`form`)
WHERE `popup` = 1
|
| 0.0001 |
SELECT *
FROM (`form_field`)
WHERE `form_id` = '9'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT *
FROM (`form_field`)
WHERE `form_id` = '10'
ORDER BY `order` ASC
|
| 0.0001 |
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.0001 |
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` = '7178629'
|
| 0.0024 |
UPDATE `part` SET `page_count` = 1 WHERE `part_id` = '7178629'
|
| 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` = '7178629'
GROUP BY `model`.`make_id`, `model`.`model_id`, `partnumbermodel`.`year`
ORDER BY `model`.`make_id`, `model`.`model_id`, `partnumbermodel`.`year` DESC
|
| 0.0007 |
SELECT `part_id`, `name` as label, `image`
FROM (`related`)
JOIN `part` ON `part`.`part_id` = `related`.`related_part_id`
WHERE `key_part_id` = '7178629'
|
| 0.0003 |
SELECT *
FROM (`part_sizechart`)
WHERE `part_id` = '7178629'
|
| 0.0003 |
SELECT *
FROM (`part_video`)
WHERE `part_id` = '7178629'
|
| 0.0001 |
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` = '7178629'
GROUP BY `model`.`make_id`, `model`.`model_id`, `partnumbermodel`.`year`
ORDER BY `model`.`make_id`, `model`.`model_id`, `partnumbermodel`.`year` DESC
|
| 0.0006 |
SELECT *
FROM (`part`)
WHERE `part`.`part_id` = '7178629'
|
| 0.0009 |
SELECT *
FROM (`partvariation`)
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partvariation`.`partnumber_id`
WHERE `part_id` = '7178629'
GROUP BY `stock_code`
|
| 0.0009 |
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` = '7178629'
|
| 0.0007 |
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` = '7178629'
GROUP BY `part_id`
|
| 0.0002 |
SELECT *
FROM (`partdealervariation`)
WHERE `partdealervariation`.`partnumber_id` = ''
|
| 0.0007 |
SELECT `partvariation`.*
FROM (`partvariation`)
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partvariation`.`partnumber_id`
WHERE `partvariation`.`part_number` = '' AND partpartnumber.part_id = 7178629
ORDER BY `partvariation`.`quantity_available` DESC
|
| 0.0004 |
SELECT MIN(category.mark_up) as markup
FROM (`category`)
JOIN `partcategory` ON `partcategory`.`category_id` = `category`.`category_id`
WHERE `partcategory`.`part_id` = '7178629'
AND `category`.`mark_up` > 0
|
| 0.0005 |
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` = '7178629'
|
| 0.0001 |
SELECT SUM(rating) as rating, COUNT(id) as qty
FROM (`reviews`)
WHERE `part_id` = '7178629'
|
| 0.0001 |
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` = '7178629'
AND `productquestion` = 0
AND (partnumber.universalfit > 0 OR partnumbermodel.partnumbermodel_id is not null)
GROUP BY `question`
|
| 0.0022 |
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` = '7178629'
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.0006 |
SELECT *
FROM (`brand`)
JOIN `partbrand` ON `partbrand`.`brand_id` = `brand`.`brand_id`
WHERE `partbrand`.`part_id` = '7178629'
|
| 0.0004 |
SELECT `part`.`part_id`, `part`.`name` as label, `part`.`image`, `part`.`call_for_price`, `part`.`universal_fitment`
FROM (`part`)
WHERE `part`.`part_id` = '7178629'
|
| 0.0001 |
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` = '7178629'
AND `productquestion` = 0
AND (partnumber.universalfit > 0 OR partnumbermodel.partnumbermodel_id is not null)
GROUP BY `question`
|
| 0.0006 |
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` = '7178629'
|
| 0.0001 |
SELECT SUM(rating) as rating, COUNT(id) as qty
FROM (`reviews`)
WHERE `part_id` = '7178629'
|
| 0.0001 |
SELECT *
FROM (`partvariation`)
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partvariation`.`partnumber_id`
WHERE `part_id` = '7178629'
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` = 7178629
GROUP BY `machinetype`.`machinetype_id`
|
| 0.0002 |
Select * from primarynavigation where active > 0 order by primarynavigation.ordinal
|
| 0.0007 |
Select category.* from category join partcategory using (category_id) where part_id = '7178629'
|
| 0.0002 |
SElect * from category where category_id = '66323'
|
| 0.0001 |
SElect * from category where category_id = '66307'
|
| 0.0001 |
SElect * from category where category_id = '20409'
|
| 0.0004 |
SELECT *
FROM (`partcategory`)
WHERE `part_id` = '7178629'
ORDER BY `category_id` DESC
LIMIT 1
|
| 0.0002 |
SELECT *
FROM (`category`)
WHERE `parent_category_id` = '20409'
|
| 0.0001 |
SELECT *
FROM (`category`)
WHERE `parent_category_id` = '66231'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
FROM (`partcategory`)
WHERE `category_id` = '66232'
|
| 0.0002 |
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.0001 |
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.0007 |
SELECT *
FROM (`brand_sizechart`)
WHERE (find_in_set("66307", categories) OR find_in_set("66323", categories) OR find_in_set("66660", categories) OR find_in_set("66733", categories))
AND `brand_id` = '8597'
|
| 0.0002 |
SELECT *
FROM (`config`)
WHERE `key` LIKE '%sm%'
|
| 0.0008 |
SELECT COUNT(*) AS `numrows`
FROM (`traffic`)
WHERE `ip` = '18.188.227.4'
AND `platform` = 'Unknown Platform'
AND `date` < 1728160027
|
| 0.0009 |
SHOW COLUMNS FROM `traffic`
|
| 0.0026 |
INSERT INTO `traffic` (`date`, `ip`, `browser`, `version`, `platform`, `url`, `page`, `userAgent`, `new`, `session_id`) VALUES (1728246427, '18.188.227.4', 'Mozilla', '5.0', 'Unknown Platform', 'https://jessiedev.powersporttechnologies.com/shopping/item/7178629/joe-rocket-2015-velocity-motorcycle-jacket', 'page', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1, 0)
|
734-788-6744
development@powersporttechnologies.com
