Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.52 ms
(87.37%)
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
  96341
  114153
  263259
  396415
  399143
  402628
  410851
  412092
  415220
  422134
  434382
  435131
  435171
  439117
  441233
  445718
  448327
  448758
  449300
  449992
  452720
  453020
  453332
  454531
  455079
  456219
  459211
  459745
  460323
  464120
  467725
  472547
  475140
  480279
  481961
  489324
  490135
  492726
  498630
  502776
  504474
  507193
  510198
  511073
  513330
  517745
  517798
  518643
  530479
  532816
  533276
  533389
  536538
  539370
  541757
  541760
  545451
  545605
  555390
  561495
  565175
  567737
  575445
  584460
  584748
  586339
  588070
  595028
  604053
  604062
  605742
  634157
  634472
  635258
  636414
  639645
  639760
  639818
  647895
  648235
  653520
  666863
  666888
  685511
  693809
  695882
  708472
  713189
  725649
  738496
  745964
  756992
  765224
  766234
  766505
  766556
  773416
  778892
  782041
  783928
  784720
  792223
  800082
  800884
  801041
  801084
  803672
  805336
  805698
  807011
  812336
  814114
  814178
  814202
  814883
  815847
  815969
  817901
  819228
  827901
]
15.13 ms
(7.80%)
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
  765224
  114153
  434382
  441233
  561495
  435131
  635258
  575445
  782041
  725649
  801084
  805698
  766234
  801041
  805336
  584748
  532816
  263259
  410851
  815969
  815847
  456219
  460323
  453020
  459745
  504474
  545451
  653520
  595028
  634157
  812336
  807011
  773416
  738496
  800884
  480279
  435171
  472547
  415220
  475140
  448758
  492726
  498630
  517798
  502776
  539370
  533276
  513330
  695882
  783928
  713189
  817901
  827901
  588070
  402628
  814178
  449300
  489324
  449992
  565175
  541760
  459211
  445718
  481961
  511073
  490135
  399143
  452720
  518643
  541757
  586339
  636414
  605742
  792223
  530479
  510198
  648235
  666863
  634472
  604062
  536538
  639818
  639760
  584460
  455079
  96341
  814883
  454531
  453332
  439117
  448327
  467725
  412092
  422134
  517745
  507193
  685511
  396415
  814114
  819228
  533389
  666888
  693809
  567737
  639645
  778892
  800082
  756992
  784720
  766505
  647895
  814202
  745964
  555390
  604053
  803672
  545605
  464120
  708472
  766556
]
3.20 ms
(1.65%)
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
  96341
  114153
  263259
  396415
  399143
  402628
  410851
  412092
  415220
  422134
  434382
  435131
  435171
  439117
  441233
  445718
  448327
  448758
  449300
  449992
  452720
  453020
  453332
  454531
  455079
  456219
  459211
  459745
  460323
  464120
  467725
  472547
  475140
  480279
  481961
  489324
  490135
  492726
  498630
  502776
  504474
  507193
  510198
  511073
  513330
  517745
  517798
  518643
  530479
  532816
  533276
  533389
  536538
  539370
  541757
  541760
  545451
  545605
  555390
  561495
  565175
  567737
  575445
  584460
  584748
  586339
  588070
  595028
  604053
  604062
  605742
  634157
  634472
  635258
  636414
  639645
  639760
  639818
  647895
  648235
  653520
  666863
  666888
  685511
  693809
  695882
  708472
  713189
  725649
  738496
  745964
  756992
  765224
  766234
  766505
  766556
  773416
  778892
  782041
  783928
  784720
  792223
  800082
  800884
  801041
  801084
  803672
  805336
  805698
  807011
  812336
  814114
  814178
  814202
  814883
  815847
  815969
  817901
  819228
  827901
]
1.70 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "squirt ass"
]
1.66 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сквирт оргазм жоп"
]
1.21 ms
(0.62%)
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.