Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.60 ms
(83.27%)
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
  13646
  38261
  67464
  274930
  358398
  385427
  389351
  389618
  390041
  391472
  395166
  395685
  396396
  399668
  401307
  404582
  407786
  409179
  410352
  411744
  411776
  414315
  415542
  415734
  419220
  421215
  428853
  449358
  452869
  454208
  458343
  458438
  460621
  461628
  465340
  465409
  474872
  482186
  485362
  486535
  496709
  512217
  521764
  543592
  548499
  557347
  562181
  569445
  578291
  594782
  596449
  601619
  608049
  613470
  618858
  623978
  625451
  626819
  663407
  665930
  675525
  693563
  698158
  707473
  724862
  726609
  726663
  727778
  734444
  739543
  741736
  743565
  743904
  746267
  746321
  755485
  758910
  760055
  760789
  763613
  763644
  765436
  766896
  767022
  769139
  769221
  770015
  773408
  774384
  781244
  783802
  786040
  787726
  793371
  799071
  801292
  802381
  805429
  805431
  805730
  805777
  807522
  809512
  810477
  811711
  813916
  814606
  814857
  815370
  815696
  820118
  820511
  822161
  823617
  824522
  824543
  825077
  825907
  826307
  826552
]
14.34 ms
(9.99%)
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
  421215
  613470
  763613
  786040
  815370
  809512
  825077
  548499
  734444
  399668
  807522
  395166
  38261
  410352
  826307
  823617
  626819
  739543
  743904
  755485
  787726
  414315
  820511
  822161
  698158
  594782
  625451
  793371
  741736
  724862
  770015
  773408
  781244
  802381
  396396
  596449
  411744
  815696
  601619
  389618
  824522
  824543
  557347
  783802
  769139
  765436
  726609
  461628
  543592
  454208
  825907
  811711
  767022
  13646
  460621
  813916
  521764
  805777
  758910
  727778
  608049
  419220
  465409
  799071
  805730
  746267
  415734
  486535
  395685
  814857
  623978
  766896
  415542
  760055
  726663
  401307
  482186
  391472
  512217
  458343
  452869
  274930
  465340
  409179
  411776
  458438
  805429
  801292
  449358
  358398
  562181
  496709
  774384
  67464
  474872
  569445
  407786
  820118
  665930
  675525
  618858
  805431
  810477
  389351
  814606
  390041
  404582
  385427
  428853
  485362
  578291
  693563
  826552
  663407
  707473
  743565
  746321
  760789
  769221
  763644
]
2.42 ms
(1.68%)
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
  13646
  38261
  67464
  274930
  358398
  385427
  389351
  389618
  390041
  391472
  395166
  395685
  396396
  399668
  401307
  404582
  407786
  409179
  410352
  411744
  411776
  414315
  415542
  415734
  419220
  421215
  428853
  449358
  452869
  454208
  458343
  458438
  460621
  461628
  465340
  465409
  474872
  482186
  485362
  486535
  496709
  512217
  521764
  543592
  548499
  557347
  562181
  569445
  578291
  594782
  596449
  601619
  608049
  613470
  618858
  623978
  625451
  626819
  663407
  665930
  675525
  693563
  698158
  707473
  724862
  726609
  726663
  727778
  734444
  739543
  741736
  743565
  743904
  746267
  746321
  755485
  758910
  760055
  760789
  763613
  763644
  765436
  766896
  767022
  769139
  769221
  770015
  773408
  774384
  781244
  783802
  786040
  787726
  793371
  799071
  801292
  802381
  805429
  805431
  805730
  805777
  807522
  809512
  810477
  811711
  813916
  814606
  814857
  815370
  815696
  820118
  820511
  822161
  823617
  824522
  824543
  825077
  825907
  826307
  826552
]
2.11 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot mother blowjob"
]
1.83 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot мам женщин минет оральн секс"
]
1.66 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "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.