SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682000 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682000 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576160,286615,812867,981423,105717,644900,284054,3547,916120,276234,710368,252328,933586,13685,621049,393549,558597,745658,755991,903662,739379,389772,292699,868085,194174,601230,811335,789973,730047,842701,73657,328824,788403,163018,938901,170595,852058,143370,645534,429092,16962,382756,943662,119290,504977,933329,547420,949406,7294,915189,505494,461884,929775,77830,117623,556421,200227,839003,820345,807960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]