SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041601 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041601 [ RunTime:0.003195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285243,374617,17041,809059,226568,693570,117590,154739,99597,349980,1026738,467262,742703,119431,928116,449466,223806,422506,328013,722030,69532,817028,73915,928694,771500,743506,69416,34163,143903,853417,410568,925995,587877,951883,319503,132977,986660,460454,846983,59036,882421,448167,80650,82370,170323,36263,499529,178201,876875,939988,110302,105028,967834,277173,509518,92300,244166,19624,740367,249036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]