Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.63 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.63 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "оргазм дедов"
]
3 16.43 ms
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
  528789
  523205
  666535
  647906
  413649
  524564
  564416
  720985
  671396
  673092
  713156
  572088
  596585
  778364
  789854
  736164
  734825
  747920
  752538
  702320
  462737
  524023
  444611
  445672
  556485
  673661
  413826
  399304
  527116
  531162
  537531
  508376
  566972
  647945
  677681
  698301
  618151
  590740
  622509
  590203
  624814
  605856
  752523
  757090
  731866
  741310
  708390
  383961
  459751
  465942
  473018
  515100
  521072
  545410
  568555
  632706
  401360
  814810
  534771
  577502
  569908
  723175
  548684
  557608
  582201
  587176
  600016
  775788
  733844
  734840
  733862
  806860
  675008
  472974
  507661
  524496
  563809
  580197
  709524
  714503
  663448
  588747
  585711
  628403
  623617
  757896
  479978
  466395
  470324
  487067
  484478
  473106
  484928
  544309
  579368
  581656
  583271
  623357
  418595
  568554
  653911
  550336
  623849
  633788
  628390
  491500
  526003
  541076
  580298
  663239
  683508
  557845
  624122
  461744
  545755
  583856
  556531
  624430
  406075
  494370
]
4 3.03 ms
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
  383961
  399304
  401360
  406075
  413649
  413826
  418595
  444611
  445672
  459751
  461744
  462737
  465942
  466395
  470324
  472974
  473018
  473106
  479978
  484478
  484928
  487067
  491500
  494370
  507661
  508376
  515100
  521072
  523205
  524023
  524496
  524564
  526003
  527116
  528789
  531162
  534771
  537531
  541076
  544309
  545410
  545755
  548684
  550336
  556485
  556531
  557608
  557845
  563809
  564416
  566972
  568554
  568555
  569908
  572088
  577502
  579368
  580197
  580298
  581656
  582201
  583271
  583856
  585711
  587176
  588747
  590203
  590740
  596585
  600016
  605856
  618151
  622509
  623357
  623617
  623849
  624122
  624430
  624814
  628390
  628403
  632706
  633788
  647906
  647945
  653911
  663239
  663448
  666535
  671396
  673092
  673661
  675008
  677681
  683508
  698301
  702320
  708390
  709524
  713156
  714503
  720985
  723175
  731866
  733844
  733862
  734825
  734840
  736164
  741310
  747920
  752523
  752538
  757090
  757896
  775788
  778364
  789854
  806860
  814810
]
5 442.35 ms
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
  383961
  399304
  401360
  406075
  413649
  413826
  418595
  444611
  445672
  459751
  461744
  462737
  465942
  466395
  470324
  472974
  473018
  473106
  479978
  484478
  484928
  487067
  491500
  494370
  507661
  508376
  515100
  521072
  523205
  524023
  524496
  524564
  526003
  527116
  528789
  531162
  534771
  537531
  541076
  544309
  545410
  545755
  548684
  550336
  556485
  556531
  557608
  557845
  563809
  564416
  566972
  568554
  568555
  569908
  572088
  577502
  579368
  580197
  580298
  581656
  582201
  583271
  583856
  585711
  587176
  588747
  590203
  590740
  596585
  600016
  605856
  618151
  622509
  623357
  623617
  623849
  624122
  624430
  624814
  628390
  628403
  632706
  633788
  647906
  647945
  653911
  663239
  663448
  666535
  671396
  673092
  673661
  675008
  677681
  683508
  698301
  702320
  708390
  709524
  713156
  714503
  720985
  723175
  731866
  733844
  733862
  734825
  734840
  736164
  741310
  747920
  752523
  752538
  757090
  757896
  775788
  778364
  789854
  806860
  814810
]
6 1.88 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "оргазм старый"
]
7 1.69 ms
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.