Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.53 ms
(77.22%)
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
  187353
  382971
  386142
  388712
  391655
  391668
  391915
  391950
  395137
  395714
  395719
  397361
  397850
  397863
  397881
  400807
  400808
  400813
  401229
  401307
  411322
  411736
  413524
  420886
  421849
  421939
  421995
  422188
  439521
  439591
  439643
  440469
  440906
  444000
  451473
  454890
  460607
  464649
  464936
  465075
  465312
  465902
  465952
  465955
  466063
  466198
  466221
  466272
  468043
  470275
  472148
  474635
  474652
  483149
  484678
  484705
  484739
  485267
  486253
  490904
  493224
  494516
  505813
  506529
  509554
  513149
  517012
  520681
  522611
  531070
  534241
  534285
  534303
  534680
  539951
  541055
  546947
  546958
  549247
  550381
  567337
  589681
  590503
  592462
  596488
  604018
  618780
  624468
  627338
  638557
  671229
  674681
  688071
  696426
  697203
  697758
  710412
  718496
  720627
  725403
  728035
  751457
  775962
  782626
  789986
  790882
  791268
  792619
  796079
  797468
  799146
  801318
  807340
  810294
  815617
  815865
  815959
  817877
  818206
  820327
]
27.92 ms
(16.91%)
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
  513149
  440469
  440906
  627338
  789986
  421939
  391915
  810294
  391950
  671229
  725403
  801318
  791268
  697203
  395719
  388712
  775962
  728035
  751457
  421995
  483149
  484739
  485267
  534680
  505813
  509554
  539951
  466221
  541055
  546947
  688071
  567337
  624468
  589681
  604018
  618780
  439521
  391668
  400807
  465955
  472148
  474652
  400808
  401229
  439591
  454890
  465075
  493224
  484705
  486253
  494516
  520681
  386142
  382971
  395137
  397863
  411736
  460607
  464649
  517012
  534285
  534303
  464936
  549247
  720627
  674681
  590503
  807340
  796079
  797468
  391655
  439643
  444000
  474635
  397850
  470275
  451473
  465312
  465952
  466063
  466272
  531070
  490904
  484678
  815959
  397361
  397881
  522611
  506529
  550381
  546958
  799146
  792619
  413524
  395714
  421849
  465902
  400813
  401307
  411322
  422188
  420886
  466198
  187353
  815617
  817877
  820327
  815865
  818206
  468043
  534241
  696426
  697758
  710412
  718496
  638557
  592462
  596488
  782626
  790882
]
3.14 ms
(1.90%)
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
  187353
  382971
  386142
  388712
  391655
  391668
  391915
  391950
  395137
  395714
  395719
  397361
  397850
  397863
  397881
  400807
  400808
  400813
  401229
  401307
  411322
  411736
  413524
  420886
  421849
  421939
  421995
  422188
  439521
  439591
  439643
  440469
  440906
  444000
  451473
  454890
  460607
  464649
  464936
  465075
  465312
  465902
  465952
  465955
  466063
  466198
  466221
  466272
  468043
  470275
  472148
  474635
  474652
  483149
  484678
  484705
  484739
  485267
  486253
  490904
  493224
  494516
  505813
  506529
  509554
  513149
  517012
  520681
  522611
  531070
  534241
  534285
  534303
  534680
  539951
  541055
  546947
  546958
  549247
  550381
  567337
  589681
  590503
  592462
  596488
  604018
  618780
  624468
  627338
  638557
  671229
  674681
  688071
  696426
  697203
  697758
  710412
  718496
  720627
  725403
  728035
  751457
  775962
  782626
  789986
  790882
  791268
  792619
  796079
  797468
  799146
  801318
  807340
  810294
  815617
  815865
  815959
  817877
  818206
  820327
]
1.93 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature young anal"
]
1.66 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature young анал"
]
1.53 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature young анал"
]

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.