Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.17 ms
(87.07%)
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
  16851
  198609
  385285
  413070
  418225
  420717
  421740
  421814
  421882
  424237
  424259
  427543
  428059
  428702
  429880
  432538
  432611
  432639
  433686
  438446
  439645
  439731
  439743
  439793
  440440
  440490
  440593
  440822
  440876
  442469
  443210
  447917
  448953
  454468
  455987
  456328
  457418
  457680
  460924
  461294
  461406
  462226
  462253
  463468
  464116
  464226
  464987
  465361
  466762
  469177
  470400
  475568
  475872
  477797
  478385
  480899
  486854
  488535
  488556
  492758
  493528
  493568
  495088
  495224
  498112
  503083
  504875
  511855
  513538
  513694
  513725
  516171
  516780
  518004
  520811
  523113
  526663
  528535
  534119
  535454
  552837
  553972
  558220
  558622
  563646
  565863
  570876
  571762
  576548
  577051
  585400
  588684
  588992
  590288
  590783
  603834
  609164
  612404
  612601
  616864
  626385
  629428
  647105
  660110
  701654
  709524
  727024
  735902
  737925
  745960
  758572
  761758
  762383
  765701
  767782
  788606
  789440
  796203
  802012
  809307
]
15.86 ms
(8.07%)
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
  558220
  469177
  480899
  420717
  475872
  470400
  576548
  761758
  765701
  788606
  737925
  762383
  486854
  447917
  432611
  428702
  488535
  413070
  493528
  609164
  198609
  571762
  585400
  603834
  809307
  727024
  758572
  745960
  802012
  498112
  440593
  442469
  565863
  438446
  518004
  520811
  626385
  464226
  385285
  796203
  421882
  440876
  558622
  495224
  429880
  457418
  528535
  629428
  789440
  767782
  421740
  462226
  735902
  461294
  432538
  455987
  516171
  552837
  464987
  493568
  570876
  443210
  463468
  513725
  523113
  457680
  616864
  418225
  440490
  462253
  464116
  433686
  461406
  475568
  503083
  504875
  466762
  456328
  516780
  488556
  577051
  424237
  535454
  427543
  709524
  513694
  477797
  590783
  432639
  440822
  424259
  439793
  590288
  511855
  612404
  492758
  660110
  454468
  495088
  563646
  534119
  612601
  647105
  701654
  553972
  588684
  440440
  16851
  513538
  526663
  478385
  588992
  439743
  448953
  439731
  465361
  439645
  460924
  428059
  421814
]
2.57 ms
(1.31%)
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
  16851
  198609
  385285
  413070
  418225
  420717
  421740
  421814
  421882
  424237
  424259
  427543
  428059
  428702
  429880
  432538
  432611
  432639
  433686
  438446
  439645
  439731
  439743
  439793
  440440
  440490
  440593
  440822
  440876
  442469
  443210
  447917
  448953
  454468
  455987
  456328
  457418
  457680
  460924
  461294
  461406
  462226
  462253
  463468
  464116
  464226
  464987
  465361
  466762
  469177
  470400
  475568
  475872
  477797
  478385
  480899
  486854
  488535
  488556
  492758
  493528
  493568
  495088
  495224
  498112
  503083
  504875
  511855
  513538
  513694
  513725
  516171
  516780
  518004
  520811
  523113
  526663
  528535
  534119
  535454
  552837
  553972
  558220
  558622
  563646
  565863
  570876
  571762
  576548
  577051
  585400
  588684
  588992
  590288
  590783
  603834
  609164
  612404
  612601
  616864
  626385
  629428
  647105
  660110
  701654
  709524
  727024
  735902
  737925
  745960
  758572
  761758
  762383
  765701
  767782
  788606
  789440
  796203
  802012
  809307
]
2.06 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамки в белье домашнее"
]
1.78 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин в бел домашн любительск"
]
1.50 ms
(0.76%)
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.