SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195408 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195408 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496762,924126,733745,538378,1004866,119847,673866,813964,774250,989471,532314,1027848,247739,478668,457067,950862,296629,752126,956345,321236,185139,455703,897518,560262,989421,100205,189580,526337,175652,768045,889072,911810,749294,861569,119256,515359,706074,38147,394565,587651,827870,18191,868170,569554,373138,504664,615040,489908,926713,603816,404879,763793,1020696,270879,84856,994326,452140,210430,181413,259648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001916s ]