SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596021 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596021 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800830,420404,884071,602510,899704,940027,240576,199642,526612,1004683,612539,733974,189510,471597,380141,90792,1006481,698261,926131,824781,801666,582491,53093,995090,765861,666154,933759,841688,428778,258762,896306,300455,847817,411575,169101,522441,320485,305194,3214,767966,72798,415932,449419,247857,606593,815496,44427,73090,407348,244010,87427,984908,105743,306052,12252,94151,249084,514596,53521,801241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001719s ]