SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020373 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020373 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850550,589558,514585,24351,287683,796635,900175,304662,676173,742280,1040545,617735,145833,106113,343279,184344,440509,893805,882472,331658,337394,885684,660701,679724,167107,673012,239573,231639,338026,930596,313710,114964,447995,711997,557489,251901,95393,602487,819886,694279,233430,1048111,820464,601388,527345,702922,709196,69542,246831,653725,162914,897155,420686,202850,696865,202235,920192,769110,214469,222889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]