Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.83 ms
(90.00%)
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
  480692
  485990
  509967
  513935
  527159
  534677
  535557
  538880
  546281
  578759
  583680
  585583
  588849
  589325
  594911
  606996
  609188
  611782
  615411
  616137
  618135
  622944
  627514
  627772
  628739
  632503
  633867
  635726
  636438
  637364
  638430
  639078
  639149
  639394
  641101
  642900
  644100
  667796
  669444
  685391
  698238
  713449
  715838
  719635
  721900
  724971
  726370
  726929
  728719
  728735
  729290
  729669
  732626
  732725
  732806
  734247
  735291
  735489
  735667
  735885
  736705
  736765
  736780
  736886
  737686
  739280
  739376
  740749
  740905
  741023
  741111
  741766
  742718
  745142
  745176
  745584
  745711
  747762
  748157
  749679
  753928
  758321
  759623
  761014
  761021
  762009
  769257
  769429
  770706
  773830
  777198
  780876
  781334
  782334
  782359
  783567
  785282
  785302
  787101
  787235
  787470
  791936
  791988
  792804
  793880
  794368
  794859
  795122
  795615
  798865
  802754
  804307
  804866
  805334
  806300
  809147
  809183
  812407
  812520
  813743
]
12.22 ms
(5.34%)
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
  546281
  588849
  611782
  616137
  632503
  636438
  637364
  639078
  641101
  589325
  594911
  609188
  615411
  618135
  622944
  644100
  627772
  628739
  606996
  627514
  639149
  783567
  785302
  791988
  793880
  794859
  795615
  798865
  802754
  804307
  805334
  812407
  781334
  785282
  791936
  792804
  809183
  729290
  734247
  735489
  735667
  739280
  739376
  758321
  769257
  770706
  787101
  787235
  795122
  806300
  812520
  729669
  735291
  736765
  736780
  741111
  759623
  769429
  724971
  736705
  737686
  742718
  745176
  745584
  745711
  753928
  762009
  726370
  732626
  732725
  745142
  747762
  773830
  728735
  735885
  736886
  740749
  740905
  741023
  749679
  761014
  761021
  635726
  698238
  721900
  777198
  782334
  782359
  804866
  585583
  732806
  685391
  639394
  642900
  633867
  748157
  715838
  713449
  638430
  728719
  726929
  741766
  583680
  809147
  719635
  667796
  669444
  787470
  578759
  780876
  794368
  813743
  480692
  485990
  509967
  538880
  513935
  527159
  534677
  535557
]
3.59 ms
(1.57%)
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
  480692
  485990
  509967
  513935
  527159
  534677
  535557
  538880
  546281
  578759
  583680
  585583
  588849
  589325
  594911
  606996
  609188
  611782
  615411
  616137
  618135
  622944
  627514
  627772
  628739
  632503
  633867
  635726
  636438
  637364
  638430
  639078
  639149
  639394
  641101
  642900
  644100
  667796
  669444
  685391
  698238
  713449
  715838
  719635
  721900
  724971
  726370
  726929
  728719
  728735
  729290
  729669
  732626
  732725
  732806
  734247
  735291
  735489
  735667
  735885
  736705
  736765
  736780
  736886
  737686
  739280
  739376
  740749
  740905
  741023
  741111
  741766
  742718
  745142
  745176
  745584
  745711
  747762
  748157
  749679
  753928
  758321
  759623
  761014
  761021
  762009
  769257
  769429
  770706
  773830
  777198
  780876
  781334
  782334
  782359
  783567
  785282
  785302
  787101
  787235
  787470
  791936
  791988
  792804
  793880
  794368
  794859
  795122
  795615
  798865
  802754
  804307
  804866
  805334
  806300
  809147
  809183
  812407
  812520
  813743
]
2.16 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "шлюх жен"
]
1.71 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "шлюхи жены"
]
1.61 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "шлюх жен"
]
1.58 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.