Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.16 ms
(55.13%)
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
  16851
  400494
  421825
  421831
  421840
  421875
  421878
  421900
  421922
  422151
  422152
  422155
  422159
  428756
  428761
  433323
  433371
  439685
  439763
  439764
  439770
  442613
  443167
  443801
  444883
  454141
  459513
  461843
  464381
  480417
  485057
  485064
  487228
  488772
  493816
  496518
  510254
  513001
  513750
  516034
  516483
  517564
  519512
  521759
  523840
  523907
  524210
  524217
  525286
  525964
  526951
  527908
  529143
  532572
  533848
  537670
  537672
  539147
  540071
  541074
  541316
  544964
  563787
  563875
  568062
  572038
  572697
  572716
  576002
  577491
  577620
  579088
  579292
  580160
  583247
  586009
  594353
  599967
  600411
  600995
  604419
  606624
  612053
  621764
  623089
  624990
  626136
  631919
  636598
  639810
  647328
  647600
  647609
  650992
  660834
  661970
  668528
  718798
  724637
  728946
  732905
  750701
  786552
  792599
  809223
  811208
  814850
]
146.65 ms
(38.11%)
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
  16851
  400494
  421825
  421831
  421840
  421875
  421878
  421900
  421922
  422151
  422152
  422155
  422159
  428756
  428761
  433323
  433371
  439685
  439763
  439764
  439770
  442613
  443167
  443801
  444883
  454141
  459513
  461843
  464381
  480417
  485057
  485064
  487228
  488772
  493816
  496518
  510254
  513001
  513750
  516034
  516483
  517564
  519512
  521759
  523840
  523907
  524210
  524217
  525286
  525964
  526951
  527908
  529143
  532572
  533848
  537670
  537672
  539147
  540071
  541074
  541316
  544964
  563787
  563875
  568062
  572038
  572697
  572716
  576002
  577491
  577620
  579088
  579292
  580160
  583247
  586009
  594353
  599967
  600411
  600995
  604419
  606624
  612053
  621764
  623089
  624990
  626136
  631919
  636598
  639810
  647328
  647600
  647609
  650992
  660834
  661970
  668528
  718798
  724637
  728946
  732905
  750701
  786552
  792599
  809223
  811208
  814850
]
18.90 ms
(4.91%)
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
  583247
  580160
  647600
  661970
  544964
  579088
  624990
  792599
  809223
  732905
  811208
  724637
  421840
  464381
  480417
  16851
  421875
  422152
  439685
  439763
  443801
  421825
  461843
  493816
  487228
  516483
  524210
  525964
  600411
  636598
  459513
  443167
  814850
  485057
  485064
  539147
  521759
  516034
  533848
  576002
  541074
  541316
  572697
  577620
  647609
  647328
  631919
  422159
  400494
  421831
  439770
  433371
  523907
  488772
  524217
  519512
  525286
  606624
  439764
  442613
  444883
  513750
  572038
  579292
  718798
  660834
  668528
  586009
  728946
  786552
  750701
  421922
  421878
  421900
  422151
  454141
  523840
  527908
  428756
  496518
  537672
  529143
  537670
  540071
  650992
  563875
  623089
  594353
  600995
  612053
  422155
  433323
  517564
  526951
  532572
  563787
  626136
  604419
  639810
  428761
  572716
  510254
  599967
  513001
  568062
  577491
  621764
]
2.03 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real milf mom"
]
1.83 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real milf mom"
]
1.72 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real milf mom"
]

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.