SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482109 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482109 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450848,626967,158406,559364,203777,330858,636501,69244,634796,697537,818675,387046,259932,422685,809040,872725,304229,152328,569860,254529,591342,406535,731838,911798,18174,728404,524022,213494,116785,3313,248328,261874,219171,853181,352485,751655,309048,493301,537380,249463,322295,479640,1035510,211768,456860,783640,827076,496267,418840,27688,1028277,947150,243727,749188,627737,295132,948895,334868,409271,469781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]