Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.46 ms
(87.08%)
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
  417841
  419765
  420534
  422074
  423499
  426101
  427592
  430355
  432647
  432690
  432692
  432732
  432778
  432803
  435177
  435472
  441430
  441519
  445340
  447007
  452636
  454926
  456551
  460663
  461778
  462071
  462757
  463810
  464155
  464811
  464837
  465267
  468956
  470425
  471300
  471330
  471554
  472692
  476975
  480714
  484423
  486204
  487382
  488948
  489271
  491802
  492495
  493172
  495364
  495607
  496616
  500884
  500938
  505803
  510456
  511348
  513508
  513552
  514024
  516136
  518451
  519436
  521205
  522216
  525391
  526466
  527874
  529616
  534494
  538266
  541732
  542127
  542161
  545814
  546752
  547865
  548907
  549697
  550337
  554552
  556445
  556973
  558490
  560844
  562883
  563031
  563082
  566128
  576516
  578438
  580418
  586897
  589278
  592956
  593787
  595549
  604631
  608725
  608751
  622932
  625572
  628614
  630751
  632096
  638024
  680422
  720132
  735195
  743068
  750668
  754160
  761048
  761496
  761583
  765493
  766996
  785319
  787556
  794135
  801259
]
15.04 ms
(7.64%)
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
  754160
  761048
  743068
  765493
  766996
  761496
  750668
  632096
  720132
  787556
  432803
  441430
  435177
  452636
  461778
  432778
  500938
  538266
  489271
  495364
  513508
  500884
  522216
  487382
  505803
  527874
  445340
  471554
  417841
  441519
  432732
  422074
  420534
  432690
  447007
  463810
  465267
  486204
  454926
  460663
  511348
  526466
  496616
  529616
  464837
  480714
  488948
  492495
  542161
  549697
  547865
  548907
  562883
  563082
  680422
  554552
  556445
  576516
  592956
  593787
  628614
  595549
  589278
  794135
  801259
  735195
  608725
  462757
  472692
  471300
  464811
  464155
  470425
  513552
  514024
  493172
  495607
  510456
  426101
  560844
  471330
  546752
  419765
  556973
  427592
  491802
  622932
  423499
  432692
  435472
  432647
  462071
  476975
  468956
  534494
  518451
  519436
  541732
  542127
  545814
  550337
  558490
  563031
  566128
  578438
  580418
  608751
  625572
  630751
  638024
  586897
  785319
  761583
  604631
  430355
  456551
  516136
  521205
  525391
  484423
]
2.75 ms
(1.39%)
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
  417841
  419765
  420534
  422074
  423499
  426101
  427592
  430355
  432647
  432690
  432692
  432732
  432778
  432803
  435177
  435472
  441430
  441519
  445340
  447007
  452636
  454926
  456551
  460663
  461778
  462071
  462757
  463810
  464155
  464811
  464837
  465267
  468956
  470425
  471300
  471330
  471554
  472692
  476975
  480714
  484423
  486204
  487382
  488948
  489271
  491802
  492495
  493172
  495364
  495607
  496616
  500884
  500938
  505803
  510456
  511348
  513508
  513552
  514024
  516136
  518451
  519436
  521205
  522216
  525391
  526466
  527874
  529616
  534494
  538266
  541732
  542127
  542161
  545814
  546752
  547865
  548907
  549697
  550337
  554552
  556445
  556973
  558490
  560844
  562883
  563031
  563082
  566128
  576516
  578438
  580418
  586897
  589278
  592956
  593787
  595549
  604631
  608725
  608751
  622932
  625572
  628614
  630751
  632096
  638024
  680422
  720132
  735195
  743068
  750668
  754160
  761048
  761496
  761583
  765493
  766996
  785319
  787556
  794135
  801259
]
2.23 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife is crying"
]
2.15 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен крича вперв"
]
1.61 ms
(0.82%)
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.