Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.38 ms
(85.03%)
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
  188242
  233018
  233353
  249873
  252068
  384422
  387359
  390206
  392675
  396758
  397054
  398936
  401952
  403323
  411336
  411383
  411393
  411694
  422299
  424423
  424435
  424439
  424481
  427668
  430936
  443170
  443692
  443728
  443794
  443962
  444127
  447494
  453855
  454222
  455409
  461481
  462937
  462947
  465332
  466114
  466890
  467427
  467547
  469857
  470156
  479145
  481466
  482386
  484615
  484857
  489048
  490884
  491362
  491442
  491981
  492676
  494238
  497536
  498921
  502347
  506223
  509742
  511161
  511565
  512646
  513501
  517999
  518844
  520864
  521865
  522305
  526726
  529246
  538213
  542640
  545769
  546622
  546917
  549772
  549775
  558020
  558213
  560613
  562288
  571452
  572489
  573621
  573633
  573678
  573720
  573861
  573956
  574832
  576073
  578367
  581145
  582583
  590348
  590404
  598033
  598910
  599139
  617211
  623831
  649094
  655704
  678696
  680682
  691407
  693331
  695790
  699197
  701266
  708237
  751618
  781743
  782246
  785932
  787552
  810157
]
16.68 ms
(8.84%)
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
  466114
  233018
  411383
  465332
  529246
  506223
  520864
  576073
  424423
  392675
  233353
  502347
  511565
  522305
  494238
  655704
  701266
  691407
  249873
  538213
  397054
  401952
  443692
  511161
  390206
  545769
  678696
  398936
  403323
  384422
  574832
  680682
  787552
  708237
  782246
  810157
  489048
  484857
  590404
  542640
  571452
  252068
  573720
  512646
  572489
  573621
  573633
  699197
  590348
  785932
  469857
  461481
  558020
  444127
  443962
  558213
  598033
  188242
  430936
  481466
  411694
  751618
  453855
  582583
  546622
  581145
  549772
  549775
  560613
  424435
  424481
  482386
  466890
  422299
  424439
  462947
  411393
  427668
  447494
  454222
  517999
  490884
  491362
  497536
  509742
  492676
  573956
  573861
  693331
  695790
  781743
  491442
  526726
  513501
  578367
  649094
  455409
  573678
  562288
  617211
  491981
  479145
  443794
  546917
  411336
  387359
  467547
  467427
  521865
  484615
  518844
  598910
  623831
  498921
  396758
  599139
  443728
  462937
  443170
  470156
]
4.22 ms
(2.24%)
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
  188242
  233018
  233353
  249873
  252068
  384422
  387359
  390206
  392675
  396758
  397054
  398936
  401952
  403323
  411336
  411383
  411393
  411694
  422299
  424423
  424435
  424439
  424481
  427668
  430936
  443170
  443692
  443728
  443794
  443962
  444127
  447494
  453855
  454222
  455409
  461481
  462937
  462947
  465332
  466114
  466890
  467427
  467547
  469857
  470156
  479145
  481466
  482386
  484615
  484857
  489048
  490884
  491362
  491442
  491981
  492676
  494238
  497536
  498921
  502347
  506223
  509742
  511161
  511565
  512646
  513501
  517999
  518844
  520864
  521865
  522305
  526726
  529246
  538213
  542640
  545769
  546622
  546917
  549772
  549775
  558020
  558213
  560613
  562288
  571452
  572489
  573621
  573633
  573678
  573720
  573861
  573956
  574832
  576073
  578367
  581145
  582583
  590348
  590404
  598033
  598910
  599139
  617211
  623831
  649094
  655704
  678696
  680682
  691407
  693331
  695790
  699197
  701266
  708237
  751618
  781743
  782246
  785932
  787552
  810157
]
2.12 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ðÁð▒ÐâÐé ÐÇÐâÐüÐüð║ÐâÐÄ ÐüÐéÐâð┤ðÁð¢ÐéðÔÔǪ"
]
1.87 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс русск студент"
]
1.51 ms
(0.80%)
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.