SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201198 LIMIT 1 [ RunTime:0.001760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201198 [ RunTime:0.002653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231367,829806,615634,604457,475599,494087,146680,972805,619345,601178,248196,800661,690625,127512,934273,338019,843638,87081,704378,913788,259277,765832,38421,853099,13847,139565,310871,622313,1011248,512114,922546,122073,845066,576739,814222,334097,335421,833969,782396,950016,303163,395073,996848,825448,348142,667313,738253,978183,826467,196006,72907,529939,130351,800323,723964,207564,279010,389265,20186,688231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001302s ]