Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.91 ms
(51.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
162.74 ms
(40.52%)
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
  191343
  233292
  233667
  385638
  385826
  397220
  398466
  406063
  408978
  409945
  411742
  425590
  447806
  466804
  466888
  466919
  466970
  470861
  471600
  472696
  472860
  475674
  476408
  476966
  479028
  483138
  485813
  487354
  504820
  507691
  525499
  536955
  537827
  540668
  545897
  546133
  547029
  548049
  548393
  557183
  579382
  589577
  599735
  607607
  610034
  615631
  623335
  642286
  643071
  663893
  665115
  665346
  665440
  665499
  665895
  666070
  666798
  667273
  667484
  670501
  685910
  692503
  710011
  712823
  714155
  721002
  726311
  726808
  726910
  731767
  733424
  738296
  739174
  739686
  739709
  741787
  741795
  742536
  745444
  752977
  754133
  758293
  770112
  770117
  773901
  779198
  780670
  780710
  781657
  781760
  781976
  781978
  782256
  784632
  788721
  789407
  794734
  795221
  797007
  801029
  801822
  803684
  804453
  807638
  808271
  810770
  811428
  812537
  814113
  817393
  818648
  819628
  820284
  823944
  823976
  824900
  824938
  825238
  827184
  827668
]
22.08 ms
(5.50%)
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
  773901
  781976
  794734
  795221
  803684
  804453
  808271
  726311
  726910
  739174
  770117
  745444
  739686
  741787
  731767
  710011
  714155
  721002
  780710
  781760
  784632
  811428
  409945
  191343
  233292
  479028
  485813
  385826
  397220
  398466
  824938
  814113
  820284
  823976
  827184
  818648
  825238
  817393
  819628
  824900
  827668
  466804
  487354
  537827
  540668
  504820
  536955
  507691
  466919
  472860
  476408
  546133
  548393
  545897
  547029
  548049
  579382
  666070
  666798
  685910
  663893
  665115
  665499
  667484
  670501
  692503
  665346
  665440
  665895
  667273
  557183
  589577
  610034
  643071
  607607
  623335
  599735
  781978
  788721
  797007
  801822
  779198
  780670
  781657
  801029
  789407
  739709
  754133
  742536
  733424
  738296
  741795
  770112
  726808
  752977
  758293
  642286
  782256
  807638
  812537
  466970
  425590
  233667
  615631
  525499
  466888
  475674
  712823
  810770
  472696
  385638
  406063
  408978
  411742
  823944
  447806
  470861
  471600
  476966
  483138
]
3.66 ms
(0.91%)
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
  191343
  233292
  233667
  385638
  385826
  397220
  398466
  406063
  408978
  409945
  411742
  425590
  447806
  466804
  466888
  466919
  466970
  470861
  471600
  472696
  472860
  475674
  476408
  476966
  479028
  483138
  485813
  487354
  504820
  507691
  525499
  536955
  537827
  540668
  545897
  546133
  547029
  548049
  548393
  557183
  579382
  589577
  599735
  607607
  610034
  615631
  623335
  642286
  643071
  663893
  665115
  665346
  665440
  665499
  665895
  666070
  666798
  667273
  667484
  670501
  685910
  692503
  710011
  712823
  714155
  721002
  726311
  726808
  726910
  731767
  733424
  738296
  739174
  739686
  739709
  741787
  741795
  742536
  745444
  752977
  754133
  758293
  770112
  770117
  773901
  779198
  780670
  780710
  781657
  781760
  781976
  781978
  782256
  784632
  788721
  789407
  794734
  795221
  797007
  801029
  801822
  803684
  804453
  807638
  808271
  810770
  811428
  812537
  814113
  817393
  818648
  819628
  820284
  823944
  823976
  824900
  824938
  825238
  827184
  827668
]
1.98 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "granny hair"
]
1.83 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "granny hair"
]
1.45 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "granny hair"
]

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.