Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
202.92 ms
(88.52%)
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
  7308
  114756
  117755
  148814
  232978
  314552
  375949
  382043
  382353
  385832
  387328
  391493
  391600
  392347
  393672
  395929
  396057
  398064
  398545
  399083
  399354
  400382
  400684
  401085
  401309
  402666
  402682
  404185
  404216
  404554
  404953
  405029
  407378
  409021
  411561
  413264
  415200
  416707
  418690
  422420
  426703
  431314
  432723
  432789
  432796
  444733
  446002
  446534
  447537
  447667
  447690
  447879
  463943
  464177
  470511
  471115
  472110
  472773
  474021
  477596
  479009
  484051
  491776
  492109
  494384
  499936
  517038
  519573
  522020
  528938
  542604
  544421
  552398
  561649
  561858
  597798
  600314
  605850
  619800
  621287
  626597
  637690
  647983
  652247
  652882
  653211
  660444
  665714
  665865
  677345
  678586
  678620
  678981
  691915
  693103
  699631
  702629
  705791
  719214
  722585
  725409
  730751
  736394
  741531
  743232
  747147
  755592
  761092
  766777
  767198
  769904
  770441
  770911
  770925
  779135
  779711
  786327
  788897
  801475
  805941
]
15.99 ms
(6.98%)
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
  416707
  472773
  404554
  463943
  705791
  621287
  385832
  402666
  392347
  470511
  741531
  447690
  431314
  484051
  693103
  401309
  474021
  446534
  544421
  805941
  747147
  400382
  422420
  491776
  665865
  691915
  597798
  619800
  702629
  407378
  561649
  114756
  382353
  395929
  472110
  779711
  148814
  391493
  447667
  499936
  678620
  801475
  494384
  426703
  552398
  413264
  396057
  464177
  479009
  399354
  398545
  387328
  382043
  401085
  398064
  117755
  314552
  432796
  665714
  678981
  605850
  779135
  736394
  770441
  769904
  767198
  626597
  415200
  447879
  652247
  652882
  677345
  678586
  719214
  755592
  770925
  743232
  761092
  418690
  766777
  232978
  404216
  725409
  399083
  409021
  446002
  405029
  411561
  444733
  519573
  471115
  391600
  522020
  528938
  517038
  432723
  647983
  699631
  400684
  542604
  477596
  375949
  402682
  393672
  722585
  660444
  637690
  786327
  432789
  404185
  561858
  653211
  600314
  788897
  730751
  770911
  7308
  447537
  492109
  404953
]
3.09 ms
(1.35%)
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
  7308
  114756
  117755
  148814
  232978
  314552
  375949
  382043
  382353
  385832
  387328
  391493
  391600
  392347
  393672
  395929
  396057
  398064
  398545
  399083
  399354
  400382
  400684
  401085
  401309
  402666
  402682
  404185
  404216
  404554
  404953
  405029
  407378
  409021
  411561
  413264
  415200
  416707
  418690
  422420
  426703
  431314
  432723
  432789
  432796
  444733
  446002
  446534
  447537
  447667
  447690
  447879
  463943
  464177
  470511
  471115
  472110
  472773
  474021
  477596
  479009
  484051
  491776
  492109
  494384
  499936
  517038
  519573
  522020
  528938
  542604
  544421
  552398
  561649
  561858
  597798
  600314
  605850
  619800
  621287
  626597
  637690
  647983
  652247
  652882
  653211
  660444
  665714
  665865
  677345
  678586
  678620
  678981
  691915
  693103
  699631
  702629
  705791
  719214
  722585
  725409
  730751
  736394
  741531
  743232
  747147
  755592
  761092
  766777
  767198
  769904
  770441
  770911
  770925
  779135
  779711
  786327
  788897
  801475
  805941
]
2.07 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful blonde anal"
]
1.83 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая беловолосая анал"
]
1.60 ms
(0.70%)
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.