SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320422 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320422 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479082,288207,852803,646783,1019140,853282,214451,894036,499917,708542,912757,366396,953495,220046,847696,492719,282906,864318,484823,661484,208296,543984,673233,263718,34062,526954,990808,554679,782998,169771,33994,78318,257884,1040146,998999,265102,140740,372995,157829,390354,202929,271904,1012897,309882,640843,780999,253693,408899,916788,843819,872589,96022,1021347,973098,18449,471956,979914,891572,427930,434670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]