Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.80 ms
(58.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр домашн любительск"
]
121.95 ms
(33.84%)
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
  460903
  470407
  489468
  515014
  519012
  523624
  538832
  541594
  542241
  542934
  544113
  544206
  545517
  545629
  545642
  546611
  546774
  546943
  546993
  547607
  549768
  549776
  549778
  550227
  551847
  552123
  557991
  558172
  558249
  559063
  559064
  560075
  560387
  560452
  561030
  561599
  562826
  563225
  563432
  563447
  565351
  566252
  566304
  566370
  566673
  566937
  567382
  567384
  567385
  567393
  567394
  567397
  567400
  567408
  567429
  567431
  567728
  567951
  569427
  572176
  572548
  574231
  574265
  576643
  577370
  578952
  580286
  580775
  581349
  581354
  581392
  581618
  582342
  583387
  584004
  584244
  587797
  587817
  590693
  592521
  597117
  597134
  601851
  601853
  604060
  606056
  616686
  617641
  619076
  619379
  620757
  622831
  622832
  622833
  622839
  624797
  625487
  625491
  634746
  641370
  643007
  646895
  648880
  649604
  649614
  670274
  672804
  673537
  680633
  690803
  691186
  692169
  716572
  733145
  733378
  748695
  759270
  770055
  790986
  796836
]
17.73 ms
(4.92%)
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
  673537
  549776
  567393
  567728
  542934
  559063
  567384
  567400
  567431
  572176
  560452
  649614
  557991
  567397
  470407
  558172
  582342
  544206
  545629
  559064
  545642
  581618
  648880
  563432
  567408
  587797
  566673
  561030
  733145
  552123
  649604
  590693
  597117
  690803
  619379
  692169
  625487
  561599
  546611
  643007
  790986
  748695
  716572
  551847
  550227
  576643
  547607
  569427
  549768
  567385
  584004
  567382
  606056
  619076
  624797
  567429
  691186
  460903
  515014
  567951
  544113
  558249
  672804
  580775
  541594
  646895
  545517
  580286
  641370
  549778
  572548
  584244
  574231
  574265
  680633
  670274
  581354
  519012
  578952
  583387
  634746
  538832
  546993
  489468
  625491
  560075
  542241
  546943
  567394
  587817
  616686
  601853
  622831
  622833
  566370
  604060
  733378
  566304
  563447
  563225
  577370
  562826
  622839
  546774
  581392
  759270
  523624
  560387
  622832
  770055
  597134
  617641
  592521
  565351
  601851
  581349
  796836
  620757
  566252
  566937
]
2.98 ms
(0.83%)
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
  460903
  470407
  489468
  515014
  519012
  523624
  538832
  541594
  542241
  542934
  544113
  544206
  545517
  545629
  545642
  546611
  546774
  546943
  546993
  547607
  549768
  549776
  549778
  550227
  551847
  552123
  557991
  558172
  558249
  559063
  559064
  560075
  560387
  560452
  561030
  561599
  562826
  563225
  563432
  563447
  565351
  566252
  566304
  566370
  566673
  566937
  567382
  567384
  567385
  567393
  567394
  567397
  567400
  567408
  567429
  567431
  567728
  567951
  569427
  572176
  572548
  574231
  574265
  576643
  577370
  578952
  580286
  580775
  581349
  581354
  581392
  581618
  582342
  583387
  584004
  584244
  587797
  587817
  590693
  592521
  597117
  597134
  601851
  601853
  604060
  606056
  616686
  617641
  619076
  619379
  620757
  622831
  622832
  622833
  622839
  624797
  625487
  625491
  634746
  641370
  643007
  646895
  648880
  649604
  649614
  670274
  672804
  673537
  680633
  690803
  691186
  692169
  716572
  733145
  733378
  748695
  759270
  770055
  790986
  796836
]
2.23 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ретро домашка"
]
1.90 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр домашн любительск"
]
1.82 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.