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` = 502800 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502800 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586549,913946,591764,175528,256136,579937,7812,688866,304095,99716,532536,844820,969588,1020053,436156,492057,335957,767837,93894,183466,307411,455286,203268,421484,232359,861559,517497,880720,955599,597790,352588,999739,43681,522547,958180,1014345,517176,977196,569610,644349,585856,170860,137481,934649,658935,537231,340436,208712,329352,700466,624846,986273,571852,323838,96242,413517,142001,1040236,374879,630718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]