SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009209 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009209 [ RunTime:0.002911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353618,569304,196416,182625,696853,112060,489758,706669,338808,45041,319256,257166,315210,648159,142089,928754,374326,34298,334008,99737,561241,731594,752559,895018,892138,1028088,854384,628635,407942,878690,654092,720370,90669,259411,774459,942603,662682,611467,1006442,75320,1028940,47960,897626,409816,889400,940693,670439,251069,196849,79792,533493,85365,615344,829740,429024,818274,340818,886280,188985,374957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]