SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602004 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602004 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590086,441746,466590,816989,470981,643468,674330,1033903,369906,897145,372479,471700,80635,83148,320137,884098,960299,580339,630211,864444,277428,846633,946904,408518,230904,757879,638167,922159,230776,815886,760657,974816,288484,788939,503175,303286,812742,538072,749592,953912,16312,795254,16090,136753,680373,776653,791688,846162,957526,934045,160451,175184,580342,118986,947592,685764,55484,259317,188417,423196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]