SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044646 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044646 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412821,247538,568889,1000475,580848,676513,141222,265151,496778,54471,1012286,466273,694290,352758,66855,202127,356051,210908,817289,386015,591883,328345,948068,450527,176760,156835,469631,856534,628047,426089,922942,563807,67240,386071,171197,342572,664133,1013264,255217,198552,683741,370058,750201,990067,649594,382449,682894,848329,368352,1032092,817772,39675,916474,375644,1010247,354761,398559,383025,497216,955755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]