Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.90 ms
(84.27%)
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
  73774
  109356
  109381
  133707
  257138
  281738
  350614
  387670
  388284
  391213
  391774
  392544
  397625
  399813
  401631
  402731
  434990
  443700
  448367
  451527
  453594
  455212
  457148
  460903
  461997
  462724
  465553
  467763
  468919
  469839
  470750
  474119
  474168
  474206
  476241
  476916
  478904
  479117
  479949
  480994
  481288
  484158
  488176
  488280
  488525
  488833
  494588
  496316
  498234
  498924
  500987
  508135
  509028
  509310
  512305
  513239
  516297
  516912
  518899
  520379
  522263
  525300
  527490
  527790
  528642
  542229
  544098
  544304
  546366
  547274
  548223
  548227
  548245
  548288
  549220
  549769
  549909
  550332
  551161
  551920
  551936
  554068
  554610
  554628
  554669
  555183
  559738
  565811
  566675
  567106
  568717
  570773
  572638
  572754
  574204
  574286
  575424
  579879
  587247
  597097
  600135
  601556
  619419
  628317
  681268
  683293
  701790
  720165
  740097
  758533
  765436
  768286
  769101
  788998
  789676
  816811
  816913
  827922
  828028
]
12.14 ms
(8.26%)
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
  281738
  391774
  399813
  257138
  494588
  551920
  544098
  579879
  453594
  474168
  488176
  551161
  597097
  479117
  828204
  572638
  758533
  542229
  572754
  478904
  498234
  457148
  133707
  392544
  73774
  498924
  462724
  467763
  508135
  518899
  474206
  488280
  554669
  555183
  479949
  476241
  496316
  513239
  546366
  465553
  528642
  468919
  827922
  788998
  601556
  554610
  551936
  575424
  587247
  527490
  470750
  484158
  554628
  554068
  401631
  488833
  740097
  391213
  828028
  548288
  816811
  683293
  480994
  525300
  500987
  527790
  469839
  451527
  516912
  488525
  574286
  509028
  443700
  476916
  565811
  549909
  397625
  720165
  816913
  768286
  388284
  559738
  548227
  109381
  520379
  109356
  570773
  628317
  789676
  765436
  448367
  567106
  600135
  574204
  522263
  512305
  550332
  547274
  544304
  769101
  350614
  568717
  434990
  474119
  460903
  509310
  549220
  549769
  566675
  548223
  548245
  681268
  619419
  402731
  455212
  481288
  516297
  387670
  701790
  461997
]
3.19 ms
(2.17%)
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
  73774
  109356
  109381
  133707
  257138
  281738
  350614
  387670
  388284
  391213
  391774
  392544
  397625
  399813
  401631
  402731
  434990
  443700
  448367
  451527
  453594
  455212
  457148
  460903
  461997
  462724
  465553
  467763
  468919
  469839
  470750
  474119
  474168
  474206
  476241
  476916
  478904
  479117
  479949
  480994
  481288
  484158
  488176
  488280
  488525
  488833
  494588
  496316
  498234
  498924
  500987
  508135
  509028
  509310
  512305
  513239
  516297
  516912
  518899
  520379
  522263
  525300
  527490
  527790
  528642
  542229
  544098
  544304
  546366
  547274
  548223
  548227
  548245
  548288
  549220
  549769
  549909
  550332
  551161
  551920
  551936
  554068
  554610
  554628
  554669
  555183
  559738
  565811
  566675
  567106
  568717
  570773
  572638
  572754
  574204
  574286
  575424
  579879
  587247
  597097
  600135
  601556
  619419
  628317
  681268
  683293
  701790
  720165
  740097
  758533
  765436
  768286
  769101
  788998
  789676
  816811
  816913
  827922
  828028
]
2.44 ms
(1.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "village girl"
]
2.06 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "деревня девушк"
]
1.67 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.11%)
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.