SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014622 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014622 [ RunTime:0.002543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654225,848901,44081,704548,871367,5511,33831,533889,971618,481359,98575,278833,547365,201992,69993,566705,823824,579387,90895,488998,160139,559734,58201,459337,209487,262037,988193,1017726,170340,129628,941659,555302,196208,360449,990873,214603,302623,560019,606266,882374,216875,102522,350154,81222,444184,858588,962528,792267,970944,262834,850946,12901,554532,829841,325099,1028918,214092,689425,70138,1002076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001548s ]