SHOW FULL COLUMNS FROM `brands` [ RunTime:0.000509s ]
SELECT * FROM `brands` WHERE `slug` = 'yamaha' AND `status` = 1 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `brands` SET `view_count` = `view_count` + 1 WHERE `id` = 2 [ RunTime:0.003973s ]
SHOW FULL COLUMNS FROM `motorcycles` [ RunTime:0.000361s ]
SELECT * FROM `motorcycles` WHERE `brand` = 'Yamaha' ORDER BY `year_from` DESC [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `oem_parts` [ RunTime:0.000335s ]
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 ('7','3') GROUP BY `o`.`id` ORDER BY `compatible_count` DESC LIMIT 12 [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `mod_schemes` [ RunTime:0.000355s ]
SELECT * FROM `mod_schemes` WHERE `vehicle_id` IN (7,3) AND `status` = 1 ORDER BY `view_count` DESC LIMIT 6 [ RunTime:0.000306s ]
