SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534041 LIMIT 1 [ RunTime:0.000796s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534041 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57373,1029013,975575,924293,23768,940623,721070,899964,738175,108157,1024566,413571,334003,882886,237922,888109,902149,595321,159930,241747,52004,426287,593656,209070,114283,753213,814528,527123,1046567,920874,349444,106789,45717,63609,96444,342392,601985,252285,804118,46889,162603,414282,270217,89264,425853,155533,808364,18466,980958,252209,22694,348942,467417,671637,13741,337859,753151,626058,1019342,507164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001293s ]