Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.80 ms
(87.27%)
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
  108107
  188390
  232953
  382444
  386794
  393102
  394409
  394425
  398552
  407792
  409934
  411695
  424529
  425215
  464530
  464791
  469427
  472676
  483378
  497209
  499359
  507263
  509440
  512199
  517005
  518828
  520875
  531275
  531535
  534003
  535053
  536453
  543535
  544489
  544493
  544501
  544502
  549799
  550486
  554848
  555082
  562567
  566488
  579190
  581305
  618757
  620009
  624837
  632074
  650519
  661593
  670234
  680442
  699625
  706888
  715367
  717664
  724233
  726957
  726967
  727034
  727047
  727754
  727787
  727810
  728541
  729272
  731399
  734373
  734489
  738327
  738639
  740792
  742407
  748323
  748467
  752966
  756233
  759905
  760976
  763914
  765547
  765723
  766503
  766509
  770208
  771968
  776968
  781666
  782470
  792946
  796048
  796164
  796276
  797206
  800259
  802554
  803722
  805282
  808049
  811837
  817347
  817698
  818986
  823578
  823613
  823760
  824262
  824265
  824359
  824461
  824672
  825110
  825243
  826057
  826157
  826316
  826880
  827220
  827669
]
14.90 ms
(7.89%)
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
  620009
  632074
  802554
  738327
  776968
  517005
  108107
  469427
  650519
  796164
  562567
  543535
  520875
  544501
  766509
  766503
  424529
  512199
  566488
  425215
  531535
  497209
  518828
  409934
  544489
  483378
  544493
  544502
  509440
  549799
  534003
  742407
  771968
  624837
  699625
  808049
  232953
  811837
  770208
  464530
  188390
  826316
  826057
  618757
  824265
  760976
  817347
  536453
  824461
  824672
  824359
  727810
  818986
  748323
  717664
  706888
  763914
  781666
  727754
  740792
  464791
  394425
  661593
  782470
  499359
  825243
  550486
  765723
  386794
  827220
  824262
  800259
  796276
  727787
  407792
  726957
  823578
  554848
  727047
  728541
  729272
  734489
  792946
  731399
  738639
  752966
  715367
  823760
  823613
  531275
  680442
  734373
  727034
  748467
  765547
  394409
  382444
  724233
  393102
  398552
  535053
  472676
  555082
  579190
  581305
  670234
  797206
  796048
  805282
  756233
  803722
  726967
  759905
  411695
  825110
  826880
  817698
  826157
  827669
  507263
]
2.61 ms
(1.38%)
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
  108107
  188390
  232953
  382444
  386794
  393102
  394409
  394425
  398552
  407792
  409934
  411695
  424529
  425215
  464530
  464791
  469427
  472676
  483378
  497209
  499359
  507263
  509440
  512199
  517005
  518828
  520875
  531275
  531535
  534003
  535053
  536453
  543535
  544489
  544493
  544501
  544502
  549799
  550486
  554848
  555082
  562567
  566488
  579190
  581305
  618757
  620009
  624837
  632074
  650519
  661593
  670234
  680442
  699625
  706888
  715367
  717664
  724233
  726957
  726967
  727034
  727047
  727754
  727787
  727810
  728541
  729272
  731399
  734373
  734489
  738327
  738639
  740792
  742407
  748323
  748467
  752966
  756233
  759905
  760976
  763914
  765547
  765723
  766503
  766509
  770208
  771968
  776968
  781666
  782470
  792946
  796048
  796164
  796276
  797206
  800259
  802554
  803722
  805282
  808049
  811837
  817347
  817698
  818986
  823578
  823613
  823760
  824262
  824265
  824359
  824461
  824672
  825110
  825243
  826057
  826157
  826316
  826880
  827220
  827669
]
2.02 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature slut"
]
1.57 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature slut"
]
1.54 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature slut"
]

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.