SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518082 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518082 [ RunTime:0.002823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850202,413540,716726,429546,1017510,990285,371391,665907,857553,994669,893148,868209,497830,571256,405282,540554,3089,624877,179103,82836,25769,859574,961508,561697,281027,157767,1046243,132876,27067,185948,140937,882816,469129,32140,704421,643861,1024433,229101,431107,552107,877056,776503,197846,644458,121803,239569,244358,574843,125517,601393,918662,996006,372517,563615,729912,658816,149146,768024,802109,887606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]