| 0.0004 | SELECT *
FROM `geo`
WHERE `alias` = 'zakinthosz' ?>
|
| 0.0004 | SELECT *
FROM `airports`
WHERE `is_departure_allowed` = 1
ORDER BY `name` ?>
|
| 0.0540 | SELECT node.id, node.name, node.alias, (COUNT(parent.name)-1) - 1 AS depth
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.is_searchable = 1
GROUP BY node.id
ORDER BY node.lft; ?>
|
| 0.0003 | SELECT *
FROM `geo`
WHERE `id` IN(983) ?>
|
| 0.0004 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 983
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(757) ?>
|
| 0.0002 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 757
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(252) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 252
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1106) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1106
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(254) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 254
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(800) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 800
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(253) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 253
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(271) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 271
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(151) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 151
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(158) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 158
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1108) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1108
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1079) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1079
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(799) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 799
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(792) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 792
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(847) ?>
|
| 0.0003 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 847
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(364) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 364
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(261) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 261
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(359) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 359
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(181) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 181
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1080) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1080
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(838) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 838
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(588) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 588
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(590) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 590
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(211) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 211
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1101) ?>
|
| 0.0020 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1101
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(798) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 798
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(742) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 742
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(766) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 766
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(583) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 583
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(570) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 570
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(553) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 553
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(557) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 557
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(527) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 527
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(524) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 524
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(431) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 431
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(383) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 383
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(369) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 369
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(277) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 277
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(269) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 269
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(267) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 267
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(268) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 268
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(166) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 166
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(140) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 140
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0003 | SELECT *
FROM `geo`
WHERE `id` IN(1105) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1105
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1074) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1074
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(822) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 822
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(805) ?>
|
| 0.0020 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 805
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(815) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 815
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(774) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 774
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(748) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 748
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(971) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 971
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(700) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 700
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(696) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 696
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(695) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 695
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(694) ?>
|
| 0.0008 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 694
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(693) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 693
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(580) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 580
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(529) ?>
|
| 0.0008 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 529
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(523) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 523
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(452) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 452
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0003 | SELECT *
FROM `geo`
WHERE `id` IN(379) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 379
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(380) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 380
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(614) ?>
|
| 0.0011 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 614
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(367) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 367
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(366) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 366
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0003 | SELECT *
FROM `geo`
WHERE `id` IN(361) ?>
|
| 0.0011 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 361
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1104) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1104
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0001 | SELECT *
FROM `geo`
WHERE `id` IN(374) ?>
|
| 0.0007 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 374
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1073) ?>
|
| 0.0005 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1073
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(368) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 368
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(306) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 306
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1086) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1086
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(697) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 697
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0003 | SELECT *
FROM `geo`
WHERE `id` IN(372) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 372
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(371) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 371
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(358) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 358
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(272) ?>
|
| 0.0023 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 272
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(143) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 143
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(129) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 129
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(376) ?>
|
| 0.0008 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 376
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(273) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 273
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(141) ?>
|
| 0.0007 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 141
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0001 | SELECT *
FROM `geo`
WHERE `id` IN(373) ?>
|
| 0.0007 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 373
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0020 | SELECT *
FROM `geo`
WHERE `id` IN(125) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 125
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0004 | SELECT *
FROM `geo`
WHERE `id` IN(124) ?>
|
| 0.0007 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 124
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(119) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 119
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(113) ?>
|
| 0.0008 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 113
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(111) ?>
|
| 0.0007 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 111
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1083) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1083
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0003 | SELECT *
FROM `geo`
WHERE `id` IN(1082) ?>
|
| 0.0008 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1082
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(571) ?>
|
| 0.0007 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 571
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0003 | SELECT *
FROM `geo`
WHERE `id` IN(515) ?>
|
| 0.0012 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 515
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(117) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 117
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(106) ?>
|
| 0.0008 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 106
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(108) ?>
|
| 0.0009 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 108
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(110) ?>
|
| 0.0005 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 110
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0001 | SELECT *
FROM `geo`
WHERE `id` IN(107) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 107
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(6) ?>
|
| 0.0005 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 6
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(1107) ?>
|
| 0.0005 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 1107
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(415) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 415
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(411) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 411
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(403) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 403
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(84) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 84
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(10) ?>
|
| 0.0010 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 10
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(17) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 17
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(97) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 97
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(11) ?>
|
| 0.0007 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 11
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `geo`
WHERE `id` IN(15) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 15
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0004 | SELECT *
FROM `product_repo`
WHERE `supplier_id` = '9'
AND `code` = 'BLUSKY-ZTHAPTSOR'
ORDER BY `id` ASC
LIMIT 1 ?>
|
| 0.0002 | SELECT * FROM `metadata` WHERE `metadata`.`product_repo_id` IN (7) ?>
|
| 0.0002 | SELECT * FROM `metadata_keys` WHERE `metadata_keys`.`id` IN (2) ?>
|
| 0.0001 | SELECT * FROM `metadata_keys` WHERE `metadata_keys`.`id` IN (3) ?>
|
| 0.0002 | SELECT * FROM `metadata_keys` WHERE `metadata_keys`.`id` IN (4) ?>
|
| 0.0001 | SELECT * FROM `metadata_keys` WHERE `metadata_keys`.`id` IN (8) ?>
|
| 0.0001 | SELECT * FROM `metadata_keys` WHERE `metadata_keys`.`id` IN (9) ?>
|
| 0.0002 | SELECT * FROM `metadata_keys` WHERE `metadata_keys`.`id` IN (12) ?>
|
| 0.0002 | SELECT *
FROM `transportation`
WHERE `code` = 'AIR'
ORDER BY `id` ASC
LIMIT 1 ?>
|
| 0.0007 | SELECT *
FROM `packages`
WHERE `code` = 'BLUSKY-ZTHAPTSOR' ?>
|
| 0.0003 | SELECT * FROM `geo` WHERE `geo`.`id` IN (SELECT `package_geo`.`geo_id` FROM `package_geo` WHERE `package_geo`.`package_id` IN (171)) ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 16
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0002 | SELECT *
FROM `tourguides`
WHERE `supplier_id` = 9 AND FIND_IN_SET(16, geo_ids) >0 ?>
|
| 0.0002 | SELECT *
FROM `tourguides`
WHERE `supplier_id` = 9 AND FIND_IN_SET(15, geo_ids) >0 ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 16
AND parent.id != 1
ORDER BY node.lft ?>
|
| 0.0003 | SELECT *
FROM `excursions`
WHERE `supplier_id` = 9 AND FIND_IN_SET(16, geo_ids) >0 ?>
|
| 0.0003 | SELECT *
FROM `excursions`
WHERE `supplier_id` = 9 AND FIND_IN_SET(15, geo_ids) >0 ?>
|
| 0.0002 | SELECT *
FROM `excursions`
WHERE `supplier_id` = 9 AND FIND_IN_SET(6, geo_ids) >0 ?>
|
| 0.0003 | SELECT *
FROM `excursions`
WHERE `supplier_id` = 9 AND FIND_IN_SET(1075, geo_ids) >0 ?>
|
| 0.0004 | SELECT *
FROM `reviews`
WHERE `accommodation_id` = 128 ?>
|
| 0.0002 | SELECT *
FROM `variables`
WHERE `var_name` = 'email_address' ?>
|
| 0.0002 | SELECT *
FROM `variables`
WHERE `var_name` = 'tel_no' ?>
|
| 0.0002 | SELECT *
FROM `variables`
WHERE `var_name` = 'opening_hours' ?>
|
| 0.0006 | SELECT parent.id AS id, parent.name AS name, parent.alias AS alias, parent.lft
FROM `geo` AS node,
`geo` AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.id = 15
AND parent.id != 1
ORDER BY node.lft ?>
|
