| 0.0003 |
SELECT *
FROM `config`
WHERE `key` LIKE '%sm%' ESCAPE '!'
|
| 0.0003 |
SELECT *
FROM `contact`
WHERE `id` = 1
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` LIKE 'profile_%'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"show_additional_notes\"'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"additional_note_form_id\"'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"additional_note_field_id\"'
|
| 0.0001 |
SELECT `address`.`contact_id`
FROM `address`
WHERE `user_id` = 1
|
| 0.0001 |
SELECT contact.id as id, contact.company as name
FROM `contact`
WHERE `id` IN('2')
OR `contact`.`id` = 1
ORDER BY `contact`.`id` ASC
|
| 0.0001 |
SELECT `address`.`contact_id`
FROM `address`
WHERE `user_id` = 1
|
| 0.0002 |
SELECT *
FROM `contact`
WHERE `id` IN('2')
OR `id` = 1
ORDER BY `contact`.`id` ASC
|
| 0.0001 |
SELECT *
FROM `navbar`
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` LIKE '%nav!_%' ESCAPE '!'
|
| 0.0002 |
SELECT *
FROM `form`
WHERE `popup` = 1
AND `active` = 1
|
| 0.0001 |
SELECT *
FROM `form_field`
WHERE `form_id` = '1'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT *
FROM `form_field_options`
WHERE `field_id` IN('1')
|
| 0.0001 |
SELECT *
FROM `form_field`
WHERE `form_id` = '2'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT *
FROM `form_field_options`
WHERE `field_id` IN('1', '2')
|
| 0.0001 |
SELECT *
FROM `form_field`
WHERE `form_id` = '3'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT *
FROM `form_field_options`
WHERE `field_id` IN('1', '2', '3')
|
| 0.0001 |
SELECT *
FROM `form_field`
WHERE `form_id` = '4'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT *
FROM `form_field_options`
WHERE `field_id` IN('1', '2', '3', '4')
|
| 0.0001 |
SELECT *
FROM `form`
WHERE `form_id` > 4
AND `active` = 1
|
| 0.0004 |
SELECT *
FROM `form_field`
WHERE `form_id` = '9'
ORDER BY `order` ASC
|
| 0.0002 |
SELECT *
FROM `form_field_options`
WHERE `field_id` IN('292', '244', '245', '9', '246', '293', '296', '294', '295', '247', '248', '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', '282', '283', '284', '285', '286', '287', '288', '289', '290', '291', '297', '298', '299', '300', '301', '302', '303', '304', '305', '306', '307', '308', '309', '310', '311', '312', '313', '314', '315', '316', '317')
|
| 0.0001 |
SELECT *
FROM `waiver`
WHERE `active` = 1
ORDER BY `name` ASC
|
| 0.0002 |
SELECT *
FROM `contact`
WHERE `id` = 1
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` LIKE 'profile_%'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"show_additional_notes\"'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"additional_note_form_id\"'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"additional_note_field_id\"'
|
| 0.0001 |
SELECT `address`.`contact_id`
FROM `address`
WHERE `user_id` = 1
|
| 0.0002 |
SELECT *
FROM `contact`
WHERE `id` IN('2')
ORDER BY `contact`.`id` ASC
|
| 0.0014 |
SELECT *
FROM `pages`
WHERE `location` LIKE '%footer%' ESCAPE '!'
AND `active` = 1
ORDER BY `delete` ASC
LIMIT 8
|
| 0.0002 |
SELECT `brand_id`, `image`, `name`
FROM `brand`
WHERE `image` != ''
ORDER BY RAND()
LIMIT 8
|
| 0.0002 |
SELECT *
FROM `contact`
WHERE `id` = 1
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` LIKE 'profile_%'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"show_additional_notes\"'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"additional_note_form_id\"'
|
| 0.0001 |
SELECT *
FROM `config`
WHERE `key` = '\"additional_note_field_id\"'
|
| 0.0001 |
SELECT `partnumberpartquestion`.`answer`, `partquestion`.`question`, `partquestion`.`partquestion_id`
FROM `partnumberpartquestion`
JOIN `partquestion` ON `partquestion`.`partquestion_id` = `partnumberpartquestion`.`partquestion_id`
WHERE `partnumberpartquestion_id` = '117723533'
|
| 0.0001 |
SELECT *
FROM `partnumberpartquestion`
WHERE `partnumberpartquestion_id` = '117723533'
|
| 0.0001 |
SELECT *
FROM `partquestion`
WHERE `partquestion_id` IS NULL
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `parent_category_id` = '80041'
|
| 0.0008 |
SELECT part.part_id, part.name as label, partnumber.partnumber_id, part.call_for_price as call_for_price, part.universal_fitment, count(partnumber) as cnt
FROM `partnumber`
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `part` ON `part`.`part_id` = `partpartnumber`.`part_id`
JOIN `partcategory` ON `partcategory`.`part_id` = `part`.`part_id`
LEFT JOIN `partbrand` ON `partbrand`.`part_id` = `part`.`part_id`
LEFT JOIN `brand` ON `partbrand`.`brand_id` = `brand`.`brand_id`
JOIN `partnumberpartquestion` ON `partnumberpartquestion`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `partquestion` ON `partquestion`.`partquestion_id` = `partnumberpartquestion`.`partquestion_id`
LEFT JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id`
WHERE `part`.`invisible` = 0
AND (partcategory.category_id = 80041 )
AND `partbrand`.`brand_id` IN('5357')
AND (( partquestion.question = "" and partnumberpartquestion.answer = ""))
AND `partnumber`.`price` >0
AND partvariation.from_lightspeed = 0
AND partvariation.from_hlsm = 0
GROUP BY `part_id`
|
| 0.0002 |
SELECT *
FROM `machinetype`
|
| 0.0001 |
SELECT *
FROM `partnumberpartquestion`
WHERE `partnumberpartquestion_id` = '117723533'
|
| 0.0001 |
SELECT *
FROM `partquestion`
WHERE `partquestion_id` IS NULL
|
| 0.0004 |
SELECT part.part_id, part.name as label, partnumber.partnumber_id, part.call_for_price as call_for_price, part.universal_fitment, count(partnumber) as cnt
FROM `partnumber`
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `part` ON `part`.`part_id` = `partpartnumber`.`part_id`
LEFT JOIN `partbrand` ON `partbrand`.`part_id` = `part`.`part_id`
LEFT JOIN `brand` ON `partbrand`.`brand_id` = `brand`.`brand_id`
JOIN `partnumberpartquestion` ON `partnumberpartquestion`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `partquestion` ON `partquestion`.`partquestion_id` = `partnumberpartquestion`.`partquestion_id`
LEFT JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id`
WHERE `part`.`invisible` = 0
AND `partbrand`.`brand_id` IN('5357')
AND (( partquestion.question = "" and partnumberpartquestion.answer = ""))
AND `partnumber`.`price` >0
AND partvariation.from_lightspeed = 0
AND partvariation.from_hlsm = 0
GROUP BY `part_id`
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `category`
JOIN `partcategory` ON `partcategory`.`category_id` = `category`.`category_id`
JOIN `part` ON `part`.`part_id` = `partcategory`.`part_id`
WHERE `category`.`parent_category_id` = 80041
AND `part`.`invisible` =0
|
| 0.0003 |
SELECT category.name as label, category.category_id as id, category.parent_category_id as parentId, category.long_name, category.title, count(partcategory.part_id) as count
FROM `category`
LEFT JOIN `partcategory` ON `category`.`category_id` = `partcategory`.`category_id`
WHERE `category`.`category_id` = '80041'
GROUP BY `category`.`category_id`
|
| 0.0001 |
SELECT category.name as label, category.category_id as id, category.parent_category_id as parentId, category.long_name, category.title, count(partcategory.part_id) as count
FROM `category`
JOIN `partcategory` ON `category`.`category_id` = `partcategory`.`category_id`
JOIN `part` ON `partcategory`.`part_id` = `part`.`part_id` AND `part`.`invisible` = 0
WHERE `category`.`category_id` IS NULL
AND `part`.`invisible` = 0
GROUP BY `category`.`category_id`
ORDER BY `category`.`name` ASC
|
| 0.0002 |
SELECT category.name as label, category.category_id as id, category.parent_category_id as parentId, category.long_name, category.title, count(partcategory.part_id) as count
FROM `category`
JOIN `partcategory` ON `category`.`category_id` = `partcategory`.`category_id`
JOIN `part` ON `partcategory`.`part_id` = `part`.`part_id` AND `part`.`invisible` = 0
GROUP BY `category`.`category_id`
ORDER BY `category`.`name` ASC
|
| 0.0001 |
Select long_name from category where category_id = '80041'
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `category_id` = '80041'
|
| 0.0025 |
SELECT *
FROM `category_video`
WHERE `category_id` = '80041'
|
| 0.0002 |
SELECT *
FROM `brand`
WHERE `brand_id` = '5357'
|
| 0.0001 |
SELECT *
FROM `partnumberpartquestion`
WHERE `partnumberpartquestion_id` = '117723533'
|
| 0.0001 |
SELECT *
FROM `partquestion`
WHERE `partquestion_id` IS NULL
|
| 0.0002 |
SELECT *
FROM `category`
WHERE `parent_category_id` = '80041'
|
| 0.0005 |
SELECT part.part_id, part.name as label, partnumber.partnumber_id, part.call_for_price as call_for_price, part.universal_fitment, count(partnumber) as cnt
FROM `partnumber`
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `part` ON `part`.`part_id` = `partpartnumber`.`part_id`
JOIN `partcategory` ON `partcategory`.`part_id` = `part`.`part_id`
LEFT JOIN `partbrand` ON `partbrand`.`part_id` = `part`.`part_id`
LEFT JOIN `brand` ON `partbrand`.`brand_id` = `brand`.`brand_id`
JOIN `partnumberpartquestion` ON `partnumberpartquestion`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `partquestion` ON `partquestion`.`partquestion_id` = `partnumberpartquestion`.`partquestion_id`
LEFT JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id`
WHERE `part`.`invisible` = 0
AND (partcategory.category_id = 80041 )
AND (( partquestion.question = "" and partnumberpartquestion.answer = ""))
AND `partnumber`.`price` >0
AND partvariation.from_lightspeed = 0
AND partvariation.from_hlsm = 0
GROUP BY `part_id`
|
| 0.0002 |
SELECT *
FROM `category`
WHERE `parent_category_id` = '80041'
|
| 0.0003 |
SELECT part.part_id, part.name as label, partnumber.partnumber_id, part.call_for_price as call_for_price, part.universal_fitment, count(partnumber) as cnt
FROM `partnumber`
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `part` ON `part`.`part_id` = `partpartnumber`.`part_id`
JOIN `partcategory` ON `partcategory`.`part_id` = `part`.`part_id`
LEFT JOIN `partbrand` ON `partbrand`.`part_id` = `part`.`part_id`
LEFT JOIN `brand` ON `partbrand`.`brand_id` = `brand`.`brand_id`
LEFT JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id`
WHERE `part`.`invisible` = 0
AND (partcategory.category_id = 80041 )
AND `partnumber`.`price` >0
AND partvariation.from_lightspeed = 0
AND partvariation.from_hlsm = 0
GROUP BY `part_id`
|
| 0.0008 |
SELECT brand.*, (SELECT COUNT(*) FROM partbrand pb WHERE pb.brand_id = brand.brand_id) as count
FROM `brand`
JOIN `partbrand` ON `brand`.`brand_id` = `partbrand`.`brand_id`
ORDER BY `name`
|
| 0.0002 |
SELECT *
FROM `category`
WHERE `parent_category_id` = '80041'
|
| 0.0004 |
SELECT part.part_id, part.name as label, partnumber.partnumber_id, part.call_for_price as call_for_price, part.universal_fitment, count(partnumber) as cnt
FROM `partnumber`
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `part` ON `part`.`part_id` = `partpartnumber`.`part_id`
JOIN `partcategory` ON `partcategory`.`part_id` = `part`.`part_id`
LEFT JOIN `partbrand` ON `partbrand`.`part_id` = `part`.`part_id`
LEFT JOIN `brand` ON `partbrand`.`brand_id` = `brand`.`brand_id`
LEFT JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id`
WHERE `part`.`invisible` = 0
AND (partcategory.category_id = 80041 )
AND `partbrand`.`brand_id` IN('5357')
AND `partnumber`.`price` >0
AND partvariation.from_lightspeed = 0
AND partvariation.from_hlsm = 0
GROUP BY `part_id`
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `parent_category_id` = '80041'
|
| 0.0003 |
SELECT part.part_id, part.name as label, partnumber.partnumber_id, part.call_for_price as call_for_price, part.universal_fitment, count(partnumber) as cnt
FROM `partnumber`
JOIN `partpartnumber` ON `partpartnumber`.`partnumber_id` = `partnumber`.`partnumber_id`
JOIN `part` ON `part`.`part_id` = `partpartnumber`.`part_id`
JOIN `partcategory` ON `partcategory`.`part_id` = `part`.`part_id`
LEFT JOIN `partbrand` ON `partbrand`.`part_id` = `part`.`part_id`
LEFT JOIN `brand` ON `partbrand`.`brand_id` = `brand`.`brand_id`
LEFT JOIN `partvariation` ON `partvariation`.`partnumber_id` = `partnumber`.`partnumber_id`
WHERE `part`.`invisible` = 0
AND (partcategory.category_id = 80041 )
AND `partbrand`.`brand_id` IN('5357')
AND `partnumber`.`price` >0
AND partvariation.from_lightspeed = 0
AND partvariation.from_hlsm = 0
GROUP BY `part_id`
|
| 0.0018 |
SELECT `productquestion_id` as id, `partnumberpartquestion_id` as pnpq_id, `partquestion`.`question`, `partnumberpartquestion`.`answer`, COUNT(DISTINCT part.part_id) as qty
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`
JOIN `part` ON `part`.`part_id` = `partpartnumber`.`part_id`
WHERE `productquestion` = 1
AND `part`.`invisible` = 0
AND (`partnumber`.`universalfit` >0 OR `partnumbermodel`.`partnumbermodel_id` is NOT NULL)
GROUP BY `partnumberpartquestion`.`answer`
ORDER BY `partquestion`.`partquestion_id`, `partnumberpartquestion`.`answer`
|
| 0.0012 |
SELECT *
FROM `pages`
WHERE `location` LIKE '%footer%' ESCAPE '!'
AND `active` = 1
ORDER BY `delete` ASC
LIMIT 8
|
| 0.0001 |
Select * from primarynavigation where active > 0 order by primarynavigation.ordinal
|
| 0.0001 |
SELECT *
FROM `partcategory`
WHERE `part_id` = 0
ORDER BY `category_id` DESC
LIMIT 1
|
| 0.0001 |
SELECT *
FROM `category`
WHERE `parent_category_id` = '80041'
|
| 0.0002 |
SELECT *
FROM `config`
WHERE `key` LIKE '%sm%' ESCAPE '!'
|
| 0.0003 |
SELECT *
FROM `form`
WHERE `form_id` = 1
|
| 0.0002 |
SELECT *
FROM `form_field`
WHERE `form_id` = '1'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT *
FROM `form_field_options`
WHERE `field_id` IN('1')
|
| 0.0017 |
SELECT COUNT(*) AS `numrows`
FROM `traffic`
WHERE `ip` = '216.73.216.60'
AND `platform` = 'Unknown Platform'
AND `date` < 1766557897
|
| 0.0002 |
SELECT *
FROM `traffic`
WHERE `ip` = '216.73.216.60'
AND `email` is not NULL
ORDER BY `id` DESC
|
| 0.0004 |
SELECT *
FROM `config`
|
| 0.0002 |
SELECT *
FROM `form`
WHERE `form_id` = 2
|
| 0.0002 |
SELECT *
FROM `form_field`
WHERE `form_id` = '2'
ORDER BY `order` ASC
|
| 0.0001 |
SELECT *
FROM `form_field_options`
WHERE `field_id` IN('2')
|
