SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409197 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409197 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569257,1044757,307899,756145,706631,677042,854538,977406,29332,588227,62180,161874,510181,1010422,409217,577862,282232,40144,866376,823116,183654,1018852,494133,704937,168148,460584,349389,757256,182188,759373,95201,927825,410063,316859,485554,77944,647804,924549,818526,903626,90144,630785,621793,922300,225010,395849,1018175,330815,392844,92052,708767,1001253,671784,340382,32245,1021707,107527,611448,18891,200633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]