SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111818 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111818 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009101,192985,257913,350316,598804,492799,79526,623512,657146,209579,959053,621906,51933,454250,1032757,184017,286906,680539,157898,249159,643041,354752,216993,625604,488772,186594,555681,214427,541536,137488,1006542,989381,28674,654997,9566,154846,290732,951150,932202,73302,888693,104182,573186,196204,584295,60823,1000881,364093,579547,1028154,547532,748287,611266,211422,539937,909192,239627,23690,412237,681782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]