SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417851 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417851 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559918,349981,705034,336022,632805,87925,1012669,1017535,873462,179510,468638,194226,474575,100147,494606,914150,982719,835623,36419,756216,21115,807424,784170,271456,817884,208189,301537,144556,338600,329206,522361,1005131,128004,32377,81709,92567,844154,584056,23237,782432,812118,266631,820633,618990,943997,64983,990971,787559,810527,996050,45535,242671,473892,60962,726585,899090,741531,272942,70706,209055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]