Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.55 ms
(51.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни в офисе"
]
171.04 ms
(42.29%)
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
  12792
  366052
  383188
  391359
  397902
  416965
  422802
  422815
  425178
  428531
  428664
  430876
  431015
  434838
  441251
  448818
  451483
  451524
  460976
  462424
  463021
  465390
  466319
  467139
  467185
  467218
  471713
  472511
  472626
  474104
  479136
  480787
  483118
  484984
  485147
  485346
  486492
  490872
  490876
  490942
  491837
  491901
  491907
  499816
  500720
  506845
  511325
  512172
  512494
  513436
  515061
  517565
  519089
  519683
  520052
  520660
  521154
  521168
  524845
  526877
  530345
  532983
  533388
  534309
  541074
  541637
  544523
  544525
  544529
  545676
  553291
  554573
  558305
  559601
  560638
  563191
  563513
  563521
  565452
  566075
  572767
  572838
  575050
  580073
  580280
  580424
  581260
  586469
  588375
  590518
  592413
  592590
  594906
  600826
  601265
  606608
  607202
  607466
  608815
  619466
  623732
  640521
  645949
  682618
  696308
  704557
  712723
  719067
  719099
  744311
  753257
  790501
  798614
  802117
  802277
  808527
  814798
  815148
  815252
  820173
]
16.06 ms
(3.97%)
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
  513436
  575050
  704557
  608815
  790501
  448818
  485346
  512172
  815148
  486492
  519089
  530345
  506845
  471713
  491901
  559601
  541637
  544523
  719099
  640521
  422815
  479136
  466319
  491907
  383188
  580073
  712723
  601265
  366052
  560638
  554573
  607466
  397902
  524845
  485147
  472626
  428531
  594906
  533388
  753257
  491837
  607202
  565452
  391359
  499816
  467139
  814798
  534309
  719067
  586469
  798614
  588375
  428664
  520052
  441251
  517565
  500720
  544525
  553291
  645949
  580424
  563513
  520660
  451483
  12792
  572838
  600826
  416965
  462424
  619466
  682618
  590518
  802117
  465390
  815252
  467185
  581260
  563521
  802277
  422802
  521168
  545676
  592590
  515061
  521154
  572767
  808527
  474104
  480787
  463021
  526877
  490942
  467218
  460976
  519683
  434838
  512494
  511325
  696308
  563191
  606608
  592413
  430876
  490872
  490876
  472511
  566075
  451524
  484984
  431015
  623732
  544529
  425178
  532983
  541074
  820173
  483118
  580280
  744311
  558305
]
3.43 ms
(0.85%)
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
  12792
  366052
  383188
  391359
  397902
  416965
  422802
  422815
  425178
  428531
  428664
  430876
  431015
  434838
  441251
  448818
  451483
  451524
  460976
  462424
  463021
  465390
  466319
  467139
  467185
  467218
  471713
  472511
  472626
  474104
  479136
  480787
  483118
  484984
  485147
  485346
  486492
  490872
  490876
  490942
  491837
  491901
  491907
  499816
  500720
  506845
  511325
  512172
  512494
  513436
  515061
  517565
  519089
  519683
  520052
  520660
  521154
  521168
  524845
  526877
  530345
  532983
  533388
  534309
  541074
  541637
  544523
  544525
  544529
  545676
  553291
  554573
  558305
  559601
  560638
  563191
  563513
  563521
  565452
  566075
  572767
  572838
  575050
  580073
  580280
  580424
  581260
  586469
  588375
  590518
  592413
  592590
  594906
  600826
  601265
  606608
  607202
  607466
  608815
  619466
  623732
  640521
  645949
  682618
  696308
  704557
  712723
  719067
  719099
  744311
  753257
  790501
  798614
  802117
  802277
  808527
  814798
  815148
  815252
  820173
]
1.95 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс секретарш"
]
1.54 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.