Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.27 ms
(86.93%)
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
  391992
  397437
  408911
  410694
  412855
  413392
  415885
  416531
  416690
  432670
  432674
  432680
  438455
  440659
  441037
  446447
  447597
  448115
  448854
  452780
  459198
  459403
  465148
  475457
  477761
  483737
  493861
  512852
  513830
  514117
  514233
  516843
  525279
  531806
  535294
  535363
  542413
  543897
  547556
  547925
  551543
  552704
  554827
  554983
  560012
  563310
  565621
  565701
  567127
  567508
  575844
  575956
  582636
  585272
  587576
  592046
  592259
  592632
  594053
  602897
  605566
  608650
  618799
  619590
  630091
  634686
  641806
  650719
  650770
  656879
  659209
  659944
  675897
  678707
  682822
  686331
  702319
  711611
  716086
  720024
  722382
  722398
  739139
  744047
  746191
  749134
  750998
  754456
  759052
  761265
  766285
  770261
  771887
  780309
  781424
  782749
  783600
  786019
  790192
  793119
  794316
  794706
  796692
  796709
  797035
  797039
  797886
  798593
  800530
  800649
  803506
  806139
  806828
  807570
  807642
  809330
  809660
  811330
  811714
  812275
]
13.64 ms
(6.40%)
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
  514233
  432680
  391992
  477761
  459198
  410694
  711611
  656879
  585272
  475457
  531806
  565701
  567508
  575956
  650719
  650770
  560012
  619590
  782749
  786019
  797886
  807570
  811714
  790192
  794706
  796692
  797035
  798593
  800649
  759052
  761265
  766285
  781424
  783600
  809330
  809660
  811330
  812275
  750998
  746191
  754456
  749134
  780309
  793119
  794316
  796709
  797039
  800530
  806139
  806828
  807642
  682822
  686331
  659944
  592632
  594053
  602897
  608650
  618799
  641806
  605566
  634686
  587576
  675897
  678707
  412855
  432674
  415885
  448854
  483737
  567127
  547556
  552704
  592046
  592259
  630091
  413392
  465148
  441037
  513830
  493861
  542413
  575844
  771887
  512852
  397437
  416531
  408911
  416690
  432670
  446447
  459403
  448115
  535294
  516843
  565621
  543897
  554983
  582636
  659209
  722382
  803506
  744047
  770261
  739139
  447597
  452780
  440659
  438455
  525279
  535363
  514117
  563310
  547925
  551543
  702319
  716086
  720024
  722398
  554827
]
3.87 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
  391992
  397437
  408911
  410694
  412855
  413392
  415885
  416531
  416690
  432670
  432674
  432680
  438455
  440659
  441037
  446447
  447597
  448115
  448854
  452780
  459198
  459403
  465148
  475457
  477761
  483737
  493861
  512852
  513830
  514117
  514233
  516843
  525279
  531806
  535294
  535363
  542413
  543897
  547556
  547925
  551543
  552704
  554827
  554983
  560012
  563310
  565621
  565701
  567127
  567508
  575844
  575956
  582636
  585272
  587576
  592046
  592259
  592632
  594053
  602897
  605566
  608650
  618799
  619590
  630091
  634686
  641806
  650719
  650770
  656879
  659209
  659944
  675897
  678707
  682822
  686331
  702319
  711611
  716086
  720024
  722382
  722398
  739139
  744047
  746191
  749134
  750998
  754456
  759052
  761265
  766285
  770261
  771887
  780309
  781424
  782749
  783600
  786019
  790192
  793119
  794316
  794706
  796692
  796709
  797035
  797039
  797886
  798593
  800530
  800649
  803506
  806139
  806828
  807570
  807642
  809330
  809660
  811330
  811714
  812275
]
3.87 ms
(1.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
3.38 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home made dildo"
]
1.66 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск дилд"
]
1.44 ms
(0.68%)
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.