| 0.0013 |
SELECT *
FROM `app_aobject` `o`
JOIN `sif_cities` `c` ON `c`.`cityId` = `o`.`cityId`
|
| 0.0005 |
SELECT * FROM sif_regions where regionId in (select regionId from app_aobject a inner join sif_cities c on a.cityId = c.cityId);
|
| 0.0002 |
SELECT * FROM sif_cities where cityId in (select cityId from app_aobject);
|
| 0.0002 |
SELECT * FROM sif_islands where islandId in (select islandId from app_aobject);
|
| 0.0011 |
SELECT *
FROM `app_images`
WHERE `AobjectId` = '1'
AND `AunitId` IS NULL
|
| 0.0002 |
SELECT *
FROM `std_agency`
WHERE `agencyId` = '1'
|
| 0.0002 |
SELECT `account`.*
FROM `idem_account` `account`
JOIN `rel_account_agency` `rel` ON `rel`.`accountId` = `account`.`accountId`
WHERE `rel`.`agencyId` = '1'
|
| 0.0001 |
SELECT *
FROM `idem_account_details`
WHERE `accountId` = '13'
|
| 0.0002 |
SELECT *
FROM `app_images`
WHERE `AobjectId` = '2'
AND `AunitId` IS NULL
|
| 0.0001 |
SELECT *
FROM `std_agency`
WHERE `agencyId` = '2'
|
| 0.0003 |
SELECT `account`.*
FROM `idem_account` `account`
JOIN `rel_account_agency` `rel` ON `rel`.`accountId` = `account`.`accountId`
WHERE `rel`.`agencyId` = '2'
|
| 0.0001 |
SELECT *
FROM `idem_account_details`
WHERE `accountId` = '12'
|
| 0.0002 |
SELECT *
FROM `app_images`
WHERE `AobjectId` = '3'
AND `AunitId` IS NULL
|
| 0.0001 |
SELECT *
FROM `std_agency`
WHERE `agencyId` = '2'
|
| 0.0002 |
SELECT `account`.*
FROM `idem_account` `account`
JOIN `rel_account_agency` `rel` ON `rel`.`accountId` = `account`.`accountId`
WHERE `rel`.`agencyId` = '2'
|
| 0.0001 |
SELECT *
FROM `idem_account_details`
WHERE `accountId` = '12'
|
| 0.0002 |
SELECT *
FROM `app_images`
WHERE `AobjectId` = '4'
AND `AunitId` IS NULL
|
| 0.0002 |
SELECT *
FROM `std_agency`
WHERE `agencyId` = '2'
|
| 0.0002 |
SELECT `account`.*
FROM `idem_account` `account`
JOIN `rel_account_agency` `rel` ON `rel`.`accountId` = `account`.`accountId`
WHERE `rel`.`agencyId` = '2'
|
| 0.0001 |
SELECT *
FROM `idem_account_details`
WHERE `accountId` = '12'
|
