Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.99 ms
(81.96%)
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
  418130
  418268
  420299
  422140
  427147
  428223
  434771
  435606
  437369
  439240
  441527
  444853
  449946
  451785
  452729
  472619
  473711
  475729
  478988
  478992
  485283
  490397
  494864
  495602
  499705
  500779
  503576
  505095
  505096
  505771
  513615
  515548
  522278
  524352
  527956
  529393
  529504
  533275
  537760
  539265
  540139
  544066
  545224
  547774
  547776
  547779
  550531
  554625
  556290
  557706
  562585
  573485
  573983
  575321
  576998
  581092
  582751
  587283
  589187
  589507
  589886
  602738
  613797
  628702
  630732
  639140
  640368
  650305
  653649
  660014
  662518
  666426
  666432
  666650
  666734
  669852
  672407
  678600
  682986
  702301
  710493
  714086
  716418
  725224
  734838
  735974
  736674
  742457
  742622
  742817
  744227
  746094
  746235
  747444
  751422
  752647
  758097
  761552
  766939
  768157
  768258
  768871
  773063
  784094
  784948
  785538
  785816
  786600
  787556
  787808
  791516
  794015
  795330
  795812
  796047
  801068
  806955
  810133
  812447
  820190
]
19.64 ms
(11.83%)
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
  529393
  537760
  545224
  678600
  716418
  650305
  653649
  669852
  682986
  710493
  630732
  589187
  785816
  795330
  796047
  812447
  725224
  752647
  761552
  784094
  810133
  736674
  746094
  768258
  735974
  744227
  768871
  602738
  787808
  441527
  418268
  422140
  437369
  820190
  485283
  527956
  539265
  472619
  575321
  576998
  547774
  573983
  666426
  672407
  639140
  785538
  786600
  794015
  806955
  766939
  751422
  702301
  420299
  505771
  435606
  547779
  557706
  547776
  503576
  513615
  444853
  550531
  475729
  452729
  473711
  540139
  495602
  573485
  556290
  666734
  587283
  589886
  747444
  734838
  742457
  746235
  758097
  427147
  494864
  500779
  428223
  439240
  478988
  524352
  515548
  522278
  533275
  544066
  562585
  581092
  662518
  666650
  660014
  714086
  666432
  582751
  613797
  589507
  628702
  640368
  784948
  742622
  791516
  773063
  768157
  742817
  787556
  795812
  801068
  434771
  478992
  529504
  490397
  499705
  418130
  449946
  451785
  505096
  505095
  554625
]
3.03 ms
(1.82%)
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
  418130
  418268
  420299
  422140
  427147
  428223
  434771
  435606
  437369
  439240
  441527
  444853
  449946
  451785
  452729
  472619
  473711
  475729
  478988
  478992
  485283
  490397
  494864
  495602
  499705
  500779
  503576
  505095
  505096
  505771
  513615
  515548
  522278
  524352
  527956
  529393
  529504
  533275
  537760
  539265
  540139
  544066
  545224
  547774
  547776
  547779
  550531
  554625
  556290
  557706
  562585
  573485
  573983
  575321
  576998
  581092
  582751
  587283
  589187
  589507
  589886
  602738
  613797
  628702
  630732
  639140
  640368
  650305
  653649
  660014
  662518
  666426
  666432
  666650
  666734
  669852
  672407
  678600
  682986
  702301
  710493
  714086
  716418
  725224
  734838
  735974
  736674
  742457
  742622
  742817
  744227
  746094
  746235
  747444
  751422
  752647
  758097
  761552
  766939
  768157
  768258
  768871
  773063
  784094
  784948
  785538
  785816
  786600
  787556
  787808
  791516
  794015
  795330
  795812
  796047
  801068
  806955
  810133
  812447
  820190
]
2.02 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "крупныйпла сквирт оргазм"
]
1.77 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "крупный план сквирт"
]
1.53 ms
(0.92%)
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.