SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410288 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410288 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892110,108344,980068,189470,241840,924867,285480,99611,717480,910361,375327,381643,20164,390913,540223,1030153,472423,304061,572446,519998,638768,976654,504194,753890,548322,873932,865381,424884,133594,1013061,1024363,480407,91040,658361,123742,116469,769643,653493,619184,719948,8055,203136,276450,231577,126536,885464,853420,516999,609543,384765,758649,92541,844497,1011226,827516,171352,690826,509754,385306,401153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]