Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.77 ms
(82.04%)
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
  242127
  406935
  416098
  417064
  419113
  419783
  419882
  420223
  421219
  421238
  421357
  423563
  424505
  424675
  425028
  425116
  425799
  425829
  426409
  427147
  428451
  428477
  429875
  430422
  430644
  431015
  431111
  431112
  431133
  431376
  433669
  433966
  434282
  442830
  442994
  443704
  443796
  444238
  446275
  446718
  447458
  447890
  448333
  448798
  451552
  451950
  452082
  453113
  454550
  454994
  457762
  464935
  465307
  468955
  469017
  470254
  473899
  476123
  476399
  477885
  477888
  477890
  481581
  481688
  482304
  483152
  487632
  491478
  491986
  492121
  492916
  495401
  495608
  496118
  509664
  513029
  516102
  518931
  519093
  519215
  522914
  522977
  526757
  527454
  535021
  541408
  541636
  541895
  548519
  552319
  557207
  559453
  559692
  561351
  562106
  563894
  564429
  569558
  581398
  582617
  584759
  587098
  596534
  605467
  607293
  607355
  614401
  617633
  633165
  647860
  650844
  668549
  674368
  715710
  759036
  789665
  807363
  809396
  815600
  823990
]
20.26 ms
(11.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
  421357
  421238
  431015
  431133
  433966
  451950
  477885
  425116
  451552
  519215
  491986
  823990
  715710
  759036
  454550
  406935
  425799
  417064
  421219
  442994
  815600
  465307
  477888
  535021
  527454
  513029
  464935
  562106
  541895
  557207
  559692
  561351
  541636
  581398
  584759
  650844
  563894
  582617
  596534
  807363
  607355
  614401
  419113
  430644
  433669
  448798
  424505
  447890
  454994
  481581
  419882
  425028
  491478
  509664
  518931
  487632
  495401
  496118
  519093
  495608
  516102
  564429
  242127
  453113
  569558
  424675
  423563
  428477
  434282
  428451
  447458
  457762
  476123
  476399
  483152
  446275
  468955
  482304
  522914
  559453
  541408
  548519
  552319
  668549
  674368
  607293
  633165
  587098
  605467
  617633
  789665
  809396
  419783
  425829
  443704
  443796
  473899
  481688
  420223
  469017
  426409
  446718
  470254
  416098
  444238
  448333
  431111
  431376
  492121
  522977
  647860
  429875
  427147
  526757
  430422
  431112
  442830
  452082
  477890
  492916
]
3.19 ms
(1.89%)
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
  242127
  406935
  416098
  417064
  419113
  419783
  419882
  420223
  421219
  421238
  421357
  423563
  424505
  424675
  425028
  425116
  425799
  425829
  426409
  427147
  428451
  428477
  429875
  430422
  430644
  431015
  431111
  431112
  431133
  431376
  433669
  433966
  434282
  442830
  442994
  443704
  443796
  444238
  446275
  446718
  447458
  447890
  448333
  448798
  451552
  451950
  452082
  453113
  454550
  454994
  457762
  464935
  465307
  468955
  469017
  470254
  473899
  476123
  476399
  477885
  477888
  477890
  481581
  481688
  482304
  483152
  487632
  491478
  491986
  492121
  492916
  495401
  495608
  496118
  509664
  513029
  516102
  518931
  519093
  519215
  522914
  522977
  526757
  527454
  535021
  541408
  541636
  541895
  548519
  552319
  557207
  559453
  559692
  561351
  562106
  563894
  564429
  569558
  581398
  582617
  584759
  587098
  596534
  605467
  607293
  607355
  614401
  617633
  633165
  647860
  650844
  668549
  674368
  715710
  759036
  789665
  807363
  809396
  815600
  823990
]
1.91 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shaving hairy pussy"
]
1.85 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shaving волосатая pussy"
]
1.62 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shaving волосатая pussy"
]
1.53 ms
(0.91%)
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.