GET https://fsd6.webbamboo.net/Flyttst%C3%A4dning-G%C3%A4vle/Reng%C3%B6ringsgruppen-g%C3%A4vle-ab

Query Metrics

34 Database Queries
24 Different statements
7.44 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.43 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 1.86 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.permalink = ? LIMIT 1
Parameters:
[
  "reng%C3%B6ringsgruppen-g%C3%A4vle-ab"
]
3 0.19 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 = ?
Parameters:
[
  1435
]
4 0.28 ms
SELECT t0.id AS id_1, t0.fromlink AS fromlink_2, t0.cityid AS cityid_3, t0.companyid AS companyid_4, t0.tolink AS tolink_5 FROM RedirectMapCompanies t0 WHERE t0.companyid = ? AND t0.cityid = ? LIMIT 1
Parameters:
[
  1602
  1435
]
5 0.14 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"
]
6 0.12 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"
]
7 0.14 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:
[]
8 0.15 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:
[]
9 0.10 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"
]
10 0.10 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"
]
11 0.37 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 = 4 ORDER BY c0_.name ASC
Parameters:
[]
12 0.38 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"
]
13 0.16 ms
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3 FROM Articlesettings t0
Parameters:
[]
14 0.19 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 != 1435 ORDER BY distance LIMIT 0, 5
Parameters:
[
  "lat" => "60.67452"
  "lon" => "17.14174"
]
15 0.17 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:
[
  851
]
16 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:
[
  1608
]
17 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:
[
  597
]
18 0.15 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:
[
  1293
]
19 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:
[
  773
]
20 0.11 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM Metadescriptioncompany t0 WHERE t0.id = ?
Parameters:
[
  2
]
21 0.10 ms
SELECT t0.id AS id_1, t0.title AS title_2 FROM Metatitlecompany t0 WHERE t0.id = ?
Parameters:
[
  2
]
22 0.11 ms
SELECT t0.id AS id_1, t0.h1 AS h1_2 FROM H1company t0 WHERE t0.id = ?
Parameters:
[
  2
]
23 0.10 ms
SELECT t0.id AS id_1, t0.content AS content_2 FROM Contentcompany t0 WHERE t0.id = ?
Parameters:
[
  1
]
24 0.10 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 Companythumbnail t0 WHERE t0.id = ?
Parameters:
[
  9
]
25 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM Companythumbnailname t0 WHERE t0.id = ?
Parameters:
[
  5
]
26 0.09 ms
SELECT t0.id AS id_1, t0.alt AS alt_2 FROM Companythumbnailalt t0 WHERE t0.id = ?
Parameters:
[
  2
]
27 0.12 ms
SELECT t0.id AS id_1, t0.h2 AS h2_2 FROM H2Interesting t0 WHERE t0.id = ?
Parameters:
[
  10
]
28 0.39 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.company_id AS company_id_5 FROM Interestingarticle t0 WHERE t0.company_id = ?
Parameters:
[
  1602
]
29 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:
[
  8
]
30 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:
[
  16
]
31 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:
[
  13
]
32 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:
[
  41
]
33 0.09 ms
SELECT t0.id AS id_1, t0.h2 AS h2_2 FROM H2company t0 WHERE t0.id = ?
Parameters:
[
  2
]
34 0.41 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_company ON t0.id = city_company.city_id WHERE city_company.company_id = ?
Parameters:
[
  1602
]

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.

Entities Mapping

Class Mapping errors
Webbamboo\SpinnersCommon\Entity\General No errors.
Webbamboo\SpinnersCommon\Entity\Company No errors.
Webbamboo\SpinnersCommon\Entity\City No errors.
Webbamboo\SpinnersCommon\Entity\H1company No errors.
Webbamboo\SpinnersCommon\Entity\H2company No errors.
Webbamboo\SpinnersCommon\Entity\Contentcompany No errors.
Webbamboo\SpinnersCommon\Entity\Metatitlecompany No errors.
Webbamboo\SpinnersCommon\Entity\Metadescriptioncompany No errors.
Webbamboo\SpinnersCommon\Entity\H2Interesting No errors.
Webbamboo\SpinnersCommon\Entity\Companythumbnail No errors.
Webbamboo\SpinnersCommon\Entity\Interestingarticle No errors.
Webbamboo\SpinnersCommon\Entity\Counties No errors.
Webbamboo\SpinnersCommon\Entity\Metatitlecity No errors.
Webbamboo\SpinnersCommon\Entity\Metadescriptioncity No errors.
Webbamboo\SpinnersCommon\Entity\H1city No errors.
Webbamboo\SpinnersCommon\Entity\Contentpartonecity No errors.
Webbamboo\SpinnersCommon\Entity\Contentparttwocity No errors.
Webbamboo\SpinnersCommon\Entity\Contentpartthreecity No errors.
Webbamboo\SpinnersCommon\Entity\Citythumbnail No errors.
Webbamboo\SpinnersCommon\Entity\InterestingarticleCity No errors.
Webbamboo\SpinnersCommon\Entity\RedirectMapCompanies No errors.
Webbamboo\SpinnersCommon\Entity\Generalsettings No errors.
Webbamboo\SpinnersCommon\Entity\Metatitlecounty No errors.
Webbamboo\SpinnersCommon\Entity\Metadescriptioncounty No errors.
Webbamboo\SpinnersCommon\Entity\H1county No errors.
Webbamboo\SpinnersCommon\Entity\Contentpartonecounty No errors.
Webbamboo\SpinnersCommon\Entity\Contentparttwocounty No errors.
Webbamboo\SpinnersCommon\Entity\Countythumbnail No errors.
Webbamboo\SpinnersCommon\Entity\Page No errors.
Webbamboo\SpinnersCommon\Entity\Articlesettings No errors.
Webbamboo\SpinnersCommon\Entity\Companythumbnailalt No errors.
Webbamboo\SpinnersCommon\Entity\Companythumbnailname No errors.
Webbamboo\SpinnersCommon\Entity\Article No errors.