SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200406 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200406 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799799,667260,185689,334670,932690,461207,672235,306593,490739,228798,812357,485446,451496,999173,485174,301047,105111,888762,572280,797133,780747,588646,679442,1017262,915997,1014322,416174,456014,1002307,1013118,300994,1001071,971675,717479,685325,343429,658023,344032,546316,567986,122237,606340,262458,883065,185396,323965,42654,625233,254196,121431,673387,999255,861491,16074,713561,920629,585041,710150,416919,333391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]