SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 169004 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 169004 [ RunTime:0.004647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033755,79344,843430,106341,439352,751627,972216,1003332,740131,859840,77771,744729,404277,702953,825920,400452,920089,161555,300052,645093,603297,657508,512871,412109,512699,759204,693260,857618,860566,235659,318798,953577,530067,887476,807468,333168,517947,603316,268076,1046765,911751,305079,169803,731097,922001,1019392,30025,833337,808350,604323,731898,750120,257586,384539,910396,729171,897531,112023,950812,914833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 169004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 169004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]