SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806732 LIMIT 1 [ RunTime:0.003546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806732 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829338,607866,239103,8047,106829,767612,380971,757857,394586,1046460,92972,455458,477321,621404,937013,140729,690040,669473,269909,590821,854368,427057,588661,485390,841675,618817,985382,445643,1008154,711926,281152,638581,680350,821978,833135,752445,764647,481070,714287,521550,858311,377215,631729,506939,319660,783350,321295,976447,73320,543610,90221,483942,565511,371690,667147,46528,929364,271107,581319,724682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806732 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806732 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]