SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533431 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533431 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423226,36608,529244,202357,306580,103816,712087,340389,564832,877661,1034049,995405,352398,263993,574362,355818,133201,832010,956755,822090,935110,398730,494616,234655,338390,826862,695401,1007005,36749,710836,908817,455921,338262,872766,722987,230423,373656,480874,73958,1004524,1010745,77735,219505,688233,755508,507345,427335,170981,573745,544221,172458,990703,455278,744319,157519,410169,496402,720526,979916,584425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]