SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 152811 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 152811 [ RunTime:0.004499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48706,867933,770442,468880,205912,113063,1041988,860187,282486,998893,626290,231444,694538,245730,280578,935539,347733,498280,695965,119965,587587,199787,433563,682219,1017521,341804,780025,967118,722034,1004300,768569,607757,636062,377742,979460,137055,845375,335550,148839,223089,996800,611717,935722,1018303,671794,584915,141106,582440,212410,794772,1031485,315064,1046627,315934,409999,600575,257777,525736,867952,825841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 152811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 152811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000340s ]