SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 744813 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 744813 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194842,1028022,227303,174653,995153,367284,296813,603769,914840,474684,276986,245466,22276,330987,683392,871933,141329,804368,1020077,277554,759696,812359,186334,973211,822651,154909,124653,226171,474002,326346,40618,289617,843431,597312,1021165,787483,591196,961633,74176,853281,491574,329593,608923,887935,632523,797912,472987,241714,624606,816258,864080,556123,1023360,599518,160405,773178,136390,756817,726125,459977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 744813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 744813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]