SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 743678 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 743678 [ RunTime:0.002743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499059,106077,710054,64216,1016317,143302,404237,599151,884513,874958,90643,953208,728384,201941,158484,614927,563077,975094,79351,288989,507355,418676,11334,816153,633793,796146,795939,663110,950869,977978,537515,470698,856346,110166,1024111,355694,388740,456403,796041,990718,106597,754080,115778,416045,274834,617163,143725,549270,362709,821661,1032592,13078,627823,149813,180586,294041,58856,365233,869519,45235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 743678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 743678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001533s ]