SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404284 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404284 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248679,180400,681635,550980,738257,347956,136579,1026627,772004,871300,1027845,259078,265291,948242,138220,165288,288227,964758,1026447,742861,18000,890903,795167,1030572,529265,839018,36949,382965,525437,882002,605328,447566,550202,880431,809766,978244,886252,415389,918876,849746,749030,1048405,499424,424375,1007250,523913,316709,621524,119538,391527,490262,87604,117212,862506,862148,510569,316232,290033,615693,393573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]