Query Metrics
58
Database Queries
27
Different statements
48.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.41 ms |
SELECT t0.id AS id_1, t0.fromurl AS fromurl_2, t0.tourl AS tourl_3, t0.timestamp AS timestamp_4 FROM general t0
Parameters:
[] |
| 2 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.permalink AS permalink_4, t0.manualmetatitle AS manualmetatitle_5, t0.manualmetadescription AS manualmetadescription_6, t0.manualh1 AS manualh1_7, t0.manualcontentone AS manualcontentone_8, t0.manualcontenttwo AS manualcontenttwo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.manualthumbnail AS manualthumbnail_12, t0.manualthumbnailname AS manualthumbnailname_13, t0.manualthumbnailalt AS manualthumbnailalt_14, t0.manual AS manual_15, t0.metatitle_id AS metatitle_id_16, t0.metadescription_id AS metadescription_id_17, t0.h1_id AS h1_id_18, t0.contentone_id AS contentone_id_19, t0.contenttwo_id AS contenttwo_id_20, t0.thumbnail_id AS thumbnail_id_21 FROM Counties t0 WHERE t0.permalink = ? LIMIT 1
Parameters:
[
"j%C3%B6nk%C3%B6ping"
]
|
| 3 | 2.28 ms |
SELECT c0_.id AS id_0, c0_.geonameid AS geonameid_1, c0_.name AS name_2, c0_.latitude AS latitude_3, c0_.longitude AS longitude_4, c0_.featureclass AS featureclass_5, c0_.featurecode AS featurecode_6, c0_.link AS link_7, c0_.permalink AS permalink_8, c0_.manualmetatitle AS manualmetatitle_9, c0_.manualmetadescription AS manualmetadescription_10, c0_.manualh1 AS manualh1_11, c0_.manualcontentone AS manualcontentone_12, c0_.manualcontenttwo AS manualcontenttwo_13, c0_.manualcontentthree AS manualcontentthree_14, c0_.manualthumbnail AS manualthumbnail_15, c0_.manualthumbnailname AS manualthumbnailname_16, c0_.manualthumbnailalt AS manualthumbnailalt_17, c0_.manual AS manual_18, c0_.population AS population_19, c0_.county_id AS county_id_20, c0_.metatitle_id AS metatitle_id_21, c0_.metadescription_id AS metadescription_id_22, c0_.h1_id AS h1_id_23, c0_.contentone_id AS contentone_id_24, c0_.contenttwo_id AS contenttwo_id_25, c0_.contentthree_id AS contentthree_id_26, c0_.thumbnail_id AS thumbnail_id_27, c0_.h2interesting_id AS h2interesting_id_28 FROM City c0_ INNER JOIN Counties c1_ ON c0_.county_id = c1_.id WHERE c1_.id = ? AND c0_.permalink = ?
Parameters:
[ 7 "olofstorp" ] |
| 4 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.street AS street_4, t0.zip AS zip_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.homepage AS homepage_9, t0.description AS description_10, t0.openinghours AS openinghours_11, t0.weekends AS weekends_12, t0.email AS email_13, t0.permalink AS permalink_14, t0.manualh1 AS manualh1_15, t0.manualh2 AS manualh2_16, t0.manualcontent AS manualcontent_17, t0.manualmetatitle AS manualmetatitle_18, t0.manualmetadescription AS manualmetadescription_19, t0.manualthumbnail AS manualthumbnail_20, t0.manualthumbnailname AS manualthumbnailname_21, t0.manualthumbnailalt AS manualthumbnailalt_22, t0.manual AS manual_23, t0.manualmapstring AS manualmapstring_24, t0.cityobj_id AS cityobj_id_25, t0.h1_id AS h1_id_26, t0.h2_id AS h2_id_27, t0.content_id AS content_id_28, t0.metatitle_id AS metatitle_id_29, t0.metadescription_id AS metadescription_id_30, t0.h2interesting_id AS h2interesting_id_31, t0.thumbnail_id AS thumbnail_id_32 FROM Company t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"FlyttstädningsAkuten AB"
]
|
| 5 | 0.13 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"MenuHeading"
]
|
| 6 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.permalink AS permalink_4, t0.manualmetatitle AS manualmetatitle_5, t0.manualmetadescription AS manualmetadescription_6, t0.manualh1 AS manualh1_7, t0.manualcontentone AS manualcontentone_8, t0.manualcontenttwo AS manualcontenttwo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.manualthumbnail AS manualthumbnail_12, t0.manualthumbnailname AS manualthumbnailname_13, t0.manualthumbnailalt AS manualthumbnailalt_14, t0.manual AS manual_15, t0.metatitle_id AS metatitle_id_16, t0.metadescription_id AS metadescription_id_17, t0.h1_id AS h1_id_18, t0.contentone_id AS contentone_id_19, t0.contenttwo_id AS contenttwo_id_20, t0.thumbnail_id AS thumbnail_id_21 FROM Counties t0
Parameters:
[] |
| 7 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.street AS street_4, t0.zip AS zip_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.homepage AS homepage_9, t0.description AS description_10, t0.openinghours AS openinghours_11, t0.weekends AS weekends_12, t0.email AS email_13, t0.permalink AS permalink_14, t0.manualh1 AS manualh1_15, t0.manualh2 AS manualh2_16, t0.manualcontent AS manualcontent_17, t0.manualmetatitle AS manualmetatitle_18, t0.manualmetadescription AS manualmetadescription_19, t0.manualthumbnail AS manualthumbnail_20, t0.manualthumbnailname AS manualthumbnailname_21, t0.manualthumbnailalt AS manualthumbnailalt_22, t0.manual AS manual_23, t0.manualmapstring AS manualmapstring_24, t0.cityobj_id AS cityobj_id_25, t0.h1_id AS h1_id_26, t0.h2_id AS h2_id_27, t0.content_id AS content_id_28, t0.metatitle_id AS metatitle_id_29, t0.metadescription_id AS metadescription_id_30, t0.h2interesting_id AS h2interesting_id_31, t0.thumbnail_id AS thumbnail_id_32 FROM Company t0 WHERE t0.cityobj_id = ?
Parameters:
[
21224
]
|
| 8 | 5.54 ms |
SELECT *, latitude, longitude, SQRT( POW(69.1 * (latitude - :lat), 2) + POW(69.1 * (:lon - longitude) * COS(latitude / 57.3), 2)) AS distance FROM Company ORDER BY distance LIMIT 0, 20
Parameters:
[ "lat" => "57.93333" "lon" => "14.65000" ] |
| 9 | 0.13 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4538
]
|
| 10 | 0.11 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 11 | 0.10 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3855
]
|
| 12 | 0.13 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3855
]
|
| 13 | 0.11 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3855
]
|
| 14 | 0.10 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3855
]
|
| 15 | 0.26 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 16 | 0.11 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 17 | 0.11 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 18 | 0.10 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 19 | 0.10 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 20 | 0.09 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 21 | 0.10 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 22 | 0.11 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4394
]
|
| 23 | 0.12 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4394
]
|
| 24 | 0.10 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4413
]
|
| 25 | 0.10 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4208
]
|
| 26 | 0.12 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4394
]
|
| 27 | 0.10 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4394
]
|
| 28 | 0.12 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4394
]
|
| 29 | 0.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.metatitle AS metatitle_3, t0.permalink AS permalink_4, t0.content AS content_5, t0.metadescription AS metadescription_6, t0.menuname AS menuname_7, t0.published AS published_8 FROM Page t0
Parameters:
[] |
| 30 | 0.09 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"Analytics"
]
|
| 31 | 0.08 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"HeaderAlt"
]
|
| 32 | 0.31 ms |
SELECT c0_.id AS id_0, c0_.geonameid AS geonameid_1, c0_.name AS name_2, c0_.latitude AS latitude_3, c0_.longitude AS longitude_4, c0_.featureclass AS featureclass_5, c0_.featurecode AS featurecode_6, c0_.link AS link_7, c0_.permalink AS permalink_8, c0_.manualmetatitle AS manualmetatitle_9, c0_.manualmetadescription AS manualmetadescription_10, c0_.manualh1 AS manualh1_11, c0_.manualcontentone AS manualcontentone_12, c0_.manualcontenttwo AS manualcontenttwo_13, c0_.manualcontentthree AS manualcontentthree_14, c0_.manualthumbnail AS manualthumbnail_15, c0_.manualthumbnailname AS manualthumbnailname_16, c0_.manualthumbnailalt AS manualthumbnailalt_17, c0_.manual AS manual_18, c0_.population AS population_19, c0_.county_id AS county_id_20, c0_.metatitle_id AS metatitle_id_21, c0_.metadescription_id AS metadescription_id_22, c0_.h1_id AS h1_id_23, c0_.contentone_id AS contentone_id_24, c0_.contenttwo_id AS contenttwo_id_25, c0_.contentthree_id AS contentthree_id_26, c0_.thumbnail_id AS thumbnail_id_27, c0_.h2interesting_id AS h2interesting_id_28 FROM City c0_ WHERE c0_.county_id = 7 ORDER BY c0_.name ASC
Parameters:
[] |
| 33 | 0.18 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Generalsettings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"formData"
]
|
| 34 | 0.12 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Articlesettings t0
Parameters:
[] |
| 35 | 31.76 ms |
SELECT *, latitude, longitude, SQRT( POW(69.1 * (latitude - :lat), 2) + POW(69.1 * (:lon - longitude) * COS(latitude / 57.3), 2)) AS distance FROM City WHERE id != 21224 ORDER BY distance LIMIT 0, 5
Parameters:
[ "lat" => "57.93333" "lon" => "14.65000" ] |
| 36 | 0.39 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3789
]
|
| 37 | 0.29 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4679
]
|
| 38 | 0.25 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
3996
]
|
| 39 | 0.24 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
21281
]
|
| 40 | 0.25 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4655
]
|
| 41 | 0.13 ms |
SELECT t0.id AS id_1, t0.description AS description_2 FROM Metadescriptioncity t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 42 | 0.11 ms |
SELECT t0.id AS id_1, t0.title AS title_2 FROM Metatitlecity t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 43 | 0.12 ms |
SELECT t0.id AS id_1, t0.h1 AS h1_2 FROM H1city t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 44 | 0.13 ms |
SELECT t0.id AS id_1, t0.content AS content_2 FROM Contentpartonecity t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 45 | 0.11 ms |
SELECT t0.id AS id_1, t0.content AS content_2 FROM Contentparttwocity t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 46 | 0.11 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.alt_id AS alt_id_3, t0.name_id AS name_id_4 FROM Citythumbnail t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 47 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Citythumbnailname t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 48 | 0.10 ms |
SELECT t0.id AS id_1, t0.alt AS alt_2 FROM Citythumbnailalt t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 49 | 0.09 ms |
SELECT t0.id AS id_1, t0.content AS content_2 FROM Contentpartthreecity t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 50 | 0.12 ms |
SELECT r0_.companyid AS companyid_0 FROM RedirectMapCompanies r0_
Parameters:
[] |
| 51 | 0.15 ms |
SELECT t0.id AS id_1, t0.h2 AS h2_2 FROM H2Interesting t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 52 | 0.75 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.article_id AS article_id_4, t0.city_id AS city_id_5 FROM InterestingarticleCity t0 WHERE t0.city_id = ?
Parameters:
[
21224
]
|
| 53 | 0.32 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.metatitle AS metatitle_3, t0.metadescription AS metadescription_4, t0.permalink AS permalink_5, t0.content AS content_6, t0.interestingarticle1 AS interestingarticle1_7, t0.interestingarticle2 AS interestingarticle2_8, t0.interestingarticle3 AS interestingarticle3_9, t0.interestingarticle4 AS interestingarticle4_10, t0.interestingarticle5 AS interestingarticle5_11, t0.published AS published_12, t0.status AS status_13 FROM Article t0 WHERE t0.id = ?
Parameters:
[
23
]
|
| 54 | 0.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.metatitle AS metatitle_3, t0.metadescription AS metadescription_4, t0.permalink AS permalink_5, t0.content AS content_6, t0.interestingarticle1 AS interestingarticle1_7, t0.interestingarticle2 AS interestingarticle2_8, t0.interestingarticle3 AS interestingarticle3_9, t0.interestingarticle4 AS interestingarticle4_10, t0.interestingarticle5 AS interestingarticle5_11, t0.published AS published_12, t0.status AS status_13 FROM Article t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 55 | 0.11 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.metatitle AS metatitle_3, t0.metadescription AS metadescription_4, t0.permalink AS permalink_5, t0.content AS content_6, t0.interestingarticle1 AS interestingarticle1_7, t0.interestingarticle2 AS interestingarticle2_8, t0.interestingarticle3 AS interestingarticle3_9, t0.interestingarticle4 AS interestingarticle4_10, t0.interestingarticle5 AS interestingarticle5_11, t0.published AS published_12, t0.status AS status_13 FROM Article t0 WHERE t0.id = ?
Parameters:
[
31
]
|
| 56 | 0.10 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.metatitle AS metatitle_3, t0.metadescription AS metadescription_4, t0.permalink AS permalink_5, t0.content AS content_6, t0.interestingarticle1 AS interestingarticle1_7, t0.interestingarticle2 AS interestingarticle2_8, t0.interestingarticle3 AS interestingarticle3_9, t0.interestingarticle4 AS interestingarticle4_10, t0.interestingarticle5 AS interestingarticle5_11, t0.published AS published_12, t0.status AS status_13 FROM Article t0 WHERE t0.id = ?
Parameters:
[
32
]
|
| 57 | 0.11 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.metatitle AS metatitle_3, t0.metadescription AS metadescription_4, t0.permalink AS permalink_5, t0.content AS content_6, t0.interestingarticle1 AS interestingarticle1_7, t0.interestingarticle2 AS interestingarticle2_8, t0.interestingarticle3 AS interestingarticle3_9, t0.interestingarticle4 AS interestingarticle4_10, t0.interestingarticle5 AS interestingarticle5_11, t0.published AS published_12, t0.status AS status_13 FROM Article t0 WHERE t0.id = ?
Parameters:
[
36
]
|
| 58 | 0.36 ms |
SELECT t0.id AS id_1, t0.geonameid AS geonameid_2, t0.name AS name_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.featureclass AS featureclass_6, t0.featurecode AS featurecode_7, t0.link AS link_8, t0.permalink AS permalink_9, t0.manualmetatitle AS manualmetatitle_10, t0.manualmetadescription AS manualmetadescription_11, t0.manualh1 AS manualh1_12, t0.manualcontentone AS manualcontentone_13, t0.manualcontenttwo AS manualcontenttwo_14, t0.manualcontentthree AS manualcontentthree_15, t0.manualthumbnail AS manualthumbnail_16, t0.manualthumbnailname AS manualthumbnailname_17, t0.manualthumbnailalt AS manualthumbnailalt_18, t0.manual AS manual_19, t0.population AS population_20, t0.county_id AS county_id_21, t0.metatitle_id AS metatitle_id_22, t0.metadescription_id AS metadescription_id_23, t0.h1_id AS h1_id_24, t0.contentone_id AS contentone_id_25, t0.contenttwo_id AS contenttwo_id_26, t0.contentthree_id AS contentthree_id_27, t0.thumbnail_id AS thumbnail_id_28, t0.h2interesting_id AS h2interesting_id_29 FROM City t0 INNER JOIN city_city ON t0.id = city_city.city_source WHERE city_city.city_target = ?
Parameters:
[
21224
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.