Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.73 ms
(52.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal dildo beautiful"
]
160.62 ms
(40.63%)
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
  17093
  96524
  202032
  392333
  396640
  401904
  406171
  416192
  419933
  426592
  427232
  430709
  433507
  436703
  437518
  437925
  438464
  439218
  446238
  448057
  448575
  448851
  450410
  452014
  452809
  458921
  463815
  466404
  470064
  471813
  475414
  476676
  481142
  482632
  484278
  487815
  488537
  491644
  495558
  495559
  495793
  496585
  508133
  509981
  514845
  515358
  515747
  520785
  522307
  527568
  531123
  532963
  533049
  536248
  536388
  536645
  537195
  537236
  537943
  540348
  545488
  561970
  565263
  566863
  569359
  572777
  579523
  582540
  587085
  600021
  600337
  601512
  605333
  612399
  620901
  621252
  628334
  632289
  632628
  633813
  634546
  634565
  634780
  636315
  637442
  639254
  641956
  642775
  644327
  644913
  646824
  647972
  649514
  649566
  651634
  666867
  667748
  672686
  676023
  677432
  700257
  700996
  713876
  719001
  722264
  722692
  743383
  748690
  751452
  751582
  758216
  758615
  766825
  782633
  784054
  787515
  791012
  795690
  808988
  826672
]
19.14 ms
(4.84%)
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
  646824
  566863
  634565
  639254
  766825
  758615
  601512
  791012
  520785
  488537
  515747
  677432
  636315
  446238
  463815
  419933
  481142
  515358
  532963
  651634
  676023
  582540
  628334
  637442
  612399
  600337
  641956
  452809
  649566
  633813
  758216
  448851
  202032
  826672
  448057
  572777
  722264
  700257
  722692
  672686
  569359
  587085
  620901
  644327
  782633
  795690
  808988
  748690
  787515
  751452
  605333
  632289
  514845
  536645
  561970
  579523
  470064
  96524
  396640
  401904
  496585
  536388
  509981
  527568
  437518
  437925
  565263
  713876
  743383
  751582
  17093
  471813
  439218
  537943
  484278
  642775
  436703
  426592
  487815
  491644
  452014
  537236
  531123
  545488
  600021
  634780
  466404
  475414
  508133
  522307
  450410
  430709
  495558
  495793
  634546
  621252
  495559
  784054
  406171
  482632
  427232
  476676
  644913
  536248
  647972
  649514
  667748
  632628
  416192
  448575
  392333
  438464
  433507
  458921
  537195
  533049
  540348
  700996
  719001
  666867
]
3.34 ms
(0.85%)
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
  17093
  96524
  202032
  392333
  396640
  401904
  406171
  416192
  419933
  426592
  427232
  430709
  433507
  436703
  437518
  437925
  438464
  439218
  446238
  448057
  448575
  448851
  450410
  452014
  452809
  458921
  463815
  466404
  470064
  471813
  475414
  476676
  481142
  482632
  484278
  487815
  488537
  491644
  495558
  495559
  495793
  496585
  508133
  509981
  514845
  515358
  515747
  520785
  522307
  527568
  531123
  532963
  533049
  536248
  536388
  536645
  537195
  537236
  537943
  540348
  545488
  561970
  565263
  566863
  569359
  572777
  579523
  582540
  587085
  600021
  600337
  601512
  605333
  612399
  620901
  621252
  628334
  632289
  632628
  633813
  634546
  634565
  634780
  636315
  637442
  639254
  641956
  642775
  644327
  644913
  646824
  647972
  649514
  649566
  651634
  666867
  667748
  672686
  676023
  677432
  700257
  700996
  713876
  719001
  722264
  722692
  743383
  748690
  751452
  751582
  758216
  758615
  766825
  782633
  784054
  787515
  791012
  795690
  808988
  826672
]
1.91 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал дилд красивая"
]
1.84 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал дилд красивая"
]
1.72 ms
(0.43%)
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.