SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327857 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327857 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403726,828949,256073,996284,133615,919351,72743,283178,585399,290413,767459,449265,672393,1028472,90745,528105,277325,610197,212395,554079,24227,419376,547479,571509,383108,166761,88480,486790,159483,189693,58248,75973,44856,586207,71837,83228,254184,286473,749817,608580,1030687,764220,947807,646603,1001390,829255,856775,120052,348131,10357,809769,940936,652035,458439,44018,692142,708906,1007319,689185,766562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001090s ]