SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035287 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035287 [ RunTime:0.003454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335640,368258,240054,108914,154876,123445,169101,139550,1021075,1013781,333127,397494,155931,422924,720594,535813,752040,779846,844183,108943,386872,372182,179350,48989,355084,744924,276961,806556,491304,1048635,462076,734536,1017594,948224,888264,108409,998556,524079,404579,987649,447508,847964,262151,327963,959679,460718,880152,1023643,393134,1047899,760969,276301,451536,835609,902690,857615,837689,740146,5412,711297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]