SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804409 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804409 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580842,995453,417803,539007,915158,956890,369454,702121,405250,809875,141038,914901,717718,833041,473962,727513,677347,316113,357532,610857,463873,602192,29158,976000,467388,873045,273741,385108,534893,343727,494970,601984,294065,566260,943662,320605,160388,1022867,228110,648228,117420,786331,607256,476399,170313,641075,1009900,145377,54804,1033455,1024233,352680,254465,226782,400855,280827,1012347,549930,742911,875563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]