Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.47 ms
(84.49%)
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
  107362
  335993
  354333
  382828
  384201
  384945
  385977
  387078
  392981
  395677
  397365
  412409
  412539
  413209
  424000
  424528
  432374
  434871
  441331
  449312
  450046
  450067
  450698
  452692
  458642
  462703
  465285
  472372
  472983
  473897
  482494
  488023
  497629
  497719
  505603
  507490
  514985
  516623
  524602
  529340
  530952
  531381
  546737
  556320
  564917
  570170
  573187
  574768
  603359
  608231
  631830
  639982
  666431
  689356
  708841
  722237
  724441
  724725
  728388
  734859
  741160
  743492
  744162
  747488
  747799
  751190
  755933
  756640
  757525
  758327
  760632
  760635
  768226
  771426
  771875
  772440
  774266
  774759
  776094
  778285
  780328
  782772
  784575
  786882
  787690
  792245
  793197
  793839
  794000
  794525
  794848
  795851
  796931
  800044
  803015
  805460
  810096
  810991
  811473
  812093
  814478
  816168
  818455
  819304
  820011
  820041
  820145
  820852
  822010
  823750
  823777
  823825
  824145
  825807
  826507
  827528
  828596
  828676
]
12.55 ms
(8.87%)
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
  524602
  382828
  354333
  820011
  824145
  820041
  497629
  507490
  570170
  722237
  774759
  796931
  800044
  775594
  776094
  782772
  784575
  793197
  724725
  744162
  747488
  755933
  772440
  792245
  811473
  724441
  743492
  768226
  774266
  734859
  747799
  757525
  771426
  741160
  751190
  771875
  794000
  778285
  780328
  786882
  793839
  760635
  497719
  574768
  432374
  818455
  689356
  608231
  639982
  805460
  756640
  810991
  472372
  384201
  384945
  819304
  823777
  825807
  564917
  795851
  450046
  529340
  631830
  413209
  335993
  810096
  397365
  760632
  441331
  452692
  424000
  603359
  482494
  462703
  546737
  666431
  472983
  412409
  814478
  820145
  823750
  820852
  822010
  823825
  505603
  573187
  812093
  787690
  794525
  803015
  758327
  794848
  708841
  827528
  826507
  825489
  828596
  828676
  728388
  816168
  514985
  434871
  556320
  424528
  516623
  392981
  107362
  488023
  385977
  395677
  387078
  412539
  450067
  458642
  449312
  450698
  465285
  530952
  531381
  473897
]
2.94 ms
(2.08%)
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
  107362
  335993
  354333
  382828
  384201
  384945
  385977
  387078
  392981
  395677
  397365
  412409
  412539
  413209
  424000
  424528
  432374
  434871
  441331
  449312
  450046
  450067
  450698
  452692
  458642
  462703
  465285
  472372
  472983
  473897
  482494
  488023
  497629
  497719
  505603
  507490
  514985
  516623
  524602
  529340
  530952
  531381
  546737
  556320
  564917
  570170
  573187
  574768
  603359
  608231
  631830
  639982
  666431
  689356
  708841
  722237
  724441
  724725
  728388
  734859
  741160
  743492
  744162
  747488
  747799
  751190
  755933
  756640
  757525
  758327
  760632
  760635
  768226
  771426
  771875
  772440
  774266
  774759
  776094
  778285
  780328
  782772
  784575
  786882
  787690
  792245
  793197
  793839
  794000
  794525
  794848
  795851
  796931
  800044
  803015
  805460
  810096
  810991
  811473
  812093
  814478
  816168
  818455
  819304
  820011
  820041
  820145
  820852
  822010
  823750
  823777
  823825
  824145
  825807
  826507
  827528
  828596
  828676
]
1.95 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "panties pussy"
]
1.62 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трусик нижн бел pussy"
]
1.44 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трусик нижн бел pussy"
]

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.