Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.55 ms
(84.95%)
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
  421871
  426797
  435555
  438615
  443591
  444185
  451609
  453511
  453689
  453865
  454731
  456451
  462830
  464528
  464542
  464732
  470010
  470150
  470343
  470522
  470648
  472784
  474639
  477360
  477365
  478772
  482120
  482257
  482492
  483366
  483388
  483660
  485940
  491119
  492050
  492701
  494567
  495710
  496934
  497936
  498984
  499026
  499028
  500596
  503321
  504163
  504189
  506816
  506827
  507902
  509842
  509998
  512583
  514949
  516090
  516725
  517095
  517117
  518521
  518781
  518795
  519776
  520134
  522215
  522221
  522423
  525871
  526721
  527031
  527033
  529457
  542049
  542746
  542748
  542750
  542753
  542759
  542790
  543960
  546724
  548751
  551553
  551579
  556436
  557938
  557941
  557943
  557948
  557956
  559712
  560486
  564116
  585783
  590543
  590628
  593269
  602506
  603663
  622351
  622832
  625556
  648685
  674495
  741856
  751589
  761141
  764082
  766141
  766146
  796444
  800373
  800442
]
14.75 ms
(9.11%)
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
  557956
  482257
  518781
  498984
  674495
  800373
  522221
  485940
  551553
  564116
  495710
  464732
  519776
  517117
  551579
  557941
  443591
  603663
  520134
  477360
  516090
  494567
  483388
  766141
  497936
  482120
  546724
  751589
  453689
  470343
  527031
  543960
  453511
  500596
  557948
  542790
  464528
  509842
  625556
  472784
  454731
  525871
  470150
  542748
  491119
  557943
  741856
  764082
  590628
  514949
  509998
  527033
  464542
  526721
  590543
  444185
  548751
  542753
  766146
  492701
  499026
  522423
  470648
  483366
  542750
  542746
  496934
  506827
  474639
  542759
  506816
  504163
  761141
  470010
  602506
  456451
  499028
  504189
  512583
  507902
  492050
  522215
  478772
  622832
  559712
  518521
  517095
  503321
  556436
  593269
  529457
  518795
  421871
  482492
  648685
  483660
  800442
  622351
  462830
  435555
  453865
  477365
  585783
  516725
  438615
  451609
  426797
  470522
  796444
  557938
  542049
  560486
]
2.95 ms
(1.82%)
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
  421871
  426797
  435555
  438615
  443591
  444185
  451609
  453511
  453689
  453865
  454731
  456451
  462830
  464528
  464542
  464732
  470010
  470150
  470343
  470522
  470648
  472784
  474639
  477360
  477365
  478772
  482120
  482257
  482492
  483366
  483388
  483660
  485940
  491119
  492050
  492701
  494567
  495710
  496934
  497936
  498984
  499026
  499028
  500596
  503321
  504163
  504189
  506816
  506827
  507902
  509842
  509998
  512583
  514949
  516090
  516725
  517095
  517117
  518521
  518781
  518795
  519776
  520134
  522215
  522221
  522423
  525871
  526721
  527031
  527033
  529457
  542049
  542746
  542748
  542750
  542753
  542759
  542790
  543960
  546724
  548751
  551553
  551579
  556436
  557938
  557941
  557943
  557948
  557956
  559712
  560486
  564116
  585783
  590543
  590628
  593269
  602506
  603663
  622351
  622832
  625556
  648685
  674495
  741856
  751589
  761141
  764082
  766141
  766146
  796444
  800373
  800442
]
1.73 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск вебкамер секс втро"
]
1.71 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian webcam threesome"
]
1.64 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.