SHOW FULL COLUMNS FROM `brands` [ RunTime:0.000466s ]
SELECT * FROM `brands` WHERE `slug` = 'ktm' AND `status` = 1 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `brands` SET `view_count` = `view_count` + 1 WHERE `id` = 7 [ RunTime:0.004069s ]
SHOW FULL COLUMNS FROM `motorcycles` [ RunTime:0.000392s ]
SELECT * FROM `motorcycles` WHERE `brand` = 'KTM' ORDER BY `year_from` DESC [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `oem_parts` [ RunTime:0.000376s ]
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` = '11' GROUP BY `o`.`id` ORDER BY `compatible_count` DESC LIMIT 12 [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `mod_schemes` [ RunTime:0.000370s ]
SELECT * FROM `mod_schemes` WHERE `vehicle_id` = 11 AND `status` = 1 ORDER BY `view_count` DESC LIMIT 6 [ RunTime:0.000262s ]