Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.99 ms
(84.46%)
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
  382014
  385645
  391977
  401177
  416751
  417246
  417389
  418697
  419822
  427539
  436230
  439020
  439158
  440094
  441073
  443496
  447160
  450679
  454039
  454814
  454983
  469437
  471330
  474044
  474848
  475646
  475947
  493398
  493679
  500787
  510822
  513746
  515490
  524802
  527871
  529617
  543930
  544108
  547778
  547805
  548836
  554091
  554385
  557828
  563687
  564104
  564303
  568031
  568292
  573207
  576221
  579432
  586375
  587987
  588379
  598310
  600358
  601189
  605725
  606081
  606402
  616296
  618238
  619670
  619699
  622658
  623171
  627146
  631245
  633134
  634044
  634741
  634902
  641571
  642134
  642957
  647839
  666045
  666876
  670783
  672780
  697236
  708131
  711699
  713440
  716960
  720635
  728388
  730343
  731821
  734554
  734828
  740636
  742293
  746187
  747404
  747981
  752645
  753187
  761354
  767474
  775653
  776094
  782789
  783355
  783414
  784133
  786880
  786920
  787816
  788531
  792715
  793534
  793839
  794871
  796939
  802365
  803311
  804351
  808448
]
16.12 ms
(9.59%)
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
  708131
  618238
  634902
  642134
  586375
  601189
  641571
  642957
  775653
  787816
  803311
  776094
  788531
  802365
  742293
  753187
  767474
  783355
  783414
  786880
  786920
  808448
  731821
  746187
  734828
  740636
  747981
  761354
  622658
  634741
  697236
  713440
  716960
  720635
  794871
  804351
  391977
  792715
  573207
  385645
  554091
  670783
  784133
  543930
  568031
  564104
  634044
  418697
  447160
  515490
  547805
  631245
  416751
  605725
  619699
  474848
  439020
  471330
  439158
  527871
  493398
  752645
  510822
  557828
  563687
  619670
  606402
  401177
  454039
  666045
  734554
  730343
  672780
  711699
  747404
  524802
  579432
  554385
  475646
  588379
  576221
  587987
  454814
  793839
  382014
  417389
  441073
  427539
  417246
  443496
  493679
  450679
  529617
  500787
  544108
  547778
  548836
  606081
  598310
  600358
  616296
  623171
  633134
  782789
  793534
  475947
  419822
  474044
  440094
  513746
  568292
  469437
  647839
  796939
  454983
  564303
  627146
  666876
  436230
  728388
]
3.10 ms
(1.85%)
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
  382014
  385645
  391977
  401177
  416751
  417246
  417389
  418697
  419822
  427539
  436230
  439020
  439158
  440094
  441073
  443496
  447160
  450679
  454039
  454814
  454983
  469437
  471330
  474044
  474848
  475646
  475947
  493398
  493679
  500787
  510822
  513746
  515490
  524802
  527871
  529617
  543930
  544108
  547778
  547805
  548836
  554091
  554385
  557828
  563687
  564104
  564303
  568031
  568292
  573207
  576221
  579432
  586375
  587987
  588379
  598310
  600358
  601189
  605725
  606081
  606402
  616296
  618238
  619670
  619699
  622658
  623171
  627146
  631245
  633134
  634044
  634741
  634902
  641571
  642134
  642957
  647839
  666045
  666876
  670783
  672780
  697236
  708131
  711699
  713440
  716960
  720635
  728388
  730343
  731821
  734554
  734828
  740636
  742293
  746187
  747404
  747981
  752645
  753187
  761354
  767474
  775653
  776094
  782789
  783355
  783414
  784133
  786880
  786920
  787816
  788531
  792715
  793534
  793839
  794871
  796939
  802365
  803311
  804351
  808448
]
2.09 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gape vagina"
]
1.68 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие дырк вагин"
]
1.64 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.88%)
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.