SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533535 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533535 [ RunTime:0.002936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004672,315208,514372,53122,684004,830756,535684,947702,44177,890106,938984,477866,853482,428173,534436,137394,735819,945437,153805,550085,427079,120886,270000,569148,137031,158101,520813,802823,574031,331773,707618,298970,182843,215086,72101,320912,305058,211550,844794,413523,436257,680901,750215,970782,846802,309984,747680,903184,700118,847541,716125,365070,150288,821453,947169,245722,55184,19664,728862,147729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]