Redirect 301 redirect from GET @app_home (38105a)

GET https://istanbuldiamonds.com/en

Query Metrics

42 Database Queries
13 Different statements
12.69 ms Query time
3 Invalid entities
53 Managed entities

Grouped Statements

Show all queries

Time Count Info
3.94 ms
(31.01%)
20
SELECT t0.id AS id_1, t0.image AS image_2, t0.status AS status_3, t0.parent_id AS parent_id_4 FROM category t0 WHERE t0.id = ?
Parameters:
[
  7
]
2.01 ms
(15.83%)
2
SELECT p0_.id AS id_0, p0_.pcode AS pcode_1, p0_.image AS image_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.metal AS metal_5, p0_.weight AS weight_6, p0_.user_id AS user_id_7, p0_.status AS status_8, p0_.campaign AS campaign_9, COALESCE(p1_.title, p2_.title) AS sclr_10, COALESCE(p1_.description, p2_.description) AS sclr_11, p0_.pcode AS pcode_12, p0_.image AS image_13, p0_.price AS price_14, p0_.quantity AS quantity_15, p0_.metal AS metal_16, p0_.id AS id_17, p0_.status AS status_18, p0_.category_id AS category_id_19 FROM product p0_ LEFT JOIN product_lang p1_ ON p0_.id = p1_.product_id AND (p1_.lang = ?) LEFT JOIN product_lang p2_ ON p0_.id = p2_.product_id AND (p2_.lang = ?) WHERE p0_.status = 1 LIMIT 12
Parameters:
[
  "en"
  "en"
]
1.80 ms
(14.17%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id is NULL AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]
0.77 ms
(6.04%)
1
SELECT t0.id AS id_1, t0.lang AS lang_2, t0.title AS title_3, t0.keywords AS keywords_4, t0.description AS description_5, t0.about AS about_6, t0.contact AS contact_7 FROM setting_lang t0 WHERE t0.lang = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  "en"
]
0.61 ms
(4.82%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 23  AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]
0.58 ms
(4.57%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 7  AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]
0.47 ms
(3.72%)
1
SELECT t0.id AS id_1, t0.lang AS lang_2, t0.title AS title_3, t0.keywords AS keywords_4, t0.description AS description_5, t0.category_id AS category_id_6 FROM category_lang t0 WHERE t0.lang = ?
Parameters:
[
  "en"
]
0.44 ms
(3.49%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 1  AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]
0.44 ms
(3.48%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 3  AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]
0.44 ms
(3.48%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 11  AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]
0.41 ms
(3.24%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 13  AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]
0.39 ms
(3.10%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 2  AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]
0.39 ms
(3.07%)
2
SELECT c.id as catid, cl.title as title FROM category c JOIN category_lang cl on c.id = cl.category_id WHERE cl.lang = 'en' AND c.parent_id = 12  AND c.status=1 ORDER BY cl.title ASC
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CategoryLang 20
App\Entity\Category 20
App\Entity\Product 12
App\Entity\SettingLang 1

Entities Mapping

Class Mapping errors
App\Entity\SettingLang No errors.
App\Entity\CategoryLang
  • The association App\Entity\CategoryLang#category refers to the inverse side field App\Entity\Category#categorylang which does not exist.
App\Entity\Category
  • The mappings App\Entity\Category#categoryLangs and App\Entity\CategoryLang#category are inconsistent with each other.
App\Entity\Product
  • The association App\Entity\Product#translations refers to the owning side field App\Entity\ProductLang#product_id which does not exist.
  • The field App\Entity\Product#productLangs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductLang#product does not contain the required 'inversedBy: "productLangs"' attribute.
App\Entity\ProductLang No errors.
App\Entity\ProductImages No errors.
App\Entity\Image No errors.