Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.29 ms
(84.98%)
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
  385344
  388726
  401032
  411736
  411761
  413641
  414364
  419654
  419773
  423518
  425168
  426511
  432831
  440906
  444820
  448863
  454284
  455085
  461765
  462342
  465604
  466063
  466838
  470064
  470500
  471000
  471122
  471881
  472120
  473944
  474654
  477943
  478782
  478784
  484678
  486862
  493587
  495562
  495752
  497905
  502540
  502775
  503934
  510876
  515089
  518585
  520775
  522891
  527871
  531195
  533013
  534999
  536580
  537195
  537886
  541110
  542508
  543497
  545389
  545505
  550305
  550327
  571146
  571230
  576355
  576650
  585011
  585013
  585698
  592444
  603671
  603682
  610284
  611346
  628315
  628394
  632333
  632684
  632688
  633524
  633766
  634771
  637033
  637048
  637438
  637680
  638552
  640525
  644689
  645020
  646782
  648238
  648685
  650817
  652915
  656507
  656577
  666907
  672175
  677703
  678942
  679761
  679808
  680111
  680153
  681031
  681587
  683529
  707280
  711291
  712964
  715128
  719104
  745493
  746995
  755850
  756390
  773833
  775752
  815490
]
18.79 ms
(10.15%)
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
  633766
  455085
  426511
  466063
  484678
  474654
  470064
  486862
  510876
  515089
  536580
  652915
  592444
  411736
  440906
  413641
  815490
  518585
  531195
  493587
  571230
  541110
  680111
  666907
  650817
  628315
  603682
  637438
  603671
  628394
  632333
  632688
  633524
  423518
  444820
  473944
  401032
  522891
  527871
  495562
  425168
  495752
  520775
  503934
  533013
  576650
  545389
  432831
  419773
  466838
  477943
  648685
  745493
  462342
  461765
  388726
  411761
  419654
  414364
  585013
  585011
  465604
  472120
  470500
  454284
  537195
  497905
  534999
  537886
  543497
  545505
  542508
  550305
  646782
  656507
  672175
  681031
  683529
  707280
  715128
  719104
  678942
  681587
  712964
  645020
  648238
  656577
  677703
  679761
  679808
  680153
  550327
  571146
  576355
  637680
  610284
  632684
  637033
  640525
  644689
  637048
  638552
  775752
  756390
  746995
  755850
  773833
  611346
  634771
  711291
  385344
  471122
  471000
  478782
  478784
  502775
  448863
  585698
  502540
  471881
]
2.88 ms
(1.56%)
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
  385344
  388726
  401032
  411736
  411761
  413641
  414364
  419654
  419773
  423518
  425168
  426511
  432831
  440906
  444820
  448863
  454284
  455085
  461765
  462342
  465604
  466063
  466838
  470064
  470500
  471000
  471122
  471881
  472120
  473944
  474654
  477943
  478782
  478784
  484678
  486862
  493587
  495562
  495752
  497905
  502540
  502775
  503934
  510876
  515089
  518585
  520775
  522891
  527871
  531195
  533013
  534999
  536580
  537195
  537886
  541110
  542508
  543497
  545389
  545505
  550305
  550327
  571146
  571230
  576355
  576650
  585011
  585013
  585698
  592444
  603671
  603682
  610284
  611346
  628315
  628394
  632333
  632684
  632688
  633524
  633766
  634771
  637033
  637048
  637438
  637680
  638552
  640525
  644689
  645020
  646782
  648238
  648685
  650817
  652915
  656507
  656577
  666907
  672175
  677703
  678942
  679761
  679808
  680111
  680153
  681031
  681587
  683529
  707280
  711291
  712964
  715128
  719104
  745493
  746995
  755850
  756390
  773833
  775752
  815490
]
1.74 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные сиськ без силикон double"
]
1.47 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural tits double"
]
1.39 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "натуральная натуральные сиськ без силикон double"
]

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.