SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408693 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408693 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034574,177559,181793,833010,578848,593337,431477,155460,924046,721672,181354,956224,313876,701889,897864,155757,369999,647103,295563,531053,1004981,391618,474560,318613,269025,300663,865396,972689,911615,443525,942016,777547,290996,1002549,96836,347023,748263,975013,518663,283549,32039,366765,1024551,253468,1009314,909420,141810,621368,115514,862330,39487,193684,232025,109655,724687,783475,93394,211277,775868,80584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003762s ]