SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985093 LIMIT 1 [ RunTime:0.005678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985093 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201174,702378,302826,543322,109903,473365,914140,29985,402283,728415,853299,407884,615181,123341,923346,869825,137765,761974,584050,59337,910286,505788,267103,737528,157893,1007616,248056,316683,767987,838979,97832,601475,279925,1011196,953929,550877,928283,371593,392539,455324,745988,389592,216153,257210,131030,1037688,450850,449597,852978,909221,541678,811451,57761,905395,561099,315160,151618,620149,860970,167346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]