SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445481 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445481 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325277,742543,729265,966679,1019353,744169,680259,468192,43829,266340,749291,3735,18629,860050,961752,765413,728515,230911,302691,731015,594542,511518,385850,280325,508669,126497,428219,208855,547302,213701,417274,935059,669546,677226,295427,254544,550625,729185,134926,770078,626915,654951,580400,322988,176790,665140,84605,146385,538472,294014,672045,401403,18507,972112,742551,381745,856711,224114,222592,107875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]