Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.42 ms
(89.76%)
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
  378600
  534044
  544034
  720093
  722955
  724756
  724985
  725742
  726749
  727005
  728983
  729111
  732653
  733187
  734255
  734954
  735589
  736158
  736739
  736892
  737388
  739977
  740865
  744724
  746174
  747251
  747638
  747965
  747997
  751287
  752082
  752182
  752396
  755056
  757369
  757941
  758412
  758663
  759774
  760630
  760949
  761920
  763186
  764609
  764695
  765420
  766187
  766497
  767487
  767535
  767620
  767993
  768081
  768328
  768343
  768518
  768750
  769035
  769619
  770506
  770571
  771204
  771561
  771898
  771908
  772866
  773390
  773617
  773640
  773773
  775325
  775460
  775654
  776355
  778064
  778073
  778938
  779662
  781142
  781528
  781590
  782358
  783372
  783440
  783716
  784614
  786332
  787847
  788643
  788663
  790586
  790680
  790904
  791135
  792321
  792413
  792972
  793055
  793989
  795646
  796309
  796480
  796660
  796750
  797232
  797850
  800431
  800897
  801207
  801830
  802077
  803432
  807556
  810054
  811346
  813611
  813680
  814658
]
10.39 ms
(5.54%)
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
  736739
  758412
  768328
  770571
  724756
  735589
  739977
  744724
  747251
  752082
  758663
  771204
  771309
  726749
  733187
  747638
  747997
  751287
  752182
  757941
  759774
  763186
  767535
  767620
  768518
  768750
  769035
  771561
  771898
  773390
  725742
  737388
  740865
  770506
  771908
  772866
  773640
  773773
  776355
  778064
  778073
  778938
  784614
  786332
  788663
  792972
  795646
  800431
  800897
  736158
  760630
  544034
  722955
  775654
  732653
  752396
  773617
  792321
  736892
  768343
  769619
  729111
  767993
  787847
  378600
  534044
  781590
  814658
  813611
  813680
  720093
  775325
  779662
  781142
  790586
  790680
  790904
  791135
  792413
  793989
  796309
  796480
  796750
  801830
  811346
  775460
  781528
  782358
  783440
  783716
  796660
  797232
  803432
  734255
  766497
  768081
  783372
  788643
  793055
  797850
  801207
  802077
  807556
  810054
  746174
  747965
  755056
  761920
  764695
  727005
  728983
  734954
  764609
  766187
  765420
  767487
  771135
  724985
  757369
  760949
]
2.78 ms
(1.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
  378600
  534044
  544034
  720093
  722955
  724756
  724985
  725742
  726749
  727005
  728983
  729111
  732653
  733187
  734255
  734954
  735589
  736158
  736739
  736892
  737388
  739977
  740865
  744724
  746174
  747251
  747638
  747965
  747997
  751287
  752082
  752182
  752396
  755056
  757369
  757941
  758412
  758663
  759774
  760630
  760949
  761920
  763186
  764609
  764695
  765420
  766187
  766497
  767487
  767535
  767620
  767993
  768081
  768328
  768343
  768518
  768750
  769035
  769619
  770506
  770571
  771204
  771561
  771898
  771908
  772866
  773390
  773617
  773640
  773773
  775325
  775460
  775654
  776355
  778064
  778073
  778938
  779662
  781142
  781528
  781590
  782358
  783372
  783440
  783716
  784614
  786332
  787847
  788643
  788663
  790586
  790680
  790904
  791135
  792321
  792413
  792972
  793055
  793989
  795646
  796309
  796480
  796660
  796750
  797232
  797850
  800431
  800897
  801207
  801830
  802077
  803432
  807556
  810054
  811346
  813611
  813680
  814658
]
1.83 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm homemade"
]
1.55 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм домашн любительск"
]
1.45 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.23 ms
(0.66%)
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.