Query Metrics

7 Database Queries
7 Different statements
607.47 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
416.89 ms
(68.63%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  115206
  370557
  412173
  413592
  415115
  415534
  417202
  417746
  419729
  422330
  424379
  428052
  430796
  433644
  435744
  443097
  444994
  445106
  445897
  446970
  448426
  448574
  449371
  449914
  452037
  452608
  453522
  454788
  456814
  458632
  460098
  461904
  462450
  462601
  462734
  462805
  466599
  467810
  468590
  469524
  469931
  471186
  471307
  472090
  472334
  474615
  474972
  479998
  480895
  485585
  485586
  487020
  487069
  487472
  488730
  489609
  490007
  490008
  490734
  491594
  491882
  492099
  492244
  493402
  494784
  494843
  495003
  495103
  495448
  495686
  500056
  502218
  502346
  502598
  505683
  506477
  508780
  509360
  510817
  512323
  513697
  513747
  513983
  514018
  514318
  515371
  515434
  515522
  516196
  516360
  516929
  517590
  517960
  518219
  519876
  520306
  521522
  522501
  522926
  523299
  523533
  523655
  523859
  523969
  523996
  524614
  525140
  525216
  525850
  525854
  527172
  527710
  531464
  543195
  552467
  814753
  815624
  816267
  821383
  821532
]
163.49 ms
(26.91%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  115206
  370557
  412173
  413592
  415115
  415534
  417202
  417746
  419729
  422330
  424379
  428052
  430796
  433644
  435744
  443097
  444994
  445106
  445897
  446970
  448426
  448574
  449371
  449914
  452037
  452608
  453522
  454788
  456814
  458632
  460098
  461904
  462450
  462601
  462734
  462805
  466599
  467810
  468590
  469524
  469931
  471186
  471307
  472090
  472334
  474615
  474972
  479998
  480895
  485585
  485586
  487020
  487069
  487472
  488730
  489609
  490007
  490008
  490734
  491594
  491882
  492099
  492244
  493402
  494784
  494843
  495003
  495103
  495448
  495686
  500056
  502218
  502346
  502598
  505683
  506477
  508780
  509360
  510817
  512323
  513697
  513747
  513983
  514018
  514318
  515371
  515434
  515522
  516196
  516360
  516929
  517590
  517960
  518219
  519876
  520306
  521522
  522501
  522926
  523299
  523533
  523655
  523859
  523969
  523996
  524614
  525140
  525216
  525850
  525854
  527172
  527710
  531464
  543195
  552467
  814753
  815624
  816267
  821383
  821532
]
19.58 ms
(3.22%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  460098
  462601
  467810
  471186
  472334
  474972
  428052
  458632
  462734
  462805
  472090
  474615
  479998
  449371
  468590
  469524
  469931
  480895
  446970
  456814
  502218
  506477
  512323
  513747
  514318
  516360
  521522
  523655
  523969
  488730
  489609
  490008
  495003
  502346
  505683
  508780
  510817
  515434
  515522
  516929
  517960
  523299
  487020
  487069
  491594
  491882
  494843
  500056
  509360
  513983
  517590
  524614
  525216
  485585
  485586
  490007
  490734
  492244
  495103
  495448
  514018
  516196
  522501
  523533
  525140
  520306
  462450
  525854
  370557
  448574
  452608
  454788
  445897
  449914
  452037
  461904
  502598
  527710
  495686
  522926
  531464
  519876
  543195
  552467
  413592
  415115
  422330
  453522
  444994
  466599
  471307
  448426
  518219
  513697
  515371
  525850
  487472
  492099
  493402
  494784
  523859
  523996
  527172
  115206
  417746
  430796
  412173
  415534
  445106
  433644
  424379
  435744
  417202
  419729
  443097
  814753
  821383
  815624
  816267
  821532
]
2.20 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white leggings"
]
2.04 ms
(0.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white лосин"
]
1.53 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white лосин"
]

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

No loaded entities.