SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016409 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016409 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606550,692095,722272,1034571,423109,333417,494422,190676,843517,881999,59351,424678,1012481,397431,828904,717922,295555,829950,350714,700198,757387,650050,642866,815310,226733,232717,58894,1031416,126192,198078,949797,1047743,592730,176653,618518,1044394,830376,632360,960249,110049,986498,596478,603571,316948,303921,923953,736099,452324,462468,1038847,389656,632644,791089,349499,88501,495234,716698,507711,822974,858931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]