SHOW FULL COLUMNS FROM `brands` [ RunTime:0.000521s ]
SELECT * FROM `brands` WHERE `slug` = 'bmw' AND `status` = 1 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `brands` SET `view_count` = `view_count` + 1 WHERE `id` = 5 [ RunTime:0.004177s ]
SHOW FULL COLUMNS FROM `motorcycles` [ RunTime:0.000370s ]
SELECT * FROM `motorcycles` WHERE `brand` = 'BMW' ORDER BY `year_from` DESC [ RunTime:0.000313s ]
SHOW FULL COLUMNS FROM `oem_parts` [ RunTime:0.000428s ]
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` = '9' GROUP BY `o`.`id` ORDER BY `compatible_count` DESC LIMIT 12 [ RunTime:0.000375s ]
SHOW FULL COLUMNS FROM `mod_schemes` [ RunTime:0.000372s ]
SELECT * FROM `mod_schemes` WHERE `vehicle_id` = 9 AND `status` = 1 ORDER BY `view_count` DESC LIMIT 6 [ RunTime:0.000262s ]