Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.77 ms
(87.75%)
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
  233053
  387121
  403243
  404600
  407182
  417997
  423148
  423155
  423468
  423476
  424254
  424744
  426227
  432235
  440830
  442852
  446107
  456589
  461233
  471164
  476697
  477097
  485671
  490665
  494686
  494816
  510780
  529802
  529842
  537371
  541379
  547992
  552368
  554748
  555077
  555092
  555411
  580133
  584693
  586175
  593151
  600820
  603406
  605560
  610436
  611493
  616740
  616798
  617362
  623461
  625157
  627180
  630802
  633708
  634617
  676436
  677848
  687485
  693032
  696070
  697720
  706405
  707404
  709346
  712643
  714906
  721831
  724798
  725478
  726385
  728243
  728619
  728832
  731125
  731441
  735581
  741819
  746566
  756240
  756296
  759607
  759762
  759906
  762989
  763060
  763370
  763561
  764040
  764266
  765145
  769243
  769349
  769877
  770494
  775004
  788634
  796009
  796051
  796207
  796481
  801654
  803960
  805152
  806712
  807844
  809767
  810030
  811019
  811280
  813919
  814293
  814979
  817718
  821284
  823943
  824115
  824847
  825267
]
12.75 ms
(7.00%)
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
  756296
  765145
  768323
  769877
  746566
  763699
  769243
  769349
  724798
  728832
  731125
  731441
  763370
  605560
  709346
  806712
  810030
  423468
  456589
  471164
  485671
  600820
  610436
  741819
  423148
  461233
  442852
  403243
  440830
  510780
  424744
  770494
  796009
  407182
  417997
  494686
  552368
  584693
  697720
  554748
  630802
  593151
  775004
  805152
  623461
  811280
  477097
  541379
  796051
  233053
  426227
  821284
  814979
  494816
  529802
  529842
  580133
  677848
  676436
  693032
  696070
  706405
  687485
  555092
  616740
  616798
  634617
  586175
  627180
  801654
  762989
  809767
  728619
  763060
  763561
  764266
  728243
  625157
  633708
  423476
  813919
  814293
  725478
  735581
  759906
  537371
  490665
  796207
  423155
  796481
  726385
  756240
  807844
  404600
  432235
  603406
  446107
  476697
  555077
  824115
  817718
  424254
  803960
  811019
  759762
  759607
  387121
  825267
  823943
  824847
  547992
  555411
  712643
  707404
  714906
  721831
  617362
  611493
  764040
  788634
]
3.09 ms
(1.70%)
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
  233053
  387121
  403243
  404600
  407182
  417997
  423148
  423155
  423468
  423476
  424254
  424744
  426227
  432235
  440830
  442852
  446107
  456589
  461233
  471164
  476697
  477097
  485671
  490665
  494686
  494816
  510780
  529802
  529842
  537371
  541379
  547992
  552368
  554748
  555077
  555092
  555411
  580133
  584693
  586175
  593151
  600820
  603406
  605560
  610436
  611493
  616740
  616798
  617362
  623461
  625157
  627180
  630802
  633708
  634617
  676436
  677848
  687485
  693032
  696070
  697720
  706405
  707404
  709346
  712643
  714906
  721831
  724798
  725478
  726385
  728243
  728619
  728832
  731125
  731441
  735581
  741819
  746566
  756240
  756296
  759607
  759762
  759906
  762989
  763060
  763370
  763561
  764040
  764266
  765145
  769243
  769349
  769877
  770494
  775004
  788634
  796009
  796051
  796207
  796481
  801654
  803960
  805152
  806712
  807844
  809767
  810030
  811019
  811280
  813919
  814293
  814979
  817718
  821284
  823943
  824115
  824847
  825267
]
2.21 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf blowjob cum"
]
1.60 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf минет оральн секс cum"
]
1.47 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf минет оральн секс cum"
]
1.19 ms
(0.65%)
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.