Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.75 ms
(84.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
  16971
  395632
  395747
  396647
  402247
  416039
  419178
  426084
  434275
  436933
  438067
  438095
  443591
  443609
  443871
  445879
  447400
  448938
  449170
  454924
  455919
  457629
  458694
  461599
  462535
  464366
  465010
  465103
  465253
  470106
  470150
  470335
  473598
  477355
  477545
  478818
  482409
  483660
  484649
  484915
  485591
  485788
  485940
  487719
  488352
  489310
  498306
  499010
  499028
  502326
  504163
  504408
  506841
  509033
  513824
  514692
  514815
  514949
  516141
  516429
  516634
  516875
  517190
  519240
  519272
  521534
  522107
  522318
  523474
  525871
  526435
  526948
  529271
  531278
  532352
  534300
  534850
  534968
  541215
  543604
  549778
  551577
  570214
  570700
  573644
  574231
  574831
  576343
  581354
  582189
  586539
  590809
  591437
  591646
  593641
  593855
  593875
  593992
  595011
  598642
  603629
  608695
  609783
  615443
  625556
  633047
  649240
  675471
  695282
  713630
  716501
  718798
  722903
  726553
  784315
  784475
  786064
  795179
  798684
  811133
]
15.37 ms
(9.39%)
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
  516875
  525871
  485591
  509033
  514815
  449170
  434275
  455919
  582189
  484649
  484915
  470150
  593992
  514949
  477355
  443609
  526435
  443871
  419178
  436933
  534850
  595011
  586539
  784315
  576343
  502326
  462535
  543604
  506841
  519240
  458694
  426084
  485940
  517190
  608695
  529271
  445879
  461599
  718798
  649240
  811133
  470106
  478818
  454924
  514692
  485788
  498306
  499010
  516141
  551577
  464366
  526948
  448938
  457629
  521534
  531278
  465103
  593641
  603629
  798684
  438067
  443591
  465010
  516429
  473598
  615443
  470335
  477545
  570700
  489310
  522107
  516634
  591646
  726553
  609783
  504163
  402247
  395632
  570214
  716501
  396647
  598642
  416039
  504408
  465253
  549778
  675471
  593855
  574231
  722903
  541215
  593875
  395747
  532352
  574831
  695282
  713630
  784475
  786064
  795179
  488352
  522318
  499028
  573644
  513824
  483660
  534968
  590809
  625556
  447400
  16971
  438095
  534300
  581354
  482409
  633047
  591437
  519272
  523474
  487719
]
2.63 ms
(1.61%)
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
  16971
  395632
  395747
  396647
  402247
  416039
  419178
  426084
  434275
  436933
  438067
  438095
  443591
  443609
  443871
  445879
  447400
  448938
  449170
  454924
  455919
  457629
  458694
  461599
  462535
  464366
  465010
  465103
  465253
  470106
  470150
  470335
  473598
  477355
  477545
  478818
  482409
  483660
  484649
  484915
  485591
  485788
  485940
  487719
  488352
  489310
  498306
  499010
  499028
  502326
  504163
  504408
  506841
  509033
  513824
  514692
  514815
  514949
  516141
  516429
  516634
  516875
  517190
  519240
  519272
  521534
  522107
  522318
  523474
  525871
  526435
  526948
  529271
  531278
  532352
  534300
  534850
  534968
  541215
  543604
  549778
  551577
  570214
  570700
  573644
  574231
  574831
  576343
  581354
  582189
  586539
  590809
  591437
  591646
  593641
  593855
  593875
  593992
  595011
  598642
  603629
  608695
  609783
  615443
  625556
  633047
  649240
  675471
  695282
  713630
  716501
  718798
  722903
  726553
  784315
  784475
  786064
  795179
  798684
  811133
]
1.95 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "частное домашний жмж"
]
1.92 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск домашн любительск жмж секс втро"
]
1.46 ms
(0.89%)
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.