SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526979 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526979 [ RunTime:0.003079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10278,874342,151252,373506,19547,956691,810580,795411,963136,1017367,694950,867564,473060,37893,902085,22433,757640,294678,511017,524264,961,741374,187412,411794,419999,808636,794889,205298,230939,888176,155002,814274,625950,676593,811679,94837,11256,361571,537261,72921,683446,117289,719376,326847,1032601,391617,763573,697479,552517,180788,580070,370446,546165,14457,847898,228164,255821,494009,705771,760209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]