SHOW FULL COLUMNS FROM `brands` [ RunTime:0.000517s ]
SELECT * FROM `brands` WHERE `slug` = 'honda' AND `status` = 1 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `brands` SET `view_count` = `view_count` + 1 WHERE `id` = 1 [ RunTime:0.004210s ]
SHOW FULL COLUMNS FROM `motorcycles` [ RunTime:0.000395s ]
SELECT * FROM `motorcycles` WHERE `brand` = 'Honda' ORDER BY `year_from` DESC [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `oem_parts` [ RunTime:0.000361s ]
SELECT o.*, COUNT(*) as compatible_count FROM `oem_parts` `o` INNER JOIN `vehicle_compatibility` `vc` ON `o`.`id`=`vc`.`oem_part_id` WHERE `vc`.`vehicle_id` IN ('2','6','1') GROUP BY `o`.`id` ORDER BY `compatible_count` DESC LIMIT 12 [ RunTime:0.000581s ]
SHOW FULL COLUMNS FROM `mod_schemes` [ RunTime:0.000366s ]
SELECT * FROM `mod_schemes` WHERE `vehicle_id` IN (2,6,1) AND `status` = 1 ORDER BY `view_count` DESC LIMIT 6 [ RunTime:0.000298s ]