Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.07 ms
(85.53%)
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
  309604
  391982
  401898
  422179
  424198
  427069
  435483
  439700
  441046
  443821
  453167
  453200
  454488
  457109
  460097
  460227
  465073
  466343
  466484
  469107
  469401
  470192
  470529
  472011
  476961
  478387
  478776
  479124
  480866
  485616
  486166
  487481
  490177
  491111
  492374
  493252
  495440
  496324
  496709
  502280
  511793
  511841
  512185
  512872
  517397
  520180
  520186
  524456
  525587
  526609
  536443
  541934
  542206
  543247
  546478
  549896
  550106
  554491
  557490
  560121
  562520
  563092
  564753
  565808
  570314
  570382
  573692
  577372
  581267
  582576
  582755
  587557
  588228
  591474
  604035
  607966
  624762
  629311
  633528
  641837
  643026
  644531
  649233
  664595
  665184
  665307
  665478
  667896
  714357
  714493
  721734
  745972
  776419
  776746
  781676
  781821
  784605
  785197
  795616
  798123
  807597
  817159
  817954
  818935
  820373
  820376
  823737
  824350
  825166
  825393
  826016
  826019
  826281
  826438
  827730
  828712
  828824
  828825
]
15.68 ms
(9.12%)
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
  826438
  564753
  745972
  644531
  309604
  562520
  401898
  441046
  469401
  453200
  541934
  565808
  543247
  573692
  664595
  714357
  714493
  582576
  641837
  785197
  784605
  807597
  781676
  795616
  391982
  478387
  479124
  422179
  424198
  478776
  466343
  512872
  487481
  486166
  495440
  492374
  480866
  511841
  536443
  624762
  453167
  454488
  460097
  476961
  485616
  502280
  511793
  520186
  520180
  465073
  577372
  557490
  570382
  633528
  607966
  798123
  457109
  460227
  470192
  427069
  472011
  435483
  439700
  443821
  469107
  470529
  526609
  491111
  493252
  525587
  517397
  588228
  524456
  490177
  826019
  820373
  823737
  825393
  826016
  827730
  820376
  824282
  825166
  826281
  817159
  817954
  818935
  824009
  824350
  828825
  828824
  828712
  466484
  512185
  496709
  496324
  550106
  560121
  570314
  581267
  542206
  546478
  554491
  563092
  649233
  665307
  665184
  665478
  667896
  721734
  549896
  582755
  629311
  587557
  604035
  591474
  643026
  776419
  776746
  781821
]
2.51 ms
(1.46%)
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
  309604
  391982
  401898
  422179
  424198
  427069
  435483
  439700
  441046
  443821
  453167
  453200
  454488
  457109
  460097
  460227
  465073
  466343
  466484
  469107
  469401
  470192
  470529
  472011
  476961
  478387
  478776
  479124
  480866
  485616
  486166
  487481
  490177
  491111
  492374
  493252
  495440
  496324
  496709
  502280
  511793
  511841
  512185
  512872
  517397
  520180
  520186
  524456
  525587
  526609
  536443
  541934
  542206
  543247
  546478
  549896
  550106
  554491
  557490
  560121
  562520
  563092
  564753
  565808
  570314
  570382
  573692
  577372
  581267
  582576
  582755
  587557
  588228
  591474
  604035
  607966
  624762
  629311
  633528
  641837
  643026
  644531
  649233
  664595
  665184
  665307
  665478
  667896
  714357
  714493
  721734
  745972
  776419
  776746
  781676
  781821
  784605
  785197
  795616
  798123
  807597
  817159
  817954
  818935
  820373
  820376
  823737
  824350
  825166
  825393
  826016
  826019
  826281
  826438
  827730
  828712
  828824
  828825
]
1.86 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette saggy tits"
]
1.76 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая saggy сиськ"
]
1.41 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая saggy сиськ"
]

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.