Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.34 ms
(84.19%)
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
  95991
  399568
  402887
  415814
  420606
  420652
  424105
  425144
  425149
  426868
  428963
  433282
  436049
  436418
  437161
  438366
  439020
  440649
  441940
  445274
  445384
  446449
  446604
  447551
  448148
  452181
  455131
  456646
  457340
  458286
  458869
  459732
  460059
  460548
  462274
  462295
  462523
  463672
  464781
  466752
  467828
  473308
  473523
  473642
  473645
  473903
  474107
  477147
  477176
  478693
  479273
  480975
  483232
  483238
  485588
  485663
  487380
  487698
  490715
  491549
  492456
  492498
  493276
  494350
  495182
  495327
  495965
  501303
  501340
  501747
  503682
  504069
  504834
  505863
  508175
  508755
  510071
  510665
  510721
  511122
  513344
  513420
  514788
  516157
  516538
  516914
  517178
  517940
  518309
  518335
  518899
  519803
  521629
  521933
  521951
  522267
  524436
  524507
  524577
  525759
  527713
  528106
  529511
  552622
  553258
  559780
  560794
  562607
  562803
  563744
  567315
  568845
  575555
  584424
  597190
  632851
  754078
  771591
  773241
]
19.34 ms
(10.69%)
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
  492498
  494350
  504069
  510071
  516538
  524507
  754078
  426868
  517940
  473523
  773241
  518309
  462295
  458286
  575555
  562607
  568845
  584424
  559780
  425144
  438366
  459732
  463672
  474107
  428963
  441940
  433282
  473903
  424105
  437161
  448148
  456646
  447551
  467828
  504834
  512847
  521951
  483232
  490715
  492456
  495182
  503682
  510721
  513344
  513420
  522267
  525759
  529511
  493276
  501303
  510665
  518335
  521933
  485663
  495965
  501747
  516157
  516914
  524436
  528106
  464781
  420652
  95991
  478693
  439020
  462523
  560794
  563744
  567315
  436049
  473642
  446604
  477176
  445384
  462274
  420606
  452181
  457340
  458869
  415814
  425149
  446449
  479273
  521629
  508755
  483238
  487380
  485588
  487698
  505863
  519803
  527713
  440649
  445274
  514788
  495327
  632851
  399568
  552622
  473308
  480975
  460059
  524577
  491549
  562803
  771591
  436418
  473645
  455131
  477147
  501340
  518899
  508175
  511122
  597190
  553258
  402887
  460548
  466752
  517178
]
2.39 ms
(1.32%)
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
  95991
  399568
  402887
  415814
  420606
  420652
  424105
  425144
  425149
  426868
  428963
  433282
  436049
  436418
  437161
  438366
  439020
  440649
  441940
  445274
  445384
  446449
  446604
  447551
  448148
  452181
  455131
  456646
  457340
  458286
  458869
  459732
  460059
  460548
  462274
  462295
  462523
  463672
  464781
  466752
  467828
  473308
  473523
  473642
  473645
  473903
  474107
  477147
  477176
  478693
  479273
  480975
  483232
  483238
  485588
  485663
  487380
  487698
  490715
  491549
  492456
  492498
  493276
  494350
  495182
  495327
  495965
  501303
  501340
  501747
  503682
  504069
  504834
  505863
  508175
  508755
  510071
  510665
  510721
  511122
  513344
  513420
  514788
  516157
  516538
  516914
  517178
  517940
  518309
  518335
  518899
  519803
  521629
  521933
  521951
  522267
  524436
  524507
  524577
  525759
  527713
  528106
  529511
  552622
  553258
  559780
  560794
  562607
  562803
  563744
  567315
  568845
  575555
  584424
  597190
  632851
  754078
  771591
  773241
]
2.02 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian girls"
]
1.80 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск девушк"
]
1.63 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.