SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568428 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568428 [ RunTime:0.002856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180481,708117,598797,311288,1029528,497471,631293,767359,542074,349618,352318,22636,489325,494677,444695,207591,415134,524685,961618,559003,782650,192643,583008,343359,157496,720642,659821,550431,586910,224876,32025,563967,887065,636095,805457,23338,682666,812307,304575,408121,713357,538140,248371,289369,579060,113215,241363,367238,693651,832137,31944,369135,37735,729647,896998,61595,272544,650965,715568,649413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001486s ]