SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19991 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19991 [ RunTime:0.002122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654620,604006,1037629,642241,831715,100012,633970,166074,177460,964680,876916,519426,876983,438500,154777,975236,1011572,210098,972720,925745,493991,291786,25198,146690,502305,542921,69220,544741,633071,138037,811078,101491,780121,8508,633678,1000248,332416,106603,283142,750829,810031,3762,312992,877387,990816,30740,947888,852529,321084,835831,1033057,921090,677847,123558,589167,177454,547399,258655,901449,205252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]