Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.78 ms
(82.72%)
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
  11177
  16882
  33443
  81734
  88182
  88246
  118201
  154127
  154206
  154463
  154692
  159291
  375135
  382404
  382813
  383217
  383672
  385713
  388312
  389541
  392427
  392839
  392843
  393326
  394639
  396071
  401178
  401353
  402626
  407436
  413006
  413341
  414271
  415859
  416029
  416525
  416580
  416581
  416648
  416653
  416668
  416675
  416680
  416700
  416720
  418112
  423592
  423995
  424574
  424614
  428229
  428568
  432683
  435136
  435557
  435559
  437859
  439059
  439531
  441040
  441081
  441120
  444283
  445984
  447151
  448431
  448878
  449023
  449104
  450969
  451266
  451336
  452746
  452889
  462381
  467112
  467155
  467568
  471654
  474284
  475649
  479542
  480848
  483742
  484065
  485527
  487418
  488713
  493477
  495762
  495763
  496126
  496149
  496339
  496722
  497030
  498037
  500721
  502795
  505575
  508556
  510801
  513639
  515572
  519699
  519712
  524147
  525992
  532849
  542707
  555012
  556880
  559062
  633748
  639722
  669376
  669386
  735906
  803009
  810914
]
16.11 ms
(11.04%)
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
  488713
  496149
  498037
  513639
  154206
  392843
  16882
  154127
  394639
  382404
  424614
  416700
  441040
  413341
  467112
  556880
  735906
  471654
  416668
  435557
  451336
  519712
  496339
  510801
  448878
  633748
  467155
  393326
  33443
  803009
  159291
  639722
  401178
  415859
  418112
  428568
  441120
  416029
  416580
  416720
  416525
  495763
  500721
  515572
  487418
  407436
  441081
  416581
  416675
  452889
  479542
  428229
  505575
  524147
  525992
  483742
  496126
  81734
  532849
  493477
  383217
  118201
  413006
  445984
  495762
  508556
  396071
  88246
  382813
  154692
  154463
  11177
  402626
  416653
  416648
  423592
  435136
  423995
  444283
  449023
  467568
  480848
  450969
  555012
  437859
  448431
  474284
  559062
  414271
  449104
  447151
  485527
  497030
  475649
  484065
  542707
  669376
  669386
  424574
  439531
  416680
  439059
  451266
  496722
  502795
  519699
  462381
  385713
  383672
  88182
  392427
  389541
  388312
  401353
  432683
  435559
  452746
  810914
  392839
  375135
]
2.64 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
  11177
  16882
  33443
  81734
  88182
  88246
  118201
  154127
  154206
  154463
  154692
  159291
  375135
  382404
  382813
  383217
  383672
  385713
  388312
  389541
  392427
  392839
  392843
  393326
  394639
  396071
  401178
  401353
  402626
  407436
  413006
  413341
  414271
  415859
  416029
  416525
  416580
  416581
  416648
  416653
  416668
  416675
  416680
  416700
  416720
  418112
  423592
  423995
  424574
  424614
  428229
  428568
  432683
  435136
  435557
  435559
  437859
  439059
  439531
  441040
  441081
  441120
  444283
  445984
  447151
  448431
  448878
  449023
  449104
  450969
  451266
  451336
  452746
  452889
  462381
  467112
  467155
  467568
  471654
  474284
  475649
  479542
  480848
  483742
  484065
  485527
  487418
  488713
  493477
  495762
  495763
  496126
  496149
  496339
  496722
  497030
  498037
  500721
  502795
  505575
  508556
  510801
  513639
  515572
  519699
  519712
  524147
  525992
  532849
  542707
  555012
  556880
  559062
  633748
  639722
  669376
  669386
  735906
  803009
  810914
]
1.93 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"Ðäð©ÐüÐéð©ð¢ð│ÐâÐÄÐé ð©ðÀð▓ÐÇð░ÐëðÁð¢ð║ÐÔǪ"
]
1.76 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг женскийрод"
]
1.48 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фистинг женскийрод"
]
1.31 ms
(0.90%)
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.