SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494170 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494170 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86260,196016,143336,622503,1006381,727442,703440,755043,985660,990290,850011,240469,226973,661605,193002,641798,740693,570112,885482,788560,394739,838916,286054,998375,1025508,1009254,356408,704374,355314,684078,124839,766986,745006,132098,932011,792193,771568,182452,116531,233557,357173,7508,558822,943916,711169,180203,900829,214922,637366,425312,34371,427456,370557,540171,241793,136239,999578,995580,310889,1044016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]