Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.49 ms
(87.42%)
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
  416857
  420903
  424147
  429550
  440532
  443727
  446739
  448674
  454398
  456448
  456915
  458394
  462711
  466943
  469766
  472787
  477185
  477460
  483401
  487534
  492108
  493268
  494857
  499984
  501901
  504686
  504756
  506702
  509052
  511543
  512558
  513775
  517631
  518499
  522768
  523251
  523537
  525277
  525343
  528682
  529381
  530065
  537481
  543507
  545057
  545187
  562014
  562015
  562409
  565526
  566187
  568185
  569077
  569978
  572263
  574975
  575687
  575693
  577210
  577213
  578433
  578571
  581998
  582572
  585307
  588018
  588128
  589598
  590975
  593815
  593860
  599525
  607343
  607391
  607412
  609531
  610805
  610819
  612387
  613873
  615322
  617434
  622785
  648657
  650847
  654224
  661955
  666008
  717167
  718376
  718885
  719350
  720350
  723986
  724305
  731323
  732266
  732697
  732743
  733050
  742662
  742663
  751026
  755011
  757638
  771795
  773946
  788209
  791943
  794166
  794622
  802104
  803708
  808654
  809880
  810902
  812448
  814790
  824996
]
13.57 ms
(7.00%)
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
  732266
  771795
  607412
  615322
  454398
  446739
  462711
  522768
  578433
  617434
  477460
  523251
  569077
  574975
  577213
  588018
  607391
  812448
  803708
  742662
  794166
  808654
  424147
  504686
  609531
  440532
  458394
  466943
  494857
  593860
  523537
  518499
  545187
  566187
  802104
  757638
  416857
  469766
  528682
  593815
  448674
  810902
  456915
  568185
  575693
  666008
  650847
  742663
  499984
  575687
  562015
  543507
  675594
  717167
  720350
  654224
  562409
  578571
  581998
  588128
  794622
  590975
  443727
  501901
  814790
  493268
  529381
  569978
  513775
  477185
  483401
  506702
  511543
  719350
  809880
  429550
  420903
  504756
  622785
  791943
  565526
  492108
  530065
  517631
  509052
  537481
  572263
  589598
  788209
  512558
  472787
  610819
  732743
  610805
  724305
  599525
  607343
  733050
  824996
  487534
  582572
  545057
  661955
  731323
  723986
  732697
  456448
  525277
  525343
  562014
  577210
  648657
  718376
  612387
  613873
  585307
  751026
  773946
  755011
  718885
]
4.30 ms
(2.22%)
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
  416857
  420903
  424147
  429550
  440532
  443727
  446739
  448674
  454398
  456448
  456915
  458394
  462711
  466943
  469766
  472787
  477185
  477460
  483401
  487534
  492108
  493268
  494857
  499984
  501901
  504686
  504756
  506702
  509052
  511543
  512558
  513775
  517631
  518499
  522768
  523251
  523537
  525277
  525343
  528682
  529381
  530065
  537481
  543507
  545057
  545187
  562014
  562015
  562409
  565526
  566187
  568185
  569077
  569978
  572263
  574975
  575687
  575693
  577210
  577213
  578433
  578571
  581998
  582572
  585307
  588018
  588128
  589598
  590975
  593815
  593860
  599525
  607343
  607391
  607412
  609531
  610805
  610819
  612387
  613873
  615322
  617434
  622785
  648657
  650847
  654224
  661955
  666008
  717167
  718376
  718885
  719350
  720350
  723986
  724305
  731323
  732266
  732697
  732743
  733050
  742662
  742663
  751026
  755011
  757638
  771795
  773946
  788209
  791943
  794166
  794622
  802104
  803708
  808654
  809880
  810902
  812448
  814790
  824996
]
1.77 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck friend mother"
]
1.72 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс friend мам женщин"
]
1.61 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс friend мам женщин"
]
1.44 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.