Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.90 ms
(87.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
  95982
  311163
  389500
  390734
  395141
  395554
  397998
  400621
  404302
  407109
  407527
  407529
  407876
  411730
  411933
  411946
  416029
  421989
  422185
  426994
  428837
  429084
  432735
  432736
  439728
  439812
  443833
  443862
  451937
  453153
  453311
  455343
  462695
  464295
  465147
  465386
  465531
  466080
  466129
  469489
  475867
  477867
  477991
  479129
  479359
  480373
  481914
  482219
  482392
  483140
  483149
  485265
  485684
  490167
  490916
  491969
  492269
  493138
  496865
  496874
  499362
  501556
  502814
  504668
  505822
  508593
  511808
  513507
  514811
  515906
  517599
  517769
  517933
  518486
  531977
  544464
  558894
  561409
  563197
  563443
  573468
  589661
  591276
  591281
  603743
  606728
  610271
  628648
  634858
  641082
  651186
  663990
  665199
  667266
  667546
  667845
  696426
  721167
  726753
  740284
  742560
  746107
  755810
  758171
  771023
  780620
  780930
  782153
  788275
  789363
  800936
  803665
  807538
  807553
  810069
  815677
  815758
  816558
  816951
  820228
]
13.47 ms
(7.23%)
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
  480373
  95982
  422185
  477991
  696426
  407876
  451937
  455343
  485265
  485684
  531977
  499362
  667266
  439812
  416029
  511808
  411946
  482392
  479129
  453311
  508593
  483140
  563443
  466080
  395141
  665199
  667845
  663990
  628648
  780620
  469489
  482219
  816558
  591281
  755810
  395554
  518486
  514811
  389500
  496865
  462695
  479359
  788275
  807553
  807538
  397998
  400621
  407529
  432736
  573468
  443862
  491969
  558894
  465531
  404302
  606728
  641082
  746107
  820228
  815677
  561409
  789363
  421989
  517769
  544464
  517599
  515906
  411933
  517933
  771023
  589661
  505822
  407527
  428837
  466129
  490167
  603743
  501556
  667546
  490916
  439728
  496874
  502814
  390734
  465386
  429084
  481914
  465147
  513507
  483149
  492269
  443833
  407109
  610271
  426994
  311163
  411730
  464295
  475867
  477867
  453153
  504668
  800936
  810069
  726753
  815758
  816951
  651186
  721167
  591276
  782153
  742560
  740284
  758171
  780930
  803665
  432735
  493138
  563197
  634858
]
2.52 ms
(1.35%)
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
  95982
  311163
  389500
  390734
  395141
  395554
  397998
  400621
  404302
  407109
  407527
  407529
  407876
  411730
  411933
  411946
  416029
  421989
  422185
  426994
  428837
  429084
  432735
  432736
  439728
  439812
  443833
  443862
  451937
  453153
  453311
  455343
  462695
  464295
  465147
  465386
  465531
  466080
  466129
  469489
  475867
  477867
  477991
  479129
  479359
  480373
  481914
  482219
  482392
  483140
  483149
  485265
  485684
  490167
  490916
  491969
  492269
  493138
  496865
  496874
  499362
  501556
  502814
  504668
  505822
  508593
  511808
  513507
  514811
  515906
  517599
  517769
  517933
  518486
  531977
  544464
  558894
  561409
  563197
  563443
  573468
  589661
  591276
  591281
  603743
  606728
  610271
  628648
  634858
  641082
  651186
  663990
  665199
  667266
  667546
  667845
  696426
  721167
  726753
  740284
  742560
  746107
  755810
  758171
  771023
  780620
  780930
  782153
  788275
  789363
  800936
  803665
  807538
  807553
  810069
  815677
  815758
  816558
  816951
  820228
]
2.02 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ðÀÐÇðÁð╗ð░ÐÅ ð© ð┐ð░ÐÇðÁð¢Ðî ð▓ ð┤ÐâÐêð%ÔǪ"
]
1.50 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин парен ван"
]
1.48 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.74%)
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.