Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.72 ms
(60.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
111.87 ms
(32.25%)
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
  151564
  203811
  233532
  246509
  281450
  323088
  382160
  382982
  383244
  384050
  387182
  387186
  396865
  422464
  427755
  435520
  451455
  457713
  459120
  465876
  469813
  484116
  490324
  502920
  533204
  535365
  539654
  549325
  552161
  552225
  559053
  562300
  562780
  566818
  569847
  570004
  570507
  570567
  572563
  572568
  573792
  598906
  611304
  622823
  628081
  644010
  652949
  665840
  672444
  672492
  674865
  679391
  679882
  684369
  688560
  690881
  692013
  695817
  701451
  703104
  703628
  706432
  706754
  707459
  710837
  712670
  713110
  714563
  717889
  718416
  718934
  719085
  719171
  721225
  722214
  722664
  724752
  724755
  727398
  727425
  730517
  730790
  733151
  734607
  737169
  742186
  747568
  753269
  760821
  776672
  781014
  783584
  785433
  785770
  796800
  797628
  799260
  800233
  801366
  801868
  802316
  802486
  802487
  803176
  804216
  805875
  809931
  810666
  810922
  811285
  811820
  815807
  817109
  817300
  817526
  820054
  821042
  826273
]
16.13 ms
(4.65%)
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
  674865
  714563
  679391
  721225
  566818
  623802
  628081
  781014
  797628
  796800
  804216
  724752
  734607
  753269
  730517
  733151
  701451
  809931
  427755
  815807
  826273
  817300
  539654
  533204
  484116
  552225
  559053
  570567
  703628
  718934
  706432
  666803
  695817
  776672
  802486
  811285
  801868
  805875
  724755
  800233
  801366
  802487
  727425
  730790
  742186
  760821
  703104
  722664
  810922
  151564
  384050
  387186
  281450
  451455
  490324
  598906
  422464
  246509
  382160
  396865
  820054
  817109
  457713
  535365
  573792
  562300
  562780
  570507
  572568
  652949
  672444
  722214
  679882
  684369
  690881
  710837
  712670
  688560
  713110
  572563
  611304
  622823
  644010
  802316
  783584
  799260
  811820
  727398
  747568
  737169
  706754
  707459
  719085
  785433
  785770
  803176
  810666
  383244
  469813
  203811
  233532
  435520
  465876
  382982
  323088
  387182
  821042
  817526
  459120
  502920
  549325
  552161
  569847
  570004
  665840
  717889
  718416
  719171
  672492
  692013
]
2.77 ms
(0.80%)
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
  151564
  203811
  233532
  246509
  281450
  323088
  382160
  382982
  383244
  384050
  387182
  387186
  396865
  422464
  427755
  435520
  451455
  457713
  459120
  465876
  469813
  484116
  490324
  502920
  533204
  535365
  539654
  549325
  552161
  552225
  559053
  562300
  562780
  566818
  569847
  570004
  570507
  570567
  572563
  572568
  573792
  598906
  611304
  622823
  628081
  644010
  652949
  665840
  672444
  672492
  674865
  679391
  679882
  684369
  688560
  690881
  692013
  695817
  701451
  703104
  703628
  706432
  706754
  707459
  710837
  712670
  713110
  714563
  717889
  718416
  718934
  719085
  719171
  721225
  722214
  722664
  724752
  724755
  727398
  727425
  730517
  730790
  733151
  734607
  737169
  742186
  747568
  753269
  760821
  776672
  781014
  783584
  785433
  785770
  796800
  797628
  799260
  800233
  801366
  801868
  802316
  802486
  802487
  803176
  804216
  805875
  809931
  810666
  810922
  811285
  811820
  815807
  817109
  817300
  817526
  820054
  821042
  826273
]
2.02 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kissing hot"
]
1.77 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kissing hot"
]
1.59 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kissing hot"
]

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.