Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.60 ms
(86.73%)
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
  108925
  326134
  360015
  383118
  384332
  391537
  396395
  399058
  402626
  412814
  413235
  415303
  415961
  416501
  416561
  416611
  416624
  416631
  416666
  416725
  420356
  421072
  423434
  427970
  428241
  439230
  443418
  446353
  448199
  455353
  455914
  457974
  457975
  458675
  458922
  463262
  465006
  465516
  465548
  465604
  468665
  482814
  482825
  485161
  492482
  497776
  500940
  501440
  508910
  511488
  511864
  514233
  516685
  517861
  518935
  519209
  523398
  524863
  524870
  533002
  536576
  536847
  537922
  538309
  541135
  547523
  549506
  566784
  575850
  575852
  579648
  579651
  580166
  580183
  580691
  592409
  597190
  597234
  597267
  597472
  598675
  600118
  622392
  623973
  633439
  633442
  633512
  633801
  634327
  637087
  640741
  640785
  644271
  647349
  649569
  650845
  664633
  671674
  671677
  675897
  680198
  680816
  685718
  733838
  733843
  733883
  752973
  755079
  756406
  756775
  759845
  760267
  761275
  780530
  785421
  786461
  805707
  806084
  811643
  814948
]
16.01 ms
(8.19%)
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
  465516
  538309
  580166
  541135
  566784
  600118
  759845
  439230
  756775
  455353
  633439
  412814
  416611
  423434
  455914
  511864
  524870
  680816
  597190
  597267
  416631
  518935
  671677
  637087
  391537
  326134
  537922
  650845
  671674
  685718
  399058
  814948
  465604
  649569
  633512
  640785
  780530
  733883
  733838
  733843
  811643
  516685
  448199
  482814
  465006
  517861
  523398
  536576
  575850
  580183
  644271
  756406
  760267
  786461
  383118
  396395
  402626
  416624
  420356
  428241
  536847
  511488
  549506
  580691
  680198
  597234
  592409
  633801
  634327
  633442
  640741
  806084
  752973
  785421
  761275
  458922
  421072
  524863
  533002
  465548
  675897
  598675
  623973
  755079
  463262
  413235
  458675
  108925
  415961
  501440
  508910
  492482
  416561
  416666
  416725
  446353
  485161
  519209
  482825
  579648
  579651
  547523
  575852
  664633
  647349
  597472
  622392
  360015
  457974
  416501
  384332
  415303
  443418
  468665
  457975
  500940
  514233
  805707
  427970
  497776
]
2.51 ms
(1.29%)
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
  108925
  326134
  360015
  383118
  384332
  391537
  396395
  399058
  402626
  412814
  413235
  415303
  415961
  416501
  416561
  416611
  416624
  416631
  416666
  416725
  420356
  421072
  423434
  427970
  428241
  439230
  443418
  446353
  448199
  455353
  455914
  457974
  457975
  458675
  458922
  463262
  465006
  465516
  465548
  465604
  468665
  482814
  482825
  485161
  492482
  497776
  500940
  501440
  508910
  511488
  511864
  514233
  516685
  517861
  518935
  519209
  523398
  524863
  524870
  533002
  536576
  536847
  537922
  538309
  541135
  547523
  549506
  566784
  575850
  575852
  579648
  579651
  580166
  580183
  580691
  592409
  597190
  597234
  597267
  597472
  598675
  600118
  622392
  623973
  633439
  633442
  633512
  633801
  634327
  637087
  640741
  640785
  644271
  647349
  649569
  650845
  664633
  671674
  671677
  675897
  680198
  680816
  685718
  733838
  733843
  733883
  752973
  755079
  756406
  756775
  759845
  760267
  761275
  780530
  785421
  786461
  805707
  806084
  811643
  814948
]
2.03 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex monster"
]
1.88 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс monster"
]
1.77 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс monster"
]
1.74 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.

Entities Mapping

No loaded entities.