Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.73 ms
(86.86%)
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
  90684
  95864
  385165
  391379
  418953
  419707
  441874
  449107
  449883
  455241
  456889
  456971
  465782
  468956
  469709
  472616
  478397
  480461
  480475
  482140
  484861
  487892
  489452
  490864
  490879
  491393
  492002
  492511
  492515
  492703
  494261
  494768
  498024
  498038
  498066
  498174
  498183
  499814
  503047
  506004
  506522
  507221
  507368
  512070
  515266
  515276
  516442
  519948
  519951
  520014
  520312
  520313
  520455
  522470
  524496
  524505
  524511
  526025
  530787
  533040
  534382
  538602
  540954
  541329
  542191
  546803
  548550
  548557
  549754
  552129
  553328
  553717
  555968
  560149
  565925
  566187
  566243
  569596
  572006
  572009
  573315
  579199
  580391
  584676
  584679
  586472
  586488
  586494
  586503
  587880
  591697
  593347
  593385
  593532
  593534
  602744
  605383
  607322
  607742
  631961
  632970
  633124
  633528
  640525
  647964
  665425
  668377
  668997
  687588
  688342
  714652
  717860
  751457
  752162
  790220
  814748
  814829
  814877
  814945
  815567
]
16.57 ms
(8.38%)
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
  526025
  487892
  546803
  687588
  560149
  790220
  385165
  814877
  456971
  584676
  688342
  579199
  633528
  391379
  419707
  489452
  533040
  586488
  490879
  534382
  552129
  553328
  584679
  668997
  593385
  631961
  90684
  441874
  815567
  572009
  607742
  469709
  507368
  714652
  542191
  95864
  530787
  484861
  566187
  640525
  491393
  751457
  814945
  503047
  632970
  752162
  478397
  520455
  519951
  668377
  591697
  587880
  455241
  468956
  498066
  665425
  492703
  480475
  506522
  524505
  569596
  456889
  515276
  449107
  512070
  482140
  548557
  572006
  465782
  647964
  494261
  814748
  814829
  490864
  492511
  519948
  507221
  520014
  602744
  492002
  717860
  492515
  449883
  515266
  524496
  522470
  498024
  580391
  506004
  593532
  498183
  541329
  593534
  593347
  586503
  499814
  565925
  607322
  480461
  498174
  586494
  520312
  520313
  586472
  472616
  524511
  548550
  555968
  494768
  566243
  418953
  498038
  605383
  633124
  549754
  538602
  516442
  553717
  540954
  573315
]
2.23 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx доктор секс"
]
2.16 ms
(1.09%)
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
  90684
  95864
  385165
  391379
  418953
  419707
  441874
  449107
  449883
  455241
  456889
  456971
  465782
  468956
  469709
  472616
  478397
  480461
  480475
  482140
  484861
  487892
  489452
  490864
  490879
  491393
  492002
  492511
  492515
  492703
  494261
  494768
  498024
  498038
  498066
  498174
  498183
  499814
  503047
  506004
  506522
  507221
  507368
  512070
  515266
  515276
  516442
  519948
  519951
  520014
  520312
  520313
  520455
  522470
  524496
  524505
  524511
  526025
  530787
  533040
  534382
  538602
  540954
  541329
  542191
  546803
  548550
  548557
  549754
  552129
  553328
  553717
  555968
  560149
  565925
  566187
  566243
  569596
  572006
  572009
  573315
  579199
  580391
  584676
  584679
  586472
  586488
  586494
  586503
  587880
  591697
  593347
  593385
  593532
  593534
  602744
  605383
  607322
  607742
  631961
  632970
  633124
  633528
  640525
  647964
  665425
  668377
  668997
  687588
  688342
  714652
  717860
  751457
  752162
  790220
  814748
  814829
  814877
  814945
  815567
]
1.97 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx doctor sex"
]
1.52 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx доктор секс"
]

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.