Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.49 ms
(86.94%)
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
  73622
  104130
  358449
  390112
  394598
  396932
  401807
  406339
  413746
  419619
  419655
  424129
  428138
  432532
  439052
  443117
  443744
  456311
  456466
  456591
  457089
  463382
  465763
  468707
  470170
  470422
  472746
  474956
  476183
  478168
  481105
  490278
  490406
  498702
  508276
  508750
  510071
  512901
  514258
  518412
  521559
  526291
  528606
  531212
  533783
  536286
  549836
  559737
  571229
  572326
  590695
  590707
  592174
  592961
  597948
  600317
  603328
  612079
  632564
  633472
  633518
  633814
  634106
  643121
  644498
  647996
  649964
  659315
  668437
  689693
  694010
  695125
  702627
  709240
  710946
  712053
  712278
  717859
  720273
  720743
  722482
  726638
  732917
  734493
  744061
  744842
  745136
  748690
  748951
  750608
  750691
  752566
  752668
  755630
  759849
  760007
  760934
  761583
  764116
  766605
  768032
  770213
  775191
  775269
  783205
  785591
  785606
  787438
  789840
  793497
  798881
  800608
  804651
  805242
  814037
  815013
  815270
  816687
  819613
]
12.60 ms
(7.53%)
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
  536286
  514258
  521559
  571229
  647996
  695125
  549836
  572326
  597948
  785591
  732917
  748951
  766605
  770213
  745136
  760007
  712278
  722482
  783205
  419655
  424129
  443117
  472746
  465763
  73622
  432532
  456591
  463382
  481105
  390112
  394598
  428138
  456466
  474956
  526291
  528606
  490278
  490406
  498702
  508276
  512901
  510071
  104130
  815013
  533783
  531212
  592961
  590695
  789840
  761583
  633814
  457089
  478168
  826362
  592174
  603328
  419619
  600317
  413746
  816687
  819613
  815270
  814037
  470422
  476183
  468707
  508750
  559737
  649964
  668437
  689693
  659315
  694010
  717859
  720743
  710946
  712053
  720273
  590707
  634106
  612079
  643121
  793497
  804651
  805242
  787438
  798881
  800608
  748690
  785606
  734493
  750608
  755630
  759849
  752566
  764116
  726638
  744061
  744842
  750691
  768032
  633472
  633518
  644498
  702627
  709240
  775191
  775269
  358449
  406339
  470170
  456311
  518412
  396932
  752668
  760934
  632564
  401807
  443744
  439052
]
2.24 ms
(1.34%)
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
  73622
  104130
  358449
  390112
  394598
  396932
  401807
  406339
  413746
  419619
  419655
  424129
  428138
  432532
  439052
  443117
  443744
  456311
  456466
  456591
  457089
  463382
  465763
  468707
  470170
  470422
  472746
  474956
  476183
  478168
  481105
  490278
  490406
  498702
  508276
  508750
  510071
  512901
  514258
  518412
  521559
  526291
  528606
  531212
  533783
  536286
  549836
  559737
  571229
  572326
  590695
  590707
  592174
  592961
  597948
  600317
  603328
  612079
  632564
  633472
  633518
  633814
  634106
  643121
  644498
  647996
  649964
  659315
  668437
  689693
  694010
  695125
  702627
  709240
  710946
  712053
  712278
  717859
  720273
  720743
  722482
  726638
  732917
  734493
  744061
  744842
  745136
  748690
  748951
  750608
  750691
  752566
  752668
  755630
  759849
  760007
  760934
  761583
  764116
  766605
  768032
  770213
  775191
  775269
  783205
  785591
  785606
  787438
  789840
  793497
  798881
  800608
  804651
  805242
  814037
  815013
  815270
  816687
  819613
]
2.07 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pantyhose anal"
]
1.78 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pantyhose анал"
]
1.68 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pantyhose анал"
]

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.