SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263940 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263940 [ RunTime:0.005208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151267,470537,932292,950716,488021,749718,315984,13103,726296,1027364,344306,945354,282766,971350,251866,769959,889222,244656,140416,847193,452626,589165,726571,540405,1001164,151257,348976,883265,909243,603327,83370,843145,929097,247052,704558,287149,940438,435937,321929,276457,298257,14966,685308,665223,433000,661258,503262,1004956,526698,460817,705074,722613,977646,132399,372199,797521,340222,805145,592845,249456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004512s ]