SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044830 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044830 [ RunTime:0.003295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34864,492124,557496,126047,360561,743091,137409,587936,628329,646133,98099,418008,777489,382048,420349,702931,1013026,838603,435811,124854,792375,683178,845136,238159,297006,740616,866240,254117,522651,226163,1023449,881870,599771,279718,832400,437745,544544,570934,574125,842734,55551,547961,964765,559569,725275,320807,810660,399635,201213,792327,536755,657433,436692,659689,85763,205811,678070,238823,574635,924861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]