Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.23 ms
(83.36%)
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
  92038
  373768
  404036
  404590
  405561
  407694
  409048
  410660
  413135
  417116
  417721
  419892
  420056
  420382
  423444
  424531
  425942
  430400
  431205
  436465
  437013
  438468
  443463
  445837
  447619
  449096
  450256
  450296
  450992
  451035
  451761
  453053
  453724
  455203
  455989
  457540
  458716
  460130
  460428
  460525
  460699
  461582
  462059
  462344
  463197
  463212
  464382
  464963
  466356
  466900
  467311
  467550
  468109
  470764
  472123
  473459
  475201
  476202
  479449
  491862
  492452
  499389
  499438
  499741
  501927
  506931
  506973
  508227
  511114
  512893
  514057
  517552
  520137
  521636
  523597
  523910
  524973
  525617
  525865
  526446
  528564
  532508
  533814
  534701
  535572
  538138
  538961
  539906
  540851
  544497
  547565
  551645
  552473
  552597
  555568
  556809
  557020
  557484
  557814
  561491
  563478
  565339
  565463
  567309
  569235
  569591
  575017
  588338
  589304
  594100
  594825
  595307
  596791
  604916
  617649
  618834
  622064
  632682
  634035
  672677
]
18.29 ms
(10.57%)
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
  419892
  420056
  425942
  413135
  417721
  420382
  453053
  453724
  455203
  464382
  466356
  473459
  476202
  491862
  450296
  458716
  460130
  460525
  492452
  445837
  499389
  525865
  517552
  525617
  506973
  508227
  520137
  538138
  539906
  521636
  528564
  533814
  472123
  479449
  544497
  547565
  552473
  552597
  561491
  569591
  575017
  557020
  557484
  563478
  567309
  672677
  551645
  556809
  557814
  634035
  618834
  622064
  632682
  588338
  596791
  604916
  595307
  405561
  407694
  431205
  463197
  475201
  373768
  462059
  468109
  92038
  404036
  424531
  436465
  443463
  450256
  451035
  457540
  460699
  463212
  467550
  404590
  409048
  410660
  417116
  423444
  461582
  450992
  467311
  470764
  524973
  532508
  512893
  499438
  499741
  501927
  523597
  437013
  447619
  455989
  466900
  534701
  506931
  526446
  535572
  565463
  617649
  430400
  438468
  540851
  451761
  462344
  449096
  514057
  538961
  523910
  511114
  460428
  464963
  555568
  565339
  569235
  589304
  594825
  594100
]
3.14 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
  92038
  373768
  404036
  404590
  405561
  407694
  409048
  410660
  413135
  417116
  417721
  419892
  420056
  420382
  423444
  424531
  425942
  430400
  431205
  436465
  437013
  438468
  443463
  445837
  447619
  449096
  450256
  450296
  450992
  451035
  451761
  453053
  453724
  455203
  455989
  457540
  458716
  460130
  460428
  460525
  460699
  461582
  462059
  462344
  463197
  463212
  464382
  464963
  466356
  466900
  467311
  467550
  468109
  470764
  472123
  473459
  475201
  476202
  479449
  491862
  492452
  499389
  499438
  499741
  501927
  506931
  506973
  508227
  511114
  512893
  514057
  517552
  520137
  521636
  523597
  523910
  524973
  525617
  525865
  526446
  528564
  532508
  533814
  534701
  535572
  538138
  538961
  539906
  540851
  544497
  547565
  551645
  552473
  552597
  555568
  556809
  557020
  557484
  557814
  561491
  563478
  565339
  565463
  567309
  569235
  569591
  575017
  588338
  589304
  594100
  594825
  595307
  596791
  604916
  617649
  618834
  622064
  632682
  634035
  672677
]
2.36 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хуй соска"
]
1.76 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член соск"
]
1.66 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член соск"
]
1.60 ms
(0.92%)
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.