Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.04 ms
(87.28%)
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
  546171
  546232
  548174
  548855
  550177
  550905
  556114
  556745
  556898
  559775
  567033
  567510
  574926
  576574
  581549
  586003
  588385
  591780
  599773
  600718
  600998
  602331
  604134
  607765
  609246
  613572
  614254
  616850
  618297
  622046
  625784
  628761
  629427
  629794
  636440
  638697
  642526
  644438
  646353
  647132
  652841
  666455
  666689
  668678
  668951
  669270
  670453
  671801
  673254
  684850
  684890
  689252
  690755
  692837
  693083
  693085
  693376
  695857
  696317
  699963
  700860
  703264
  706046
  712221
  713141
  713427
  713973
  716490
  719475
  722244
  733354
  737866
  740557
  742295
  743227
  744191
  746711
  747423
  749065
  751604
  752074
  760054
  768792
  777550
  777994
  778897
  779331
  784509
  784982
  784985
  785069
  787813
  788222
  788331
  788931
  790242
  793108
  793140
  794323
  795401
  796367
  796389
  796411
  797356
  798331
  798455
  800391
  801794
  801830
  802279
  803089
  803483
  803626
  804386
  805841
  805918
  806678
  807006
  808966
  812469
]
10.64 ms
(6.83%)
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
  666455
  666689
  668678
  669270
  673254
  692837
  699963
  713973
  719475
  646353
  671801
  684890
  693376
  695857
  703264
  712221
  713141
  713427
  647132
  652841
  668951
  670453
  684850
  689252
  690755
  693083
  693085
  696317
  700860
  706046
  716490
  722244
  546171
  546232
  548174
  548855
  550177
  550905
  556114
  556745
  556898
  559775
  567033
  567510
  574926
  576574
  581549
  586003
  599773
  600998
  602331
  604134
  614254
  616850
  618297
  622046
  625784
  628761
  629427
  629794
  591780
  600718
  636440
  638697
  642526
  644438
  588385
  607765
  613572
  609246
  779331
  784509
  785069
  788222
  788931
  790242
  796411
  797356
  800391
  801794
  801830
  803483
  805841
  805918
  806678
  812469
  777550
  777994
  778897
  787813
  788331
  793108
  793140
  794323
  795401
  796367
  796389
  798331
  798455
  802279
  803089
  803626
  804386
  807006
  808966
  733354
  737866
  740557
  742295
  743227
  744191
  746711
  747423
  749065
  751604
  752074
  760054
  768792
  784982
  784985
]
2.82 ms
(1.81%)
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
  546171
  546232
  548174
  548855
  550177
  550905
  556114
  556745
  556898
  559775
  567033
  567510
  574926
  576574
  581549
  586003
  588385
  591780
  599773
  600718
  600998
  602331
  604134
  607765
  609246
  613572
  614254
  616850
  618297
  622046
  625784
  628761
  629427
  629794
  636440
  638697
  642526
  644438
  646353
  647132
  652841
  666455
  666689
  668678
  668951
  669270
  670453
  671801
  673254
  684850
  684890
  689252
  690755
  692837
  693083
  693085
  693376
  695857
  696317
  699963
  700860
  703264
  706046
  712221
  713141
  713427
  713973
  716490
  719475
  722244
  733354
  737866
  740557
  742295
  743227
  744191
  746711
  747423
  749065
  751604
  752074
  760054
  768792
  777550
  777994
  778897
  779331
  784509
  784982
  784985
  785069
  787813
  788222
  788331
  788931
  790242
  793108
  793140
  794323
  795401
  796367
  796389
  796411
  797356
  798331
  798455
  800391
  801794
  801830
  802279
  803089
  803483
  803626
  804386
  805841
  805918
  806678
  807006
  808966
  812469
]
1.89 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo hole"
]
1.64 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло дырк"
]
1.46 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.88%)
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.