Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.06 ms
(83.96%)
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
  83499
  249622
  391890
  392165
  420005
  465246
  507114
  514702
  529841
  530092
  530651
  530664
  532402
  533700
  533712
  534628
  534862
  535359
  535371
  535407
  535408
  536082
  537308
  539290
  542443
  547445
  547941
  550498
  552497
  552717
  554709
  560342
  560493
  567891
  568612
  577679
  578772
  584360
  585091
  587739
  589773
  592741
  593661
  595029
  599705
  611541
  613599
  616457
  617242
  619646
  625328
  626411
  626831
  633563
  635569
  642982
  689266
  692437
  714456
  714581
  718033
  718703
  718717
  721938
  721972
  727045
  728276
  731399
  732584
  734028
  734261
  735235
  739718
  740238
  740761
  742673
  745074
  757557
  768607
  777643
  778140
  780201
  780210
  780884
  786588
  788505
  789650
  798812
  798857
  799822
  800448
  800503
  800663
  802803
  803303
  809742
  811091
  817403
  817519
  817788
  818145
  819438
  819452
  819469
  819820
  823157
  823815
  825538
  826901
  828004
  828065
  828075
  828141
  828155
  828160
  828221
  828286
  828406
  828427
]
13.37 ms
(9.51%)
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
  535408
  530092
  626831
  625328
  788505
  391890
  828221
  828427
  539290
  587739
  534628
  585091
  780201
  734028
  803303
  534862
  465246
  818145
  823815
  819820
  727045
  577679
  507114
  249622
  83499
  392165
  817403
  817519
  819438
  819452
  823157
  817788
  828065
  825538
  530664
  542443
  552717
  568612
  718717
  547941
  554709
  611541
  592741
  789650
  798857
  800503
  734261
  740761
  811091
  740238
  735235
  633563
  780884
  800663
  535359
  560493
  567891
  689266
  721972
  584360
  635569
  619646
  786588
  739718
  732584
  745074
  728276
  617242
  642982
  819469
  537308
  714456
  777643
  768607
  828160
  529841
  533712
  536082
  530651
  533700
  535371
  535407
  532402
  547445
  593661
  599705
  778140
  799822
  780210
  800448
  809742
  731399
  757557
  742673
  714581
  718033
  721938
  798812
  595029
  828141
  828004
  599767
  578772
  552497
  718703
  616457
  626411
  802803
  550498
  589773
  514702
  613599
  826901
  828406
  828155
  828286
  420005
  828075
  692437
  560342
]
2.75 ms
(1.96%)
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
  83499
  249622
  391890
  392165
  420005
  465246
  507114
  514702
  529841
  530092
  530651
  530664
  532402
  533700
  533712
  534628
  534862
  535359
  535371
  535407
  535408
  536082
  537308
  539290
  542443
  547445
  547941
  550498
  552497
  552717
  554709
  560342
  560493
  567891
  568612
  577679
  578772
  584360
  585091
  587739
  589773
  592741
  593661
  595029
  599705
  611541
  613599
  616457
  617242
  619646
  625328
  626411
  626831
  633563
  635569
  642982
  689266
  692437
  714456
  714581
  718033
  718703
  718717
  721938
  721972
  727045
  728276
  731399
  732584
  734028
  734261
  735235
  739718
  740238
  740761
  742673
  745074
  757557
  768607
  777643
  778140
  780201
  780210
  780884
  786588
  788505
  789650
  798812
  798857
  799822
  800448
  800503
  800663
  802803
  803303
  809742
  811091
  817403
  817519
  817788
  818145
  819438
  819452
  819469
  819820
  823157
  823815
  825538
  826901
  828004
  828065
  828075
  828141
  828155
  828160
  828221
  828286
  828406
  828427
]
1.97 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife public stranger"
]
1.60 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен на stranger улиц"
]
1.54 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен на stranger улиц"
]

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.