Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.69 ms
(80.13%)
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
  385919
  391144
  396967
  397316
  403050
  408652
  409045
  416151
  418436
  419600
  421436
  421618
  422401
  424264
  429135
  433954
  437517
  438730
  446879
  447321
  450692
  453945
  455419
  456209
  459801
  465120
  466784
  470422
  474580
  477038
  477262
  479221
  481328
  485585
  485855
  486084
  489744
  491588
  494662
  496428
  501622
  502230
  503919
  503943
  510002
  516218
  520066
  546552
  549075
  549098
  549216
  559474
  563886
  569262
  576216
  577452
  580383
  583313
  588749
  592261
  592946
  594111
  608243
  615647
  618129
  618544
  618834
  619852
  623361
  627778
  630050
  640149
  647357
  652126
  652519
  677726
  696556
  701267
  705791
  708762
  709880
  716529
  717623
  724084
  724898
  726249
  727633
  731695
  740399
  746335
  748386
  751801
  753155
  755426
  755584
  760923
  761076
  761995
  762721
  762986
  763303
  764342
  764947
  774339
  776161
  776988
  778091
  780571
  780932
  786986
  793586
  796873
  799818
  800625
  802829
  813075
  813241
  814963
  819585
  821798
]
22.76 ms
(14.06%)
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
  470422
  763303
  780932
  424264
  453945
  563886
  799818
  491588
  456209
  760923
  391144
  409045
  486084
  433954
  408652
  516218
  746335
  481328
  503943
  485585
  496428
  503919
  774339
  385919
  813075
  559474
  716529
  594111
  748386
  403050
  477038
  576216
  580383
  615647
  802829
  619852
  419600
  592946
  761995
  709880
  819585
  520066
  677726
  701267
  796873
  751801
  764947
  724084
  474580
  450692
  588749
  717623
  429135
  459801
  447321
  489744
  510002
  623361
  618834
  778091
  727633
  813241
  465120
  485855
  421436
  446879
  501622
  546552
  438730
  549075
  569262
  592261
  640149
  726249
  761076
  780571
  762721
  477262
  418436
  396967
  494662
  708762
  549098
  800625
  731695
  762986
  753155
  814963
  397316
  647357
  652126
  455419
  549216
  577452
  776988
  422401
  466784
  502230
  479221
  696556
  608243
  630050
  764342
  416151
  618544
  421618
  821798
  627778
  776161
  786986
  724898
  793586
  755426
  437517
  583313
  740399
  705791
  652519
  618129
  755584
]
2.32 ms
(1.43%)
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
  385919
  391144
  396967
  397316
  403050
  408652
  409045
  416151
  418436
  419600
  421436
  421618
  422401
  424264
  429135
  433954
  437517
  438730
  446879
  447321
  450692
  453945
  455419
  456209
  459801
  465120
  466784
  470422
  474580
  477038
  477262
  479221
  481328
  485585
  485855
  486084
  489744
  491588
  494662
  496428
  501622
  502230
  503919
  503943
  510002
  516218
  520066
  546552
  549075
  549098
  549216
  559474
  563886
  569262
  576216
  577452
  580383
  583313
  588749
  592261
  592946
  594111
  608243
  615647
  618129
  618544
  618834
  619852
  623361
  627778
  630050
  640149
  647357
  652126
  652519
  677726
  696556
  701267
  705791
  708762
  709880
  716529
  717623
  724084
  724898
  726249
  727633
  731695
  740399
  746335
  748386
  751801
  753155
  755426
  755584
  760923
  761076
  761995
  762721
  762986
  763303
  764342
  764947
  774339
  776161
  776988
  778091
  780571
  780932
  786986
  793586
  796873
  799818
  800625
  802829
  813075
  813241
  814963
  819585
  821798
]
1.99 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "little dick fuck"
]
1.84 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "little член секс"
]
1.67 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "little член секс"
]

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.