Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.91 ms
(84.75%)
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
  395973
  421520
  422339
  422402
  422561
  422572
  422649
  423039
  423263
  428481
  428726
  430256
  437537
  443372
  444452
  445835
  446781
  447127
  447277
  447407
  454284
  456215
  460302
  462379
  463775
  463777
  463808
  463915
  464916
  465645
  465951
  474487
  479492
  479728
  480941
  481780
  491474
  491666
  492187
  492245
  495066
  496613
  496711
  496758
  506297
  507939
  508526
  512828
  512857
  513230
  513272
  513656
  513696
  518936
  519687
  521454
  522565
  525439
  527632
  528437
  528446
  529092
  531174
  531472
  532843
  532965
  533018
  533570
  533576
  533747
  536385
  536931
  537915
  538544
  538608
  538837
  540316
  543456
  544368
  546200
  549106
  550091
  554256
  555884
  555899
  556307
  559856
  565800
  571957
  597244
  599367
  602232
  605659
  605790
  614428
  623178
  623922
  626389
  626538
  634791
  639048
  647875
  647891
  651180
  651666
  651913
  656577
  662198
  665918
  665926
  666536
  666541
  678942
  679770
  718675
  720882
  733862
  788788
  788794
  817033
]
14.41 ms
(8.85%)
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
  528437
  528446
  536931
  538544
  491474
  491666
  496758
  512828
  513230
  513272
  522565
  527632
  421520
  532843
  531174
  533747
  651666
  546200
  463808
  395973
  422561
  423039
  428481
  437537
  443372
  422649
  422402
  422572
  428726
  430256
  444452
  817033
  460302
  463775
  463915
  446781
  447277
  447407
  465951
  479728
  445835
  447127
  454284
  456215
  463777
  465645
  474487
  479492
  480941
  481780
  492187
  495066
  496613
  496711
  518936
  525439
  533018
  537915
  506297
  507939
  512857
  521454
  536385
  538837
  540316
  531472
  533576
  508526
  513656
  513696
  519687
  529092
  532965
  533570
  538608
  462379
  464916
  492245
  549106
  555884
  571957
  543456
  544368
  554256
  565800
  666541
  720882
  647891
  651180
  651913
  665926
  678942
  679770
  647875
  656577
  662198
  665918
  666536
  550091
  555899
  556307
  559856
  599367
  626538
  639048
  605790
  623178
  623922
  597244
  602232
  605659
  788788
  788794
  733862
  614428
  626389
  634791
  718675
  422339
  423263
]
3.09 ms
(1.90%)
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
  395973
  421520
  422339
  422402
  422561
  422572
  422649
  423039
  423263
  428481
  428726
  430256
  437537
  443372
  444452
  445835
  446781
  447127
  447277
  447407
  454284
  456215
  460302
  462379
  463775
  463777
  463808
  463915
  464916
  465645
  465951
  474487
  479492
  479728
  480941
  481780
  491474
  491666
  492187
  492245
  495066
  496613
  496711
  496758
  506297
  507939
  508526
  512828
  512857
  513230
  513272
  513656
  513696
  518936
  519687
  521454
  522565
  525439
  527632
  528437
  528446
  529092
  531174
  531472
  532843
  532965
  533018
  533570
  533576
  533747
  536385
  536931
  537915
  538544
  538608
  538837
  540316
  543456
  544368
  546200
  549106
  550091
  554256
  555884
  555899
  556307
  559856
  565800
  571957
  597244
  599367
  602232
  605659
  605790
  614428
  623178
  623922
  626389
  626538
  634791
  639048
  647875
  647891
  651180
  651666
  651913
  656577
  662198
  665918
  665926
  666536
  666541
  678942
  679770
  718675
  720882
  733862
  788788
  788794
  817033
]
2.00 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen domination"
]
1.88 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen domination"
]
1.61 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen domination"
]

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.