Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.86 ms
(85.45%)
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
  72802
  145502
  382549
  383171
  386545
  395661
  411628
  426719
  446821
  453145
  464339
  465834
  465949
  466893
  474076
  474784
  475867
  476287
  477955
  477961
  481820
  484768
  485216
  485978
  487315
  494849
  504101
  519268
  520916
  521207
  523051
  524389
  531960
  532270
  534244
  534636
  535365
  535508
  544504
  544573
  544587
  546121
  560397
  561333
  562534
  562590
  562961
  563001
  566800
  570795
  570803
  573918
  576622
  576702
  579902
  591288
  603190
  614514
  617677
  624469
  645826
  645937
  659079
  663982
  665102
  673649
  681126
  682206
  684106
  695618
  696599
  699708
  699728
  715443
  716787
  718560
  719175
  720099
  726144
  726289
  726476
  726492
  727339
  727395
  727697
  727837
  727935
  728481
  733416
  739585
  741047
  744352
  756021
  756057
  770161
  770909
  772327
  776584
  781486
  782213
  789599
  794640
  797309
  800234
  801592
  801617
  801884
  804128
  804170
  804216
  805012
  813777
  816261
  816802
  817165
  820142
  820375
  820683
  820732
  827421
]
14.12 ms
(8.81%)
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
  494849
  521207
  531960
  566800
  544573
  544587
  562590
  570795
  682206
  696599
  715443
  645826
  659079
  684106
  695618
  699728
  681126
  579902
  603190
  624469
  617677
  776584
  789599
  801592
  805012
  781486
  782213
  801617
  801884
  804216
  726289
  727395
  800234
  727339
  727697
  756057
  728481
  699708
  719175
  804128
  804170
  576622
  466893
  465949
  426719
  645937
  145502
  382549
  524389
  487315
  475867
  673649
  726144
  727935
  485978
  827421
  820142
  820375
  820732
  794640
  744352
  739585
  770161
  797309
  820683
  464339
  534636
  563001
  573918
  665102
  716787
  576702
  395661
  477955
  477961
  465834
  481820
  484768
  519268
  520916
  534244
  411628
  816261
  446821
  453145
  476287
  532270
  544504
  546121
  562534
  720099
  663982
  591288
  614514
  772327
  523051
  474784
  562961
  386545
  72802
  535508
  504101
  535365
  560397
  561333
  741047
  726476
  726492
  770909
  756021
  727837
  733416
  485216
  570803
  718560
  474076
  383171
  816802
  817165
  813777
]
3.18 ms
(1.98%)
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
  72802
  145502
  382549
  383171
  386545
  395661
  411628
  426719
  446821
  453145
  464339
  465834
  465949
  466893
  474076
  474784
  475867
  476287
  477955
  477961
  481820
  484768
  485216
  485978
  487315
  494849
  504101
  519268
  520916
  521207
  523051
  524389
  531960
  532270
  534244
  534636
  535365
  535508
  544504
  544573
  544587
  546121
  560397
  561333
  562534
  562590
  562961
  563001
  566800
  570795
  570803
  573918
  576622
  576702
  579902
  591288
  603190
  614514
  617677
  624469
  645826
  645937
  659079
  663982
  665102
  673649
  681126
  682206
  684106
  695618
  696599
  699708
  699728
  715443
  716787
  718560
  719175
  720099
  726144
  726289
  726476
  726492
  727339
  727395
  727697
  727837
  727935
  728481
  733416
  739585
  741047
  744352
  756021
  756057
  770161
  770909
  772327
  776584
  781486
  782213
  789599
  794640
  797309
  800234
  801592
  801617
  801884
  804128
  804170
  804216
  805012
  813777
  816261
  816802
  817165
  820142
  820375
  820683
  820732
  827421
]
1.87 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kissing mature woman"
]
1.44 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kissing зрелая женщин"
]
1.43 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kissing зрелая женщин"
]
1.26 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.