SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433770 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433770 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035246,574462,1008467,496265,1010172,69334,17627,238069,65592,769136,961912,1024246,926748,942878,78479,576547,1008417,241408,4939,520690,807822,180992,188401,463531,557850,109310,721252,159506,772694,203787,721734,525047,955431,873260,1048180,626056,67505,501957,213870,754946,791323,642805,824976,229212,165479,660914,546063,460110,603057,991865,230078,325528,476339,234655,207115,341596,564186,855588,625996,8712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]