Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
201.15 ms
(89.28%)
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
  383891
  397193
  418564
  418575
  435146
  438714
  444674
  449690
  453200
  453846
  453865
  454193
  454533
  454537
  456627
  456672
  456744
  459267
  470805
  472008
  475814
  476599
  477927
  479393
  479415
  482929
  485404
  485594
  494677
  501923
  506021
  506397
  506744
  511186
  513171
  515668
  516743
  521330
  527773
  533208
  541000
  542776
  543561
  545226
  546561
  553144
  554372
  558658
  559970
  563036
  566488
  568040
  614047
  625141
  627521
  633434
  633989
  637828
  661501
  670825
  673531
  690946
  694138
  701179
  703485
  707865
  712172
  714390
  714421
  715442
  716309
  724859
  725545
  726899
  728511
  733458
  734629
  734707
  736067
  740211
  743005
  747416
  750515
  750843
  754258
  759138
  759552
  761604
  764093
  765548
  765998
  766243
  766468
  767973
  783613
  785556
  788678
  789482
  789627
  789890
  792759
  794882
  796043
  796575
  801161
  802096
  802901
  803999
  805111
  805317
  811144
  812117
  812121
  816881
  818750
  818813
  818881
  820013
  826690
  826809
]
13.46 ms
(5.97%)
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
  625141
  627521
  633434
  633989
  637828
  701179
  703485
  707865
  712172
  715442
  673531
  761604
  743005
  383891
  397193
  826690
  818813
  820013
  816881
  818750
  818881
  826809
  694138
  714390
  716309
  559970
  785556
  789627
  789890
  794882
  801161
  802096
  805317
  812117
  783613
  789482
  796575
  725545
  747416
  792759
  811144
  740211
  765998
  754258
  764093
  766468
  734707
  750843
  765548
  724859
  734629
  736067
  766243
  714421
  788678
  796043
  802901
  812121
  728511
  750515
  726899
  759552
  456627
  418564
  435146
  454533
  456744
  475814
  453200
  456672
  459267
  470805
  511186
  513171
  558658
  554372
  563036
  566488
  438714
  453846
  454193
  444674
  453865
  479415
  418575
  477927
  449690
  454537
  476599
  479393
  472008
  516743
  506397
  515668
  482929
  485404
  506744
  521330
  527773
  533208
  568040
  542776
  553144
  541000
  543561
  546561
  670825
  545226
  803999
  767973
  690946
  661501
  494677
  506021
  614047
  501923
  485594
  805111
  759138
  733458
]
2.74 ms
(1.21%)
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
  383891
  397193
  418564
  418575
  435146
  438714
  444674
  449690
  453200
  453846
  453865
  454193
  454533
  454537
  456627
  456672
  456744
  459267
  470805
  472008
  475814
  476599
  477927
  479393
  479415
  482929
  485404
  485594
  494677
  501923
  506021
  506397
  506744
  511186
  513171
  515668
  516743
  521330
  527773
  533208
  541000
  542776
  543561
  545226
  546561
  553144
  554372
  558658
  559970
  563036
  566488
  568040
  614047
  625141
  627521
  633434
  633989
  637828
  661501
  670825
  673531
  690946
  694138
  701179
  703485
  707865
  712172
  714390
  714421
  715442
  716309
  724859
  725545
  726899
  728511
  733458
  734629
  734707
  736067
  740211
  743005
  747416
  750515
  750843
  754258
  759138
  759552
  761604
  764093
  765548
  765998
  766243
  766468
  767973
  783613
  785556
  788678
  789482
  789627
  789890
  792759
  794882
  796043
  796575
  801161
  802096
  802901
  803999
  805111
  805317
  811144
  812117
  812121
  816881
  818750
  818813
  818881
  820013
  826690
  826809
]
2.20 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.13 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт домашн любительск"
]
2.00 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden home made"
]
1.62 ms
(0.72%)
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.