Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.76 ms
(85.11%)
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
  385681
  395424
  397694
  490700
  492064
  530205
  531035
  534799
  535791
  550943
  563243
  575636
  577270
  594359
  595964
  614297
  616290
  622646
  631098
  637361
  640396
  646359
  647064
  647173
  649338
  675460
  675745
  679089
  687114
  700033
  703275
  703729
  704489
  707729
  713474
  713642
  715087
  716532
  716726
  719215
  724017
  728633
  731098
  734955
  735735
  736063
  736756
  738430
  740243
  740933
  742081
  747160
  752167
  753520
  754431
  758738
  762677
  766292
  772492
  773151
  774138
  776365
  778892
  781918
  782095
  782492
  782704
  783383
  783436
  783676
  783809
  783995
  784230
  784411
  786222
  787740
  788122
  791774
  792452
  793033
  793430
  796222
  796709
  799113
  799544
  803085
  803285
  805591
  805880
  806245
  806646
  806997
  807634
  808645
  809991
  813634
  813910
  818296
  818416
  818676
  819109
  819889
  820090
  820525
  820802
  821183
  821304
  821815
  822910
  823178
  823839
  824128
  824307
  825003
  825440
  825634
  826272
  827464
  827649
  828346
]
13.70 ms
(8.00%)
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
  783676
  806245
  397694
  577270
  675460
  647173
  637361
  640396
  595964
  782095
  773151
  754431
  614297
  783383
  799544
  492064
  740933
  531035
  793033
  826272
  818296
  818676
  824128
  824307
  825634
  828346
  535791
  534799
  703275
  719215
  716726
  646359
  649338
  631098
  594359
  783809
  776365
  782492
  787740
  728633
  734955
  752167
  792452
  735735
  736756
  747160
  753520
  616290
  703729
  782704
  803085
  803285
  827649
  530205
  550943
  679089
  687114
  707729
  704489
  778892
  781918
  799113
  772492
  805880
  740243
  738430
  713474
  783436
  788122
  796222
  808645
  395424
  820090
  675745
  713642
  791774
  758738
  793430
  806646
  766292
  827464
  820802
  822910
  821183
  825440
  563243
  715087
  700033
  783995
  806997
  724017
  784411
  786222
  805591
  809991
  731098
  742081
  762677
  774138
  622646
  784230
  796709
  807634
  575636
  716532
  736063
  385681
  813910
  819109
  823178
  825003
  813634
  818416
  821304
  821815
  823839
  819889
  820525
  490700
  647064
]
4.31 ms
(2.52%)
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
  385681
  395424
  397694
  490700
  492064
  530205
  531035
  534799
  535791
  550943
  563243
  575636
  577270
  594359
  595964
  614297
  616290
  622646
  631098
  637361
  640396
  646359
  647064
  647173
  649338
  675460
  675745
  679089
  687114
  700033
  703275
  703729
  704489
  707729
  713474
  713642
  715087
  716532
  716726
  719215
  724017
  728633
  731098
  734955
  735735
  736063
  736756
  738430
  740243
  740933
  742081
  747160
  752167
  753520
  754431
  758738
  762677
  766292
  772492
  773151
  774138
  776365
  778892
  781918
  782095
  782492
  782704
  783383
  783436
  783676
  783809
  783995
  784230
  784411
  786222
  787740
  788122
  791774
  792452
  793033
  793430
  796222
  796709
  799113
  799544
  803085
  803285
  805591
  805880
  806245
  806646
  806997
  807634
  808645
  809991
  813634
  813910
  818296
  818416
  818676
  819109
  819889
  820090
  820525
  820802
  821183
  821304
  821815
  822910
  823178
  823839
  824128
  824307
  825003
  825440
  825634
  826272
  827464
  827649
  828346
]
1.88 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "all девушк"
]
1.88 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "all девушк"
]
1.87 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "all girl"
]
1.87 ms
(1.09%)
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.