Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.10 ms
(56.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд чулк нижн бел длинные"
]
131.88 ms
(35.97%)
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
  182203
  182206
  402634
  416009
  416448
  417462
  420658
  427008
  430549
  434849
  435570
  439328
  439797
  441027
  443244
  444859
  447352
  450281
  450948
  451222
  452574
  452881
  458910
  459032
  462682
  466639
  466739
  467588
  467598
  468665
  468817
  471676
  476082
  476158
  476674
  478238
  483079
  486004
  490380
  493535
  506674
  506904
  509329
  511275
  512005
  525839
  529069
  532856
  536551
  541442
  546762
  547847
  553684
  559216
  561961
  575978
  579174
  581873
  582848
  583033
  585826
  589333
  589697
  593044
  597482
  598388
  601071
  627147
  631448
  642085
  643080
  648206
  650345
  661364
  664594
  667045
  674181
  677854
  700257
  702338
  703339
  718678
  722388
  722405
  725619
  726946
  733582
  740141
  741343
  752689
  754321
  754436
  755350
  758061
  759370
  766298
  774881
  782281
  782790
  782806
  783048
  783610
  785880
  786898
  788753
  789803
  791042
  793022
  795377
  796946
  801615
  802114
  806455
  807606
  811284
  814024
  814025
  819256
  821808
  822298
]
17.89 ms
(4.88%)
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
  822298
  814024
  532856
  575978
  631448
  597482
  601071
  643080
  807606
  811284
  785880
  793022
  726946
  725619
  754436
  759370
  722388
  782281
  786898
  791042
  801615
  435570
  466739
  439797
  511275
  598388
  468665
  674181
  664594
  677854
  700257
  819256
  430549
  561961
  667045
  450948
  466639
  483079
  444859
  490380
  509329
  452881
  458910
  467588
  427008
  493535
  451222
  525839
  553684
  722405
  783610
  789803
  741343
  416448
  766298
  589697
  447352
  821808
  740141
  702338
  593044
  459032
  506674
  506904
  471676
  182203
  754321
  476082
  752689
  443244
  416009
  581873
  585826
  420658
  476158
  783048
  476674
  547847
  541442
  718678
  627147
  434849
  589333
  402634
  579174
  583033
  450281
  648206
  758061
  452574
  512005
  468817
  559216
  661364
  650345
  782790
  782806
  795377
  733582
  755350
  802114
  806455
  441027
  462682
  478238
  439328
  486004
  417462
  814025
  536551
  703339
  642085
  774881
  788753
  796946
  182206
  467598
  529069
  546762
  582848
]
2.83 ms
(0.77%)
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
  182203
  182206
  402634
  416009
  416448
  417462
  420658
  427008
  430549
  434849
  435570
  439328
  439797
  441027
  443244
  444859
  447352
  450281
  450948
  451222
  452574
  452881
  458910
  459032
  462682
  466639
  466739
  467588
  467598
  468665
  468817
  471676
  476082
  476158
  476674
  478238
  483079
  486004
  490380
  493535
  506674
  506904
  509329
  511275
  512005
  525839
  529069
  532856
  536551
  541442
  546762
  547847
  553684
  559216
  561961
  575978
  579174
  581873
  582848
  583033
  585826
  589333
  589697
  593044
  597482
  598388
  601071
  627147
  631448
  642085
  643080
  648206
  650345
  661364
  664594
  667045
  674181
  677854
  700257
  702338
  703339
  718678
  722388
  722405
  725619
  726946
  733582
  740141
  741343
  752689
  754321
  754436
  755350
  758061
  759370
  766298
  774881
  782281
  782790
  782806
  783048
  783610
  785880
  786898
  788753
  789803
  791042
  793022
  795377
  796946
  801615
  802114
  806455
  807606
  811284
  814024
  814025
  819256
  821808
  822298
]
2.50 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дилдо чулки длинные"
]
1.75 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд чулк нижн бел длинные"
]
1.68 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.