SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194820 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194820 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137992,517531,59972,186315,1038360,480536,681491,846288,786309,945214,375677,254773,369342,671280,267383,585423,655784,16521,188138,533355,177129,408072,894538,435414,784146,391691,474116,838917,677155,424344,589884,884228,489089,679001,507273,171660,731531,476900,685380,671307,721748,244939,54347,95520,580395,145113,620992,917039,55642,211840,590772,230134,597084,20547,159260,1028649,954253,783288,44400,120255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]