Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.40 ms
(84.56%)
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
  7329
  117388
  385225
  404696
  406083
  407313
  412984
  432789
  441577
  444372
  446259
  448349
  453793
  457233
  459648
  461680
  463743
  464874
  467834
  468359
  468398
  468434
  475837
  476142
  482075
  483611
  484717
  492243
  493684
  497730
  497732
  500620
  510332
  511431
  519925
  530849
  531100
  533062
  536682
  537754
  540422
  545395
  548162
  555082
  564297
  564524
  564557
  582097
  591747
  592644
  599872
  600204
  600358
  604293
  614142
  624196
  626292
  626293
  626401
  631525
  632082
  632605
  634527
  634536
  634563
  637010
  637115
  646868
  672679
  672952
  682507
  692718
  692817
  693359
  695939
  698407
  698728
  699581
  700031
  712719
  716071
  716189
  717656
  720076
  721118
  722858
  722925
  731960
  737561
  739389
  740849
  743325
  744975
  746694
  747439
  747454
  750304
  756091
  756990
  758498
  760942
  761012
  761163
  761199
  761203
  761491
  761600
  766788
  766835
  767163
  769867
  772449
  774691
  785580
  796126
  805527
  810214
  811407
  813899
  820927
]
19.80 ms
(10.57%)
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
  743325
  760942
  739389
  740849
  766788
  796126
  631525
  646868
  746694
  722858
  716189
  767163
  476142
  484717
  511431
  468359
  483611
  510332
  693359
  761491
  769867
  756091
  700031
  692817
  592644
  772449
  475837
  497732
  758498
  626292
  407313
  672679
  533062
  634563
  721118
  712719
  637115
  632605
  692718
  626401
  600358
  634536
  761600
  756990
  699581
  761199
  457233
  761012
  805527
  530849
  695939
  716071
  811407
  813899
  468434
  493684
  468398
  537754
  492243
  564297
  672952
  682507
  720076
  632082
  774691
  747439
  766835
  117388
  519925
  698407
  548162
  555082
  564557
  591747
  737561
  750304
  761203
  717656
  722925
  432789
  406083
  637010
  461680
  497730
  459648
  545395
  7329
  412984
  564524
  582097
  624196
  785580
  744975
  463743
  761163
  453793
  467834
  464874
  540422
  536682
  599872
  634527
  444372
  446259
  448349
  500620
  531100
  604293
  614142
  626293
  698728
  404696
  482075
  441577
  820927
  600204
  810214
  747454
  731960
  385225
]
2.63 ms
(1.41%)
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
  7329
  117388
  385225
  404696
  406083
  407313
  412984
  432789
  441577
  444372
  446259
  448349
  453793
  457233
  459648
  461680
  463743
  464874
  467834
  468359
  468398
  468434
  475837
  476142
  482075
  483611
  484717
  492243
  493684
  497730
  497732
  500620
  510332
  511431
  519925
  530849
  531100
  533062
  536682
  537754
  540422
  545395
  548162
  555082
  564297
  564524
  564557
  582097
  591747
  592644
  599872
  600204
  600358
  604293
  614142
  624196
  626292
  626293
  626401
  631525
  632082
  632605
  634527
  634536
  634563
  637010
  637115
  646868
  672679
  672952
  682507
  692718
  692817
  693359
  695939
  698407
  698728
  699581
  700031
  712719
  716071
  716189
  717656
  720076
  721118
  722858
  722925
  731960
  737561
  739389
  740849
  743325
  744975
  746694
  747439
  747454
  750304
  756091
  756990
  758498
  760942
  761012
  761163
  761199
  761203
  761491
  761600
  766788
  766835
  767163
  769867
  772449
  774691
  785580
  796126
  805527
  810214
  811407
  813899
  820927
]
1.69 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal deep big"
]
1.67 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал deep большие"
]
1.54 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал deep большие"
]

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.