SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003827 LIMIT 1 [ RunTime:0.001673s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003827 [ RunTime:0.003940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625694,301835,774700,372806,108105,32861,815435,914455,1040324,1028421,441658,855642,773948,736487,410349,499894,13593,55666,851236,1022079,848080,721937,232170,435039,639408,461168,942633,228392,75556,649937,865581,456645,947833,537113,702044,477752,891585,342187,131737,644761,709139,259654,476248,743374,151832,282668,607573,283037,720672,1007729,207792,866012,43479,400165,636333,559619,453244,955455,254265,243419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003536s ]