SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019686 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019686 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844833,404274,994321,107343,336841,672432,5939,619200,900200,861813,954134,623632,820409,756038,20644,911322,494756,740145,624210,965553,159138,459615,621518,123993,773271,999610,50361,559491,62752,267503,930664,80014,659234,332271,856817,402270,991028,778704,797675,955551,544289,523952,396297,381981,422442,588025,145102,658620,917647,652202,186511,333583,354239,672863,1014518,1036801,617285,36160,213467,649586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]