Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.27 ms
(84.99%)
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
  400491
  415836
  416680
  417835
  418145
  419319
  421810
  421922
  421991
  424648
  427246
  428159
  428756
  439759
  443607
  444632
  444883
  446909
  447095
  448773
  451639
  454141
  454425
  455341
  455351
  455974
  456202
  460325
  460514
  460535
  463072
  464724
  466573
  467569
  473139
  473463
  477941
  481772
  485057
  485064
  485997
  489262
  490753
  493310
  494546
  495352
  502518
  502540
  504141
  504250
  504450
  506794
  507276
  508701
  509481
  509913
  510200
  511159
  511176
  511675
  512375
  512410
  513001
  513832
  515578
  518622
  519322
  519512
  519589
  519679
  519859
  521532
  522642
  523171
  523301
  523823
  523907
  525286
  527458
  527706
  527928
  528262
  547612
  551847
  557091
  557946
  557953
  562853
  564055
  564267
  576966
  586028
  591214
  593366
  595256
  597148
  598172
  598899
  601851
  601852
  601906
  604419
  610466
  612699
  621764
  622405
  623405
  624137
  624142
  624953
  625437
  628443
  651561
  652125
  652756
  657780
  684694
  725153
  728946
  760169
]
18.13 ms
(9.27%)
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
  428159
  417835
  460514
  519322
  511675
  657780
  490753
  466573
  523301
  624142
  481772
  513832
  495352
  624137
  421810
  519859
  444632
  467569
  494546
  628443
  598899
  760169
  557953
  564267
  651561
  622405
  725153
  439759
  455974
  463072
  421991
  506794
  485057
  485997
  511176
  511159
  562853
  564055
  460535
  477941
  443607
  512375
  419319
  485064
  510200
  557091
  601852
  591214
  512410
  527706
  504250
  519512
  455341
  522642
  576966
  624953
  454425
  416680
  473463
  523907
  509481
  528262
  527458
  610466
  586028
  418145
  424648
  515578
  557946
  728946
  456202
  504141
  684694
  460325
  454141
  415836
  527928
  612699
  504450
  523823
  446909
  451639
  509913
  521532
  444883
  455351
  652125
  551847
  447095
  421922
  507276
  508701
  427246
  493310
  464724
  519589
  502540
  502518
  652756
  525286
  400491
  428756
  448773
  518622
  519679
  595256
  489262
  473139
  621764
  523171
  601906
  598172
  604419
  601851
  625437
  547612
  597148
  623405
  513001
  593366
]
3.87 ms
(1.98%)
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
  400491
  415836
  416680
  417835
  418145
  419319
  421810
  421922
  421991
  424648
  427246
  428159
  428756
  439759
  443607
  444632
  444883
  446909
  447095
  448773
  451639
  454141
  454425
  455341
  455351
  455974
  456202
  460325
  460514
  460535
  463072
  464724
  466573
  467569
  473139
  473463
  477941
  481772
  485057
  485064
  485997
  489262
  490753
  493310
  494546
  495352
  502518
  502540
  504141
  504250
  504450
  506794
  507276
  508701
  509481
  509913
  510200
  511159
  511176
  511675
  512375
  512410
  513001
  513832
  515578
  518622
  519322
  519512
  519589
  519679
  519859
  521532
  522642
  523171
  523301
  523823
  523907
  525286
  527458
  527706
  527928
  528262
  547612
  551847
  557091
  557946
  557953
  562853
  564055
  564267
  576966
  586028
  591214
  593366
  595256
  597148
  598172
  598899
  601851
  601852
  601906
  604419
  610466
  612699
  621764
  622405
  623405
  624137
  624142
  624953
  625437
  628443
  651561
  652125
  652756
  657780
  684694
  725153
  728946
  760169
]
2.30 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real webcam sex"
]
1.99 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real вебкамер секс"
]
1.46 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real вебкамер секс"
]

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.