SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311221 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311221 [ RunTime:0.002797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585644,270581,908304,870418,314696,913470,76516,997924,542296,600138,832782,636019,217550,432151,574169,965607,334043,113614,1002251,528410,109736,353920,911868,291761,152366,480744,405092,945486,730481,331451,690769,1007069,763167,874031,796753,981028,745476,885971,662654,268532,221602,239859,944906,117116,889021,927916,881615,927723,1013897,971643,376676,629259,996559,324360,288916,334559,535412,783868,836484,617310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]