SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809913 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809913 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85524,154262,911309,386772,400773,583485,33324,294276,476640,775558,829664,145348,56624,319543,151621,49845,859957,561580,246767,795620,305514,765941,179402,340464,799168,812011,297807,564529,875615,726949,268160,326581,947489,179288,331992,314708,348790,404399,623402,250377,790991,338858,938332,1008741,69457,208920,627270,907853,292593,1045741,618692,81838,367270,958150,208467,550201,843989,741573,1047035,612839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]