SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405736 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405736 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860244,81167,80356,983586,256976,897605,413346,568659,389821,535511,960551,371235,220708,989890,198039,312216,402762,420632,277014,576231,418557,65170,349115,815870,155712,511638,749550,124592,919271,421811,648266,678015,171184,10112,592094,362301,167046,721490,576917,58369,732083,419438,351725,506375,86243,947183,573578,694884,1041362,371676,86391,612718,465534,885231,601360,235343,792915,949018,366942,327973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]