SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001789s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429012 LIMIT 1 [ RunTime:0.000747s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429012 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615587,1034796,476093,269236,857950,11714,853275,1025982,780353,917422,613932,1009469,553335,112398,173766,664188,759456,740587,905965,1037542,365062,1042283,149109,922949,615062,1016682,611084,560158,417462,101305,595335,716898,689337,575897,92790,1033739,836565,359715,311025,1030112,751633,479688,371215,855165,184658,993595,121800,101245,961755,36201,1018232,985201,634818,637683,857934,212805,627332,456228,522874,20204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001238s ]