Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.40 ms
(85.77%)
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
  396572
  396581
  402013
  405508
  407223
  409484
  411841
  418400
  446333
  456048
  459229
  468791
  470131
  476739
  478665
  485556
  487191
  488085
  488088
  516206
  520477
  528024
  529204
  533960
  536242
  543260
  547663
  552398
  553109
  555508
  557562
  561392
  564528
  565054
  565932
  570718
  572028
  573874
  574097
  575830
  576329
  577976
  579281
  580713
  581092
  581825
  586692
  589950
  590078
  592062
  595150
  596131
  597700
  601332
  603955
  604222
  604425
  605941
  606152
  623330
  633085
  636279
  639459
  643233
  648150
  649903
  654026
  660351
  660732
  662162
  662436
  671296
  671396
  671523
  672588
  675049
  676776
  679297
  683663
  690154
  693182
  698282
  712803
  719934
  720803
  722529
  728730
  731869
  742224
  744291
  744652
  744846
  745075
  747690
  748129
  748660
  755630
  758554
  758876
  759541
  762646
  765357
  776196
  776219
  782089
  786720
  791975
  803097
  805675
  807945
  808909
  809718
  811507
  812109
  812876
  819597
  820766
  821463
  823480
  825693
]
16.15 ms
(8.48%)
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
  698282
  803097
  396572
  405508
  459229
  516206
  529204
  488088
  555508
  821463
  478665
  476739
  488085
  605941
  633085
  487191
  786720
  520477
  418400
  543260
  552398
  623330
  812876
  731869
  762646
  805675
  485556
  528024
  581825
  411841
  407223
  396581
  402013
  409484
  819597
  825693
  820766
  823480
  446333
  456048
  468791
  470131
  533960
  536242
  565932
  572028
  574097
  564528
  565054
  570718
  575830
  547663
  553109
  561392
  576329
  577976
  579281
  580713
  581092
  649903
  654026
  660351
  662162
  662436
  671523
  675049
  683663
  690154
  693182
  712803
  719934
  648150
  660732
  671396
  672588
  676776
  679297
  722529
  671296
  720803
  557562
  573874
  589950
  590078
  592062
  606152
  595150
  596131
  603955
  604222
  604425
  639459
  643233
  586692
  597700
  601332
  636279
  782089
  791975
  811507
  776196
  776219
  807945
  809718
  758554
  758876
  808909
  812109
  744846
  748129
  755630
  742224
  744291
  747690
  748660
  759541
  765357
  728730
  744652
  745075
]
3.55 ms
(1.86%)
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
  396572
  396581
  402013
  405508
  407223
  409484
  411841
  418400
  446333
  456048
  459229
  468791
  470131
  476739
  478665
  485556
  487191
  488085
  488088
  516206
  520477
  528024
  529204
  533960
  536242
  543260
  547663
  552398
  553109
  555508
  557562
  561392
  564528
  565054
  565932
  570718
  572028
  573874
  574097
  575830
  576329
  577976
  579281
  580713
  581092
  581825
  586692
  589950
  590078
  592062
  595150
  596131
  597700
  601332
  603955
  604222
  604425
  605941
  606152
  623330
  633085
  636279
  639459
  643233
  648150
  649903
  654026
  660351
  660732
  662162
  662436
  671296
  671396
  671523
  672588
  675049
  676776
  679297
  683663
  690154
  693182
  698282
  712803
  719934
  720803
  722529
  728730
  731869
  742224
  744291
  744652
  744846
  745075
  747690
  748129
  748660
  755630
  758554
  758876
  759541
  762646
  765357
  776196
  776219
  782089
  786720
  791975
  803097
  805675
  807945
  808909
  809718
  811507
  812109
  812876
  819597
  820766
  821463
  823480
  825693
]
2.15 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "petite big cock"
]
1.89 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "petite большие cock"
]
1.74 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "petite большие cock"
]

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.