Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.57 ms
(80.23%)
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
  388180
  391926
  392019
  397437
  409937
  421582
  424195
  428169
  428171
  428229
  428282
  429958
  434324
  435557
  435591
  435593
  436054
  439010
  439059
  439514
  439993
  440891
  440995
  441099
  441160
  448431
  449377
  453400
  453601
  455015
  456222
  457512
  458819
  462553
  462840
  467636
  467872
  467886
  478010
  480502
  481418
  490996
  494547
  495467
  505317
  505575
  505600
  508556
  512363
  517804
  519362
  519699
  521139
  541275
  541377
  541767
  547785
  547788
  555008
  555023
  556873
  556881
  556901
  558247
  560533
  571726
  581098
  584046
  588071
  591239
  591333
  605378
  605711
  610256
  614557
  619272
  619710
  669880
  703574
  705119
  705571
  705641
  712627
  719461
  735260
  735554
  736307
  738501
  740357
  741684
  742703
  743893
  744408
  745082
  750723
  751567
  758163
  765804
  781250
  782844
  782846
  784294
  792689
  792706
  792712
  792713
  792715
  792726
  792730
  792740
  792749
  792761
  794307
  796332
  801606
  805341
  811771
  811785
  825439
  827653
]
23.57 ms
(12.99%)
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
  462553
  519699
  435593
  397437
  441099
  619272
  610256
  801606
  792713
  796332
  805341
  744408
  750723
  743893
  784294
  435591
  605711
  456222
  467886
  434324
  457512
  428229
  505575
  505600
  388180
  439514
  462840
  440891
  453601
  541275
  825439
  827653
  508556
  560533
  547785
  669880
  619710
  782846
  794307
  792730
  738501
  740357
  792689
  792740
  811785
  758163
  735260
  742703
  705571
  792706
  429958
  449377
  494547
  467636
  547788
  421582
  441160
  409937
  428171
  512363
  735554
  571726
  605378
  614557
  453400
  467872
  428282
  439010
  439059
  751567
  478010
  495467
  521139
  541377
  703574
  712627
  705119
  705641
  556901
  781250
  782844
  811771
  792761
  736307
  741684
  581098
  490996
  440995
  480502
  558247
  556873
  792726
  745082
  765804
  792712
  792715
  792749
  519362
  719461
  458819
  584046
  439993
  555008
  555023
  588071
  591239
  591333
  392019
  436054
  556881
  424195
  391926
  455015
  428169
  435557
  481418
  541767
  505317
  517804
  448431
]
4.51 ms
(2.48%)
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
  388180
  391926
  392019
  397437
  409937
  421582
  424195
  428169
  428171
  428229
  428282
  429958
  434324
  435557
  435591
  435593
  436054
  439010
  439059
  439514
  439993
  440891
  440995
  441099
  441160
  448431
  449377
  453400
  453601
  455015
  456222
  457512
  458819
  462553
  462840
  467636
  467872
  467886
  478010
  480502
  481418
  490996
  494547
  495467
  505317
  505575
  505600
  508556
  512363
  517804
  519362
  519699
  521139
  541275
  541377
  541767
  547785
  547788
  555008
  555023
  556873
  556881
  556901
  558247
  560533
  571726
  581098
  584046
  588071
  591239
  591333
  605378
  605711
  610256
  614557
  619272
  619710
  669880
  703574
  705119
  705571
  705641
  712627
  719461
  735260
  735554
  736307
  738501
  740357
  741684
  742703
  743893
  744408
  745082
  750723
  751567
  758163
  765804
  781250
  782844
  782846
  784294
  792689
  792706
  792712
  792713
  792715
  792726
  792730
  792740
  792749
  792761
  794307
  796332
  801606
  805341
  811771
  811785
  825439
  827653
]
2.20 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife fisting"
]
2.14 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен фистинг"
]
1.46 ms
(0.80%)
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.