SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294092 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294092 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193050,256590,600718,675369,771996,110256,656651,472502,244605,198446,774056,461334,1027454,170874,880095,52590,913688,970890,328513,176754,324648,53315,190386,908157,172587,26736,805794,748431,405113,495559,109781,929383,180434,42999,646972,920083,400173,1011767,535060,182299,705617,326286,228875,888840,449638,643502,937270,722357,474278,389448,36474,212727,630408,759570,769892,290111,331225,921790,381076,953001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]