SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001645s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583840 LIMIT 1 [ RunTime:0.001933s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583840 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600546,497616,237608,665836,510633,577327,744605,809206,484896,1016354,854681,826777,981212,977316,161949,836496,451219,276685,683566,438428,115481,688645,746990,944869,294956,39111,159156,1009795,818744,549392,479099,149769,917410,357647,373424,585677,979449,265326,632440,176341,1017973,434364,190944,320219,180659,613532,468113,140899,900105,309010,401687,692432,29855,239655,875247,462276,887850,367478,502085,333135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000834s ]