Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.04 ms
(51.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
167.41 ms
(41.44%)
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
  393590
  396087
  412663
  414110
  414548
  415249
  416539
  418416
  419406
  422409
  422657
  425518
  426359
  427284
  434702
  435727
  443090
  443491
  446198
  446657
  448519
  451372
  463937
  466395
  468592
  468718
  471908
  473529
  476223
  483094
  485899
  489346
  490071
  491253
  491256
  494617
  495793
  496451
  498022
  502191
  503113
  506213
  508485
  510117
  515893
  517351
  518013
  518212
  525825
  527218
  531242
  540747
  542218
  551081
  553703
  553720
  554440
  556423
  558217
  559162
  559428
  560202
  560217
  562311
  562397
  562491
  563553
  564007
  564073
  564777
  565316
  565359
  565718
  565946
  569312
  571691
  572053
  573615
  574773
  575532
  576419
  579353
  579881
  586501
  588818
  589750
  590561
  593724
  593966
  596526
  596887
  597246
  598184
  598592
  598739
  600281
  601491
  602650
  603001
  603403
  603605
  603829
  612699
  616713
  620419
  622682
  623206
  623849
  624000
  624272
  626881
  628082
  630177
  655255
  659409
  663769
  669361
  678769
  714109
  795683
]
18.56 ms
(4.59%)
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
  565316
  569312
  663769
  678769
  714109
  669361
  559428
  564777
  565359
  576419
  620419
  588818
  597246
  603829
  593966
  596887
  598184
  624000
  586501
  590561
  593724
  616713
  795683
  612699
  622682
  412663
  473529
  416539
  414110
  426359
  448519
  422409
  466395
  503113
  540747
  496451
  502191
  517351
  510117
  515893
  525825
  494617
  393590
  422657
  463937
  531242
  518013
  575532
  564073
  553720
  558217
  655255
  554440
  556423
  562311
  571691
  574773
  589750
  602650
  600281
  603001
  603403
  603605
  425518
  471908
  415249
  446657
  483094
  491253
  508485
  518212
  490071
  491256
  443090
  434702
  446198
  468592
  485899
  451372
  506213
  542218
  559162
  563553
  551081
  560202
  562491
  659409
  579881
  623849
  396087
  418416
  419406
  427284
  414548
  435727
  495793
  489346
  498022
  527218
  553703
  560217
  565946
  572053
  601491
  598739
  626881
  443491
  476223
  468718
  564007
  579353
  562397
  565718
  573615
  596526
  623206
  630177
  598592
  624272
  628082
]
3.25 ms
(0.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
  393590
  396087
  412663
  414110
  414548
  415249
  416539
  418416
  419406
  422409
  422657
  425518
  426359
  427284
  434702
  435727
  443090
  443491
  446198
  446657
  448519
  451372
  463937
  466395
  468592
  468718
  471908
  473529
  476223
  483094
  485899
  489346
  490071
  491253
  491256
  494617
  495793
  496451
  498022
  502191
  503113
  506213
  508485
  510117
  515893
  517351
  518013
  518212
  525825
  527218
  531242
  540747
  542218
  551081
  553703
  553720
  554440
  556423
  558217
  559162
  559428
  560202
  560217
  562311
  562397
  562491
  563553
  564007
  564073
  564777
  565316
  565359
  565718
  565946
  569312
  571691
  572053
  573615
  574773
  575532
  576419
  579353
  579881
  586501
  588818
  589750
  590561
  593724
  593966
  596526
  596887
  597246
  598184
  598592
  598739
  600281
  601491
  602650
  603001
  603403
  603605
  603829
  612699
  616713
  620419
  622682
  623206
  623849
  624000
  624272
  626881
  628082
  630177
  655255
  659409
  663769
  669361
  678769
  714109
  795683
]
2.01 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tight skinny"
]
1.42 ms
(0.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "tight худые"
]
1.30 ms
(0.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "tight худые"
]

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.