Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.63 ms
(83.43%)
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
  3522
  77381
  108138
  147073
  232048
  260576
  385467
  385912
  386042
  390678
  391632
  392225
  392570
  397393
  397407
  397979
  424263
  425563
  431608
  455062
  456742
  466830
  468349
  476470
  482125
  488385
  488510
  491188
  493076
  494662
  497621
  505291
  507114
  507460
  511306
  514668
  514760
  516084
  516653
  521781
  525027
  527420
  528236
  535515
  536953
  541017
  545034
  548267
  551665
  551886
  556668
  560435
  563724
  571728
  572250
  578745
  578796
  579575
  579877
  580016
  580049
  584365
  585250
  602702
  603809
  604727
  612242
  613907
  616466
  618592
  619926
  620533
  623024
  625558
  628240
  642130
  646486
  654290
  667092
  671241
  679658
  680459
  689172
  689937
  689938
  697604
  708523
  709505
  714951
  716013
  716452
  720896
  722130
  726124
  729220
  730165
  731447
  732600
  733944
  735658
  736149
  739360
  743566
  759911
  759965
  764983
  780773
  783042
  791112
  793479
  793756
  793826
  794724
  795860
  795975
  796025
  797132
  799893
  801490
  808304
]
18.44 ms
(10.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
  392225
  545034
  729220
  602702
  572250
  455062
  732600
  491188
  667092
  716452
  799893
  726124
  697604
  646486
  466830
  603809
  468349
  525027
  797132
  560435
  516653
  527420
  528236
  563724
  511306
  514760
  516084
  739360
  604727
  671241
  482125
  551665
  619926
  260576
  791112
  497621
  424263
  720896
  628240
  722130
  108138
  391632
  793479
  679658
  425563
  731447
  578796
  385467
  795975
  735658
  556668
  385912
  625558
  392570
  733944
  795860
  3522
  578745
  780773
  488385
  580016
  743566
  507460
  796025
  386042
  716013
  623024
  580049
  147073
  794724
  397393
  618592
  736149
  689938
  801490
  783042
  507114
  541017
  397979
  612242
  431608
  808304
  232048
  390678
  579877
  514668
  730165
  613907
  793756
  77381
  488510
  689937
  714951
  548267
  642130
  764983
  521781
  397407
  551886
  493076
  536953
  476470
  579575
  620533
  708523
  759911
  494662
  654290
  535515
  571728
  505291
  680459
  585250
  616466
  759965
  456742
  709505
  793826
  689172
  584365
]
3.18 ms
(1.83%)
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
  3522
  77381
  108138
  147073
  232048
  260576
  385467
  385912
  386042
  390678
  391632
  392225
  392570
  397393
  397407
  397979
  424263
  425563
  431608
  455062
  456742
  466830
  468349
  476470
  482125
  488385
  488510
  491188
  493076
  494662
  497621
  505291
  507114
  507460
  511306
  514668
  514760
  516084
  516653
  521781
  525027
  527420
  528236
  535515
  536953
  541017
  545034
  548267
  551665
  551886
  556668
  560435
  563724
  571728
  572250
  578745
  578796
  579575
  579877
  580016
  580049
  584365
  585250
  602702
  603809
  604727
  612242
  613907
  616466
  618592
  619926
  620533
  623024
  625558
  628240
  642130
  646486
  654290
  667092
  671241
  679658
  680459
  689172
  689937
  689938
  697604
  708523
  709505
  714951
  716013
  716452
  720896
  722130
  726124
  729220
  730165
  731447
  732600
  733944
  735658
  736149
  739360
  743566
  759911
  759965
  764983
  780773
  783042
  791112
  793479
  793756
  793826
  794724
  795860
  795975
  796025
  797132
  799893
  801490
  808304
]
2.26 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife fuck sperm"
]
1.67 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен секс сперм"
]
1.51 ms
(0.87%)
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.