SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 621028 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 621028 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262520,526430,21217,995312,207797,399968,549218,887265,659620,944448,473043,107161,474915,361478,842639,278642,760768,584988,846811,814038,354197,650784,215649,947719,65887,462734,373364,576896,685085,130960,818576,776104,446603,701033,854091,11909,607564,279246,778441,526046,1001811,863330,195112,743620,928017,593468,97158,574787,432057,58848,248993,50623,697800,281446,610690,986722,294943,143094,656897,45769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 621028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 621028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]