Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.25 ms
(85.81%)
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
  12731
  13166
  28382
  35405
  97763
  257963
  364606
  373416
  384223
  388757
  390293
  390299
  395407
  396280
  396800
  397424
  398697
  399195
  400747
  400956
  402219
  402789
  403285
  404193
  405551
  405825
  411291
  411507
  411962
  414361
  415298
  417708
  417731
  421586
  426376
  429264
  429273
  429280
  429554
  430298
  434089
  434992
  443930
  446370
  451724
  451756
  453120
  453874
  455745
  457381
  457796
  458573
  461002
  462575
  462752
  463120
  467280
  469418
  470250
  472795
  474053
  475106
  476388
  477649
  478261
  479397
  485903
  487046
  488926
  490699
  494750
  496571
  497458
  497466
  500652
  501876
  504613
  504790
  506177
  512464
  514198
  518973
  521942
  523282
  524728
  525660
  530687
  549747
  551193
  552072
  564422
  565378
  570016
  570037
  570432
  570447
  570500
  570584
  570617
  570667
  571557
  571571
  571931
  572075
  572083
  572154
  572155
  572159
  572402
  573008
  573621
  573897
  576306
  585109
  588070
  634127
  654695
  758989
  770885
  780060
]
15.98 ms
(9.07%)
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
  530687
  476388
  402789
  403285
  457796
  770885
  35405
  458573
  405551
  451724
  457381
  758989
  417731
  390293
  429273
  588070
  512464
  398697
  426376
  479397
  518973
  490699
  429554
  12731
  396800
  373416
  654695
  506177
  364606
  400747
  415298
  453120
  570016
  477649
  434992
  501876
  28382
  443930
  570037
  504613
  524728
  397424
  576306
  451756
  395407
  525660
  572075
  404193
  411507
  585109
  399195
  551193
  390299
  402219
  405825
  469418
  497458
  496571
  463120
  467280
  552072
  573008
  429280
  421586
  411962
  430298
  461002
  488926
  494750
  549747
  571557
  573621
  570432
  573897
  780060
  257963
  429264
  487046
  523282
  497466
  485903
  462575
  475106
  500652
  570617
  571571
  572083
  472795
  455745
  388757
  514198
  97763
  411291
  446370
  400956
  521942
  434089
  453874
  570500
  570447
  572155
  564422
  571931
  572154
  634127
  462752
  396280
  470250
  384223
  414361
  13166
  417708
  478261
  504790
  474053
  565378
  572159
  570667
  572402
  570584
]
2.56 ms
(1.45%)
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
  12731
  13166
  28382
  35405
  97763
  257963
  364606
  373416
  384223
  388757
  390293
  390299
  395407
  396280
  396800
  397424
  398697
  399195
  400747
  400956
  402219
  402789
  403285
  404193
  405551
  405825
  411291
  411507
  411962
  414361
  415298
  417708
  417731
  421586
  426376
  429264
  429273
  429280
  429554
  430298
  434089
  434992
  443930
  446370
  451724
  451756
  453120
  453874
  455745
  457381
  457796
  458573
  461002
  462575
  462752
  463120
  467280
  469418
  470250
  472795
  474053
  475106
  476388
  477649
  478261
  479397
  485903
  487046
  488926
  490699
  494750
  496571
  497458
  497466
  500652
  501876
  504613
  504790
  506177
  512464
  514198
  518973
  521942
  523282
  524728
  525660
  530687
  549747
  551193
  552072
  564422
  565378
  570016
  570037
  570432
  570447
  570500
  570584
  570617
  570667
  571557
  571571
  571931
  572075
  572083
  572154
  572155
  572159
  572402
  573008
  573621
  573897
  576306
  585109
  588070
  634127
  654695
  758989
  770885
  780060
]
2.12 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трахаю знакомую"
]
1.51 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс знаком"
]
1.48 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.76%)
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.