SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005931 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005931 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541936,175476,990549,884127,698124,267972,1017486,292601,532143,280003,348673,9090,410628,291587,481636,432953,142971,73305,689234,122849,239288,680383,835993,854270,735991,46519,866158,865293,991244,57340,1016848,176789,297885,559554,602213,1024464,736234,450304,548061,576565,41165,229735,243943,392791,104009,989496,546865,561853,58604,6331,81624,313200,181450,957778,516410,823922,130493,213890,449999,939117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]