Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.13 ms
(84.46%)
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
  394351
  402164
  418513
  429220
  438486
  458628
  462306
  474057
  489155
  527165
  530594
  533763
  536186
  536217
  537822
  538798
  540181
  543657
  550445
  552159
  552171
  552210
  553889
  554180
  556060
  557005
  569361
  571730
  583531
  588471
  594604
  594613
  596660
  598894
  603519
  604002
  608155
  616491
  618782
  620333
  622334
  622477
  624703
  628219
  628795
  628851
  628957
  636349
  636522
  651883
  654881
  661709
  669961
  675715
  676196
  676215
  676489
  677047
  677074
  678195
  682647
  684812
  687093
  690530
  691676
  696194
  700737
  702375
  704638
  705102
  707774
  711273
  712293
  718143
  718587
  718848
  723377
  730254
  732387
  733387
  734877
  735681
  735982
  738766
  741640
  742195
  744507
  750242
  756473
  759223
  761359
  761384
  773132
  776875
  779894
  781580
  781631
  785082
  785274
  787328
  787936
  788309
  788595
  789089
  790082
  791747
  798860
  804218
  805650
  805652
  810548
  812958
  813284
  814419
  817626
  818936
  824722
  827302
  827347
  827360
]
15.10 ms
(9.23%)
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
  818936
  550445
  730254
  732387
  462306
  402164
  429220
  827347
  538798
  553889
  552210
  684812
  705102
  651883
  718848
  654881
  569361
  588471
  604002
  624703
  805652
  781631
  741640
  761359
  735982
  759223
  787936
  805650
  812958
  418513
  824722
  827302
  583531
  691676
  718143
  675715
  677074
  594604
  622477
  628219
  628851
  608155
  620333
  798860
  785082
  791747
  735681
  750242
  776875
  804218
  738766
  827360
  817626
  530594
  536186
  552171
  557005
  571730
  687093
  690530
  707774
  718587
  682647
  711273
  676196
  676215
  676489
  628795
  603519
  594613
  596660
  598894
  636349
  616491
  779894
  790082
  788309
  789089
  813284
  733387
  742195
  761384
  744507
  700737
  702375
  712293
  787328
  438486
  723377
  773132
  554180
  678195
  696194
  781580
  814419
  458628
  537822
  756473
  734877
  785274
  788595
  394351
  489155
  536217
  527165
  533763
  540181
  474057
  543657
  552159
  661709
  669961
  677047
  704638
  556060
  628957
  636522
  622334
  618782
  810548
]
3.09 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
  394351
  402164
  418513
  429220
  438486
  458628
  462306
  474057
  489155
  527165
  530594
  533763
  536186
  536217
  537822
  538798
  540181
  543657
  550445
  552159
  552171
  552210
  553889
  554180
  556060
  557005
  569361
  571730
  583531
  588471
  594604
  594613
  596660
  598894
  603519
  604002
  608155
  616491
  618782
  620333
  622334
  622477
  624703
  628219
  628795
  628851
  628957
  636349
  636522
  651883
  654881
  661709
  669961
  675715
  676196
  676215
  676489
  677047
  677074
  678195
  682647
  684812
  687093
  690530
  691676
  696194
  700737
  702375
  704638
  705102
  707774
  711273
  712293
  718143
  718587
  718848
  723377
  730254
  732387
  733387
  734877
  735681
  735982
  738766
  741640
  742195
  744507
  750242
  756473
  759223
  761359
  761384
  773132
  776875
  779894
  781580
  781631
  785082
  785274
  787328
  787936
  788309
  788595
  789089
  790082
  791747
  798860
  804218
  805650
  805652
  810548
  812958
  813284
  814419
  817626
  818936
  824722
  827302
  827347
  827360
]
2.15 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "year old girl"
]
1.72 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "year old девушк"
]
1.68 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "year old девушк"
]
1.67 ms
(1.02%)
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.