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` = 509282 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509282 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761626,822405,43448,612866,1011572,450787,14931,62513,701427,49996,97972,996038,276902,50353,802293,1017931,638756,433047,456373,158710,218437,1020189,646451,481939,293157,257690,425496,377368,177416,491756,214457,529950,708678,502113,482821,61181,256252,462250,827850,122607,157774,827649,889129,179795,15058,982189,222538,19319,495428,35978,132694,431003,555887,871948,429719,175611,273790,806018,266012,737054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]