SHOW FULL COLUMNS FROM `brands` [ RunTime:0.000652s ]
SELECT * FROM `brands` WHERE `slug` = 'ducati' AND `status` = 1 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `brands` SET `view_count` = `view_count` + 1 WHERE `id` = 6 [ RunTime:0.004390s ]
SHOW FULL COLUMNS FROM `motorcycles` [ RunTime:0.000535s ]
SELECT * FROM `motorcycles` WHERE `brand` = 'Ducati' ORDER BY `year_from` DESC [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `oem_parts` [ RunTime:0.000489s ]
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` = '10' GROUP BY `o`.`id` ORDER BY `compatible_count` DESC LIMIT 12 [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `mod_schemes` [ RunTime:0.000523s ]
SELECT * FROM `mod_schemes` WHERE `vehicle_id` = 10 AND `status` = 1 ORDER BY `view_count` DESC LIMIT 6 [ RunTime:0.000298s ]