SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405748 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405748 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475374,357855,499603,786576,896842,33373,468320,313399,996819,218966,976081,890736,1023881,320471,887081,839038,579823,476807,273587,399240,982209,599131,106334,389730,373189,92726,244957,823794,750783,265037,519098,493124,1011894,693112,998052,14122,198317,484765,166313,872020,704853,1004058,56112,787805,974272,407979,1025510,1041962,199769,231230,659844,802660,393228,653581,829204,890611,275428,194273,834967,254624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]