SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 128943 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 128943 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535639,814596,184778,1037778,1031565,275708,6604,169200,660544,856615,717666,37352,65201,449514,72244,64549,1011073,418187,791306,180423,1039018,1001497,966278,497496,437811,501515,695419,902102,149694,896724,743723,891587,839098,999682,500572,749173,895530,40254,579536,981876,449660,249396,490904,158404,84871,516198,911560,891134,340347,708023,893110,197544,80628,341885,443810,868616,569492,759066,831820,1007569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 128943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 128943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]