Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.86 ms
(84.16%)
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
  7170
  43271
  58701
  96393
  96946
  188610
  193870
  341546
  368131
  385946
  388723
  388912
  390574
  391939
  392111
  392177
  396018
  409367
  424841
  427202
  447992
  460292
  460830
  470584
  471385
  478541
  479071
  480073
  481328
  489241
  493088
  510426
  511392
  535726
  538824
  544748
  556674
  562829
  566187
  566463
  576685
  583591
  583730
  599993
  600359
  602684
  603169
  603682
  614220
  628347
  631944
  647602
  654287
  661447
  662069
  663510
  668161
  673613
  681682
  686024
  686860
  690827
  692806
  699549
  703062
  703523
  703540
  705278
  707306
  709640
  709942
  713091
  716789
  718909
  719004
  720867
  720873
  720877
  720911
  721113
  726120
  730797
  733071
  742452
  742804
  742911
  743066
  746366
  747159
  759766
  767162
  775473
  788783
  788969
  790955
  793616
  794557
  799951
  801899
  803645
  804504
  805586
  805589
  805597
  805599
  815109
  815557
  816313
  816484
  816502
  817156
  817416
  817537
  817546
  817692
  817860
  817866
  818169
  818309
  818852
]
21.26 ms
(11.41%)
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
  788783
  479071
  481328
  614220
  742452
  707306
  817546
  801899
  733071
  816484
  743066
  804504
  817692
  805586
  805597
  815109
  713091
  631944
  562829
  96946
  718909
  720867
  385946
  692806
  493088
  818852
  427202
  719004
  368131
  341546
  583591
  392111
  767162
  556674
  603169
  654287
  742911
  730797
  58701
  709640
  746366
  703540
  799951
  721113
  391939
  566463
  747159
  775473
  392177
  817416
  690827
  686860
  720877
  703523
  600359
  759766
  390574
  817860
  647602
  7170
  538824
  544748
  662069
  816502
  805589
  703062
  720911
  535726
  409367
  818309
  628347
  815557
  817537
  583730
  663510
  705278
  673613
  805599
  709942
  716789
  790955
  460830
  470584
  471385
  599993
  794557
  576685
  603682
  742804
  793616
  388912
  681682
  424841
  193870
  447992
  566187
  188610
  478541
  510426
  699549
  602684
  818169
  511392
  480073
  460292
  96393
  43271
  388723
  396018
  726120
  720873
  489241
  817156
  817866
  788969
  803645
  816313
  661447
  668161
  686024
]
2.27 ms
(1.22%)
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
  7170
  43271
  58701
  96393
  96946
  188610
  193870
  341546
  368131
  385946
  388723
  388912
  390574
  391939
  392111
  392177
  396018
  409367
  424841
  427202
  447992
  460292
  460830
  470584
  471385
  478541
  479071
  480073
  481328
  489241
  493088
  510426
  511392
  535726
  538824
  544748
  556674
  562829
  566187
  566463
  576685
  583591
  583730
  599993
  600359
  602684
  603169
  603682
  614220
  628347
  631944
  647602
  654287
  661447
  662069
  663510
  668161
  673613
  681682
  686024
  686860
  690827
  692806
  699549
  703062
  703523
  703540
  705278
  707306
  709640
  709942
  713091
  716789
  718909
  719004
  720867
  720873
  720877
  720911
  721113
  726120
  730797
  733071
  742452
  742804
  742911
  743066
  746366
  747159
  759766
  767162
  775473
  788783
  788969
  790955
  793616
  794557
  799951
  801899
  803645
  804504
  805586
  805589
  805597
  805599
  815109
  815557
  816313
  816484
  816502
  817156
  817416
  817537
  817546
  817692
  817860
  817866
  818169
  818309
  818852
]
1.68 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин мжм секс втро"
]
1.59 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин мжм секс втро"
]
1.53 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамаши мжм"
]
1.19 ms
(0.64%)
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.