SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419878 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419878 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178974,829498,445079,937727,628043,168663,24494,732488,524950,853393,367459,598740,591017,477070,882723,623251,655383,32113,147018,778983,648814,824791,886420,469466,446262,613213,625695,184828,452350,947879,742168,544401,137964,640147,904341,509965,940420,191644,596072,389135,932610,754019,616822,651109,689383,495190,586963,646465,503118,542937,558127,451305,404295,730343,201616,143545,267561,527446,305227,235421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]