Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.99 ms
(83.14%)
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
  188335
  358466
  379600
  388700
  390212
  391087
  391380
  391490
  391588
  391614
  391652
  391668
  391989
  397845
  397856
  397871
  398933
  398969
  402897
  406648
  414319
  415342
  419523
  421377
  421834
  424449
  424479
  439621
  439643
  444100
  452963
  459070
  461717
  466088
  466212
  466224
  466884
  470215
  470565
  470953
  470962
  472346
  478421
  483632
  490952
  493172
  493185
  495562
  504509
  505287
  509267
  511375
  521133
  523847
  523852
  524778
  526456
  526528
  533659
  543532
  544181
  549847
  555086
  580356
  583909
  588916
  590621
  592548
  596653
  598018
  609669
  610033
  619096
  644974
  693441
  695598
  705479
  715898
  728247
  731084
  731565
  735338
  751585
  754581
  755147
  765257
  765717
  765951
  766482
  767073
  767973
  778235
  778259
  778282
  778643
  779069
  779750
  784700
  785811
  791045
  794782
  794941
  798799
  801800
  802132
  802139
  803255
  804930
  805736
  809356
  813556
  814985
  816184
  816611
  817508
  818760
  818924
  823817
  825557
  825907
]
24.49 ms
(12.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
  470953
  493185
  495562
  825907
  784700
  609669
  424449
  472346
  505287
  549847
  619096
  610033
  592548
  470962
  402897
  509267
  523847
  526528
  524778
  511375
  523852
  478421
  580356
  693441
  778235
  779750
  791045
  803255
  809356
  804930
  765951
  728247
  765717
  767073
  735338
  755147
  778259
  798799
  801800
  644974
  695598
  555086
  598018
  590621
  596653
  779069
  802132
  805736
  765257
  751585
  731084
  414319
  813556
  424479
  466088
  391588
  415342
  398969
  421834
  358466
  379600
  406648
  483632
  504509
  521133
  391087
  398933
  391652
  526456
  814985
  470565
  421377
  533659
  818760
  823817
  816611
  543532
  544181
  794782
  802139
  766482
  767973
  754581
  778643
  391668
  588916
  490952
  439621
  466212
  452963
  391989
  466884
  388700
  466224
  188335
  397871
  459070
  461717
  390212
  419523
  470215
  444100
  816184
  817508
  818924
  825557
  583909
  705479
  778282
  785811
  794941
  731565
  715898
  397856
  391380
  391614
  493172
  397845
  391490
  439643
]
2.79 ms
(1.40%)
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
  188335
  358466
  379600
  388700
  390212
  391087
  391380
  391490
  391588
  391614
  391652
  391668
  391989
  397845
  397856
  397871
  398933
  398969
  402897
  406648
  414319
  415342
  419523
  421377
  421834
  424449
  424479
  439621
  439643
  444100
  452963
  459070
  461717
  466088
  466212
  466224
  466884
  470215
  470565
  470953
  470962
  472346
  478421
  483632
  490952
  493172
  493185
  495562
  504509
  505287
  509267
  511375
  521133
  523847
  523852
  524778
  526456
  526528
  533659
  543532
  544181
  549847
  555086
  580356
  583909
  588916
  590621
  592548
  596653
  598018
  609669
  610033
  619096
  644974
  693441
  695598
  705479
  715898
  728247
  731084
  731565
  735338
  751585
  754581
  755147
  765257
  765717
  765951
  766482
  767073
  767973
  778235
  778259
  778282
  778643
  779069
  779750
  784700
  785811
  791045
  794782
  794941
  798799
  801800
  802132
  802139
  803255
  804930
  805736
  809356
  813556
  814985
  816184
  816611
  817508
  818760
  818924
  823817
  825557
  825907
]
1.84 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русская женщина в анал"
]
1.69 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск женщин анал"
]
1.31 ms
(0.66%)
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.