Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.13 ms
(81.09%)
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
  16971
  389418
  389667
  417177
  418597
  419192
  420818
  421157
  421570
  424013
  424505
  426035
  427209
  427851
  432296
  434492
  436703
  443733
  444924
  446064
  452331
  454731
  461210
  469690
  476797
  477355
  480757
  483057
  483377
  483777
  487200
  488560
  500300
  500429
  500504
  501173
  502477
  504268
  505920
  511838
  514230
  514652
  514660
  516078
  516684
  518012
  519295
  520270
  521784
  521813
  522138
  522307
  526257
  526293
  526492
  528044
  528093
  530661
  532560
  536744
  537236
  541832
  543609
  547478
  547485
  548837
  551736
  554721
  555062
  556883
  563134
  565256
  576384
  583425
  583997
  585446
  590281
  590854
  590906
  593470
  595209
  597841
  601140
  601400
  603685
  603724
  605117
  618874
  619293
  623736
  625648
  629963
  633136
  634782
  635838
  639258
  646004
  653524
  660375
  660399
  665957
  667646
  669058
  669074
  671052
  689613
  699621
  711904
  719350
  726315
  726543
  726553
  742428
  747140
  780375
  797560
  798930
  812790
]
27.26 ms
(13.63%)
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
  519295
  505920
  500429
  532560
  547478
  669074
  671052
  635838
  699621
  500504
  488560
  514230
  555062
  556883
  625648
  633136
  436703
  446064
  554721
  526492
  424013
  389667
  427851
  576384
  583425
  595209
  520270
  526257
  726315
  742428
  719350
  483057
  483377
  526293
  543609
  548837
  660399
  665957
  590854
  597841
  502477
  432296
  421157
  501173
  528044
  660375
  812790
  426035
  603724
  487200
  593470
  747140
  500300
  483777
  419192
  521813
  427209
  798930
  514652
  563134
  780375
  389418
  452331
  547485
  646004
  590281
  601400
  797560
  424505
  590906
  605117
  585446
  418597
  454731
  603685
  469690
  511838
  522307
  669058
  434492
  443733
  667646
  623736
  634782
  726543
  726553
  601140
  530661
  516078
  417177
  477355
  619293
  514660
  583997
  16971
  528093
  516684
  565256
  476797
  541832
  689613
  444924
  480757
  537236
  653524
  420818
  461210
  521784
  518012
  551736
  629963
  421570
  639258
  711904
  536744
  618874
  504268
  522138
]
3.07 ms
(1.54%)
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
  16971
  389418
  389667
  417177
  418597
  419192
  420818
  421157
  421570
  424013
  424505
  426035
  427209
  427851
  432296
  434492
  436703
  443733
  444924
  446064
  452331
  454731
  461210
  469690
  476797
  477355
  480757
  483057
  483377
  483777
  487200
  488560
  500300
  500429
  500504
  501173
  502477
  504268
  505920
  511838
  514230
  514652
  514660
  516078
  516684
  518012
  519295
  520270
  521784
  521813
  522138
  522307
  526257
  526293
  526492
  528044
  528093
  530661
  532560
  536744
  537236
  541832
  543609
  547478
  547485
  548837
  551736
  554721
  555062
  556883
  563134
  565256
  576384
  583425
  583997
  585446
  590281
  590854
  590906
  593470
  595209
  597841
  601140
  601400
  603685
  603724
  605117
  618874
  619293
  623736
  625648
  629963
  633136
  634782
  635838
  639258
  646004
  653524
  660375
  660399
  665957
  667646
  669058
  669074
  671052
  689613
  699621
  711904
  719350
  726315
  726543
  726553
  742428
  747140
  780375
  797560
  798930
  812790
]
2.13 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "two girl masturbation"
]
1.87 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "two девушк мастурбац"
]
1.76 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "two девушк мастурбац"
]

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.