SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348796 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348796 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691806,349920,480543,744096,138583,99187,239232,408899,797020,104913,900271,588029,724943,973861,962629,260704,30309,102207,317118,196795,702724,1026486,223082,909730,797611,782209,964472,260049,449912,745,78898,542895,627705,767894,117046,840648,985919,826034,287805,416168,212871,295480,618193,455070,397993,281780,586442,281630,164129,60754,121272,385418,15298,258542,647128,814733,22830,519356,345543,29101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]