SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541809 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541809 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434532,512817,113586,864125,754392,790781,888087,964850,107819,974015,673355,80950,826674,310382,358742,952848,161417,422559,994718,61443,555224,101051,803342,338072,678072,723756,51288,653814,882474,283420,811476,510734,164495,251282,420958,189203,141829,856992,481392,248140,650754,791490,802019,159717,519601,663106,340538,433677,48201,648637,435584,707257,440778,706752,166819,900178,477062,319072,659477,320742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]