SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52742 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52742 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519178,818130,298964,881884,127797,786393,1039790,203965,37543,581057,476775,155917,902331,786642,225139,452933,118327,565760,488688,538290,114137,547629,162224,296302,265190,348780,556579,269834,388600,225422,71462,969554,238602,784238,859125,61346,733427,640940,303545,819870,3826,900281,1019613,798333,1040252,826135,598993,744870,1038515,856783,945260,635334,287408,806052,888387,280488,667186,65160,354789,988954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]