SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 945212 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 945212 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40408,648165,488880,170708,843039,307691,1042407,561000,1010051,369681,810403,577257,164822,523625,766940,1025402,151214,625240,968236,492955,944054,755642,629263,477955,413681,164602,146038,367212,453337,306509,260306,869263,622579,717244,514902,963244,191520,952753,840009,938820,856746,806093,290308,445649,304176,140838,541220,936274,997726,807963,120435,175000,986819,654355,788327,901831,317948,319640,643999,123144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 945212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 945212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001012s ]