SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014912 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014912 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744796,687512,88288,2158,868734,422541,919640,858911,495731,988312,351027,935240,189375,636418,747071,674584,199808,138833,218755,471085,957348,408651,1007471,379030,183519,872376,353255,643851,188980,149724,1006330,716964,795009,447038,880187,1015150,559179,830350,659941,230822,179767,351685,468469,938352,909378,670180,967872,949339,493105,557186,632455,309455,702616,960734,768143,985201,840132,187329,942643,1018749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]