SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196008 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196008 [ RunTime:0.001928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54175,197058,69170,710681,48537,430402,838628,376507,202475,947924,39790,172418,905302,370240,203169,974891,78241,741871,264018,353404,363995,787209,926272,1017738,491499,491709,263842,767300,613867,69288,935141,437060,519284,780315,113553,523113,594635,470159,930653,801374,1004034,202751,249047,361733,284826,474742,442085,313382,881002,787138,755486,852013,548064,977405,168107,983685,253360,930267,921291,828729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001175s ]