SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549718 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549718 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879259,850136,407219,42471,978341,1042890,119885,578418,279022,375626,130866,454482,60782,178652,497956,884136,675340,650816,785209,398634,610866,1024021,73616,1033201,68486,292035,253582,811804,670498,181007,305753,99830,203670,148311,945941,679468,990781,932467,37004,904074,683974,464696,512148,498338,984296,118190,831836,10809,961325,176889,865486,635264,470967,452806,300919,607282,15501,581465,742171,331051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001659s ]