SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804112 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804112 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333467,83790,990085,804723,123491,713972,533842,144661,2950,20815,846291,164506,212838,609270,73605,604008,736928,706249,515357,925465,604169,490141,793306,400559,192313,220077,328364,305863,309913,737330,173273,756501,972824,537290,822783,709940,987083,40289,1004868,636756,699415,438404,383838,8731,1043925,503131,262673,621436,735944,696266,796881,555835,590241,262901,1013971,196100,361033,121330,106482,999829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]