SHOW FULL COLUMNS FROM `vbkxu_org_level` [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `vbkxu_org_invest` [ RunTime:0.000405s ]
SHOW FULL COLUMNS FROM `vbkxu_org_business` [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `vbkxu_org_company` [ RunTime:0.000501s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `vbkxu_org_company` `a` INNER JOIN `vbkxu_org_company_org` `b` ON `a`.`id`=`b`.`org_id` WHERE `a`.`status` = '1' AND `type` = 'company' AND `del_status` = 0 GROUP BY `b`.`org_id` ) `_group_count_` [ RunTime:0.340556s ]
SELECT `a`.* FROM `vbkxu_org_company` `a` INNER JOIN `vbkxu_org_company_org` `b` ON `a`.`id`=`b`.`org_id` WHERE `a`.`status` = '1' AND `type` = 'company' AND `del_status` = 0 GROUP BY `b`.`org_id` ORDER BY field(b.company_id,'1','67','81','87','100','113','125','136','145','68','69','70','71','72','73','74','75','76','77','78','79','80','82','83','84','85','86','88','89','90','91','92','93','94','95','96','97','98','99','101','102','103','104','105','106','107','108','109','110','111','112','114','115','116','117','118','119','120','121','122','123','124','126','127','128','129','130','131','132','133','134','135','137','138','139','141','142','143','144','146','147','148','149','150','151','152','153','154'),field(b.level_id,'1','2','14','3','15','4','13','7','8','5','6','9') LIMIT 1872,12 [ RunTime:1.444681s ]
SHOW FULL COLUMNS FROM `vbkxu_org_company_org` [ RunTime:0.000628s ]
SELECT `id`,`company_id`,`org_id`,`level_id`,`status`,`refusal_reason` FROM `vbkxu_org_company_org` WHERE `org_id` IN (2227,2228,2229,2241,2100,2114,2225,2232,2233,2237,2242,2243) [ RunTime:0.001170s ]
SELECT `id`,`title` FROM `vbkxu_org_company` WHERE `id` = 73 [ RunTime:0.000286s ]
SELECT `id`,`title` FROM `vbkxu_org_level` WHERE `id` IN (8,7) [ RunTime:0.000328s ]
SELECT `id`,`title`,`type` FROM `vbkxu_org_company` WHERE `type` = 'org' ORDER BY `orglevel` ASC [ RunTime:0.001471s ]
SELECT * FROM `vbkxu_org_level` WHERE `applicable` = 1 [ RunTime:0.000291s ]
SELECT * FROM `vbkxu_org_invest` [ RunTime:0.000252s ]
SELECT * FROM `vbkxu_org_business` [ RunTime:0.000258s ]
