Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.75 ms
(80.86%)
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
  88174
  88942
  89347
  181926
  182033
  182118
  182206
  182227
  182352
  182526
  183074
  275727
  357499
  381812
  382041
  382281
  382298
  382390
  385955
  386028
  386232
  386325
  387293
  388183
  392421
  398078
  401767
  402634
  410242
  410702
  413446
  414048
  414064
  414090
  414241
  414662
  415294
  415857
  416711
  418112
  418117
  418139
  418146
  419439
  420394
  422101
  423651
  423662
  429596
  429602
  430347
  434314
  434315
  434326
  434336
  434338
  434339
  434344
  435403
  439125
  439171
  439931
  443240
  443243
  443276
  449022
  449023
  457816
  460813
  462231
  470428
  476662
  476704
  482293
  483741
  486778
  493258
  493839
  500897
  518191
  522169
  522171
  524066
  526473
  550887
  582579
  588717
  599502
  613530
  623284
  666475
  701303
  705454
  713332
  728039
  736872
  736990
  738486
  738506
  746131
  755942
  756138
  761632
  776059
  782462
  791165
  791890
  791922
  791928
  792146
  800522
  800540
  800542
  800698
  800733
  805548
  807009
  808331
  808842
  827619
]
17.83 ms
(11.94%)
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
  807009
  800542
  761632
  800733
  182526
  457816
  483741
  88942
  385955
  392421
  401767
  430347
  413446
  418146
  414662
  416711
  423651
  434326
  410702
  420394
  500897
  524066
  582579
  599502
  588717
  808842
  738506
  713332
  800522
  800698
  443276
  357499
  418117
  434315
  462231
  386028
  388183
  422101
  434344
  435403
  522171
  182227
  746131
  382281
  386232
  381812
  387293
  402634
  414090
  429602
  434339
  434314
  449022
  470428
  522169
  666475
  623284
  808331
  439125
  183074
  460813
  526473
  382041
  827619
  791922
  736990
  182206
  182118
  418112
  434336
  439171
  414064
  418139
  414048
  423662
  429596
  449023
  550887
  613530
  776059
  410242
  482293
  415294
  415857
  434338
  443240
  493258
  493839
  182033
  275727
  382390
  476662
  791890
  792146
  791165
  805548
  89347
  414241
  181926
  382298
  88174
  398078
  486778
  476704
  701303
  791928
  800540
  755942
  756138
  782462
  728039
  736872
  738486
  705454
  182352
  386325
  443243
  419439
  439931
  518191
]
3.28 ms
(2.20%)
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
  88174
  88942
  89347
  181926
  182033
  182118
  182206
  182227
  182352
  182526
  183074
  275727
  357499
  381812
  382041
  382281
  382298
  382390
  385955
  386028
  386232
  386325
  387293
  388183
  392421
  398078
  401767
  402634
  410242
  410702
  413446
  414048
  414064
  414090
  414241
  414662
  415294
  415857
  416711
  418112
  418117
  418139
  418146
  419439
  420394
  422101
  423651
  423662
  429596
  429602
  430347
  434314
  434315
  434326
  434336
  434338
  434339
  434344
  435403
  439125
  439171
  439931
  443240
  443243
  443276
  449022
  449023
  457816
  460813
  462231
  470428
  476662
  476704
  482293
  483741
  486778
  493258
  493839
  500897
  518191
  522169
  522171
  524066
  526473
  550887
  582579
  588717
  599502
  613530
  623284
  666475
  701303
  705454
  713332
  728039
  736872
  736990
  738486
  738506
  746131
  755942
  756138
  761632
  776059
  782462
  791165
  791890
  791922
  791928
  792146
  800522
  800540
  800542
  800698
  800733
  805548
  807009
  808331
  808842
  827619
]
2.17 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexmachine"
]
1.89 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сексмашин"
]
1.80 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.07%)
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.