SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320197 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320197 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188364,419572,158479,1012387,1018736,596436,566810,362931,242926,746323,716436,801560,999708,848583,602101,178334,343209,135284,712770,625892,408686,752461,251831,937181,404040,660797,583432,562828,278877,395383,444599,110935,719588,26087,386331,566555,769315,1041656,358341,764725,1022208,301468,156991,812782,253135,364595,681904,7403,662451,893493,403017,864743,465069,548699,269318,711496,150119,810866,472673,140957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]