SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303109 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303109 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005036,464808,793703,34896,329803,438947,229378,459099,492473,441087,224400,1009301,987978,526226,411684,875724,671376,290468,480815,552701,703047,668549,1036723,163352,51269,847370,958961,762202,766722,364905,429965,972580,449985,636382,819246,176808,833783,379390,257398,48018,303191,629910,58095,930077,472119,940005,384597,257794,478057,709397,978295,314545,725052,311197,804115,78459,739087,435923,127758,80583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]