Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.48 ms
(88.20%)
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
  401226
  404313
  404429
  409105
  409258
  410660
  414871
  414946
  417878
  421009
  427536
  428685
  428892
  445424
  446288
  448707
  449718
  450797
  462490
  464925
  465834
  467343
  467359
  484495
  489971
  492096
  496346
  498501
  509821
  516886
  522168
  522573
  522711
  526728
  532114
  536347
  554899
  554979
  556651
  564780
  571494
  589551
  590101
  598117
  599217
  599997
  601602
  603897
  604854
  606425
  610315
  611330
  611506
  616049
  619775
  622377
  624600
  635115
  640692
  699730
  713065
  727934
  728018
  730933
  731464
  732547
  736261
  736402
  736770
  742880
  747258
  748212
  752596
  756409
  764005
  765477
  765482
  766071
  770630
  771251
  773554
  775803
  775971
  776503
  781112
  783625
  785093
  785426
  788507
  790356
  790614
  790983
  792356
  795163
  797504
  797632
  797637
  798645
  799256
  799413
  802120
  802436
  802505
  803472
  804455
  806104
  807546
  807912
  808626
  808946
  809519
  809723
  810447
  810970
  811081
  811490
  811745
  812791
  813505
  813913
]
15.81 ms
(7.56%)
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
  554979
  564780
  601602
  589551
  599217
  599997
  604854
  610315
  624600
  635115
  640692
  590101
  598117
  606425
  611506
  622377
  775971
  788507
  790356
  790983
  797504
  797637
  799256
  806104
  775803
  776503
  781112
  783625
  798645
  799413
  802120
  802436
  809519
  810447
  810970
  811081
  730933
  742880
  785093
  804455
  807546
  808626
  811490
  811745
  813505
  732547
  736261
  736402
  756409
  765482
  747258
  765477
  771251
  727934
  764005
  766071
  728018
  752596
  770630
  773554
  603897
  699730
  785426
  790614
  792356
  795163
  797632
  802505
  803472
  807912
  808946
  809723
  812791
  446288
  417878
  428685
  448707
  467343
  467359
  410660
  449718
  464925
  414871
  421009
  509821
  496346
  484495
  526728
  522573
  522711
  813913
  536347
  498501
  532114
  554899
  556651
  713065
  571494
  611330
  616049
  619775
  731464
  748212
  736770
  404429
  404313
  409105
  450797
  462490
  427536
  428892
  401226
  409258
  445424
  465834
  414946
  489971
  516886
  492096
  522168
]
2.27 ms
(1.09%)
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
  401226
  404313
  404429
  409105
  409258
  410660
  414871
  414946
  417878
  421009
  427536
  428685
  428892
  445424
  446288
  448707
  449718
  450797
  462490
  464925
  465834
  467343
  467359
  484495
  489971
  492096
  496346
  498501
  509821
  516886
  522168
  522573
  522711
  526728
  532114
  536347
  554899
  554979
  556651
  564780
  571494
  589551
  590101
  598117
  599217
  599997
  601602
  603897
  604854
  606425
  610315
  611330
  611506
  616049
  619775
  622377
  624600
  635115
  640692
  699730
  713065
  727934
  728018
  730933
  731464
  732547
  736261
  736402
  736770
  742880
  747258
  748212
  752596
  756409
  764005
  765477
  765482
  766071
  770630
  771251
  773554
  775803
  775971
  776503
  781112
  783625
  785093
  785426
  788507
  790356
  790614
  790983
  792356
  795163
  797504
  797632
  797637
  798645
  799256
  799413
  802120
  802436
  802505
  803472
  804455
  806104
  807546
  807912
  808626
  808946
  809519
  809723
  810447
  810970
  811081
  811490
  811745
  812791
  813505
  813913
]
1.89 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "lick mom"
]
1.67 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза mom"
]
1.62 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза mom"
]

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.