Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.92 ms
(82.21%)
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
  390642
  392820
  399473
  404471
  404483
  407018
  407208
  415948
  417978
  418740
  422187
  422515
  426096
  427327
  428133
  428382
  433733
  442946
  443003
  443363
  446132
  446731
  449859
  450429
  450808
  451940
  453534
  454228
  454636
  455198
  455312
  461394
  461719
  462088
  463942
  467532
  469073
  469766
  473572
  474138
  474495
  477895
  479958
  482539
  483593
  486637
  488051
  488100
  488295
  489073
  489468
  489542
  491478
  492269
  492604
  493164
  493954
  493997
  495664
  495705
  495769
  497006
  500210
  503699
  504163
  510157
  510472
  510951
  511152
  514417
  514939
  515846
  516325
  517934
  518003
  518280
  519500
  520803
  522210
  523520
  523678
  523977
  524006
  524045
  525841
  527077
  531073
  532331
  534561
  544455
  549855
  550864
  551262
  557499
  558474
  561369
  562941
  566459
  567277
  568450
  574833
  576082
  582035
  591304
  596309
  598658
  602803
  605372
  618008
  623617
  624936
  645270
  654534
  654739
  664306
  664794
  671208
  792609
  801292
  814939
]
22.35 ms
(12.42%)
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
  624936
  598658
  602803
  801292
  443363
  454228
  461394
  467532
  479958
  407018
  426096
  455198
  461719
  462088
  463942
  399473
  418740
  422187
  428133
  428382
  503699
  514939
  523520
  524006
  486637
  514417
  515846
  517934
  527077
  483593
  488100
  488295
  493997
  495769
  510472
  523678
  525841
  489073
  493954
  497006
  519500
  524045
  568450
  520803
  392820
  404471
  407208
  443003
  814939
  450808
  453534
  474138
  446132
  446731
  454636
  449859
  473572
  516325
  522210
  523977
  482539
  551262
  557499
  562941
  550864
  664306
  671208
  654739
  645270
  664794
  566459
  591304
  623617
  792609
  477895
  433733
  427327
  474495
  455312
  415948
  534561
  488051
  500210
  489542
  511152
  518280
  495705
  422515
  531073
  532331
  510157
  561369
  576082
  574833
  567277
  582035
  404483
  390642
  491478
  493164
  495664
  518003
  504163
  417978
  469073
  549855
  558474
  654534
  596309
  605372
  618008
  450429
  442946
  492604
  510951
  489468
  469766
  451940
  492269
  544455
]
3.14 ms
(1.74%)
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
  390642
  392820
  399473
  404471
  404483
  407018
  407208
  415948
  417978
  418740
  422187
  422515
  426096
  427327
  428133
  428382
  433733
  442946
  443003
  443363
  446132
  446731
  449859
  450429
  450808
  451940
  453534
  454228
  454636
  455198
  455312
  461394
  461719
  462088
  463942
  467532
  469073
  469766
  473572
  474138
  474495
  477895
  479958
  482539
  483593
  486637
  488051
  488100
  488295
  489073
  489468
  489542
  491478
  492269
  492604
  493164
  493954
  493997
  495664
  495705
  495769
  497006
  500210
  503699
  504163
  510157
  510472
  510951
  511152
  514417
  514939
  515846
  516325
  517934
  518003
  518280
  519500
  520803
  522210
  523520
  523678
  523977
  524006
  524045
  525841
  527077
  531073
  532331
  534561
  544455
  549855
  550864
  551262
  557499
  558474
  561369
  562941
  566459
  567277
  568450
  574833
  576082
  582035
  591304
  596309
  598658
  602803
  605372
  618008
  623617
  624936
  645270
  654534
  654739
  664306
  664794
  671208
  792609
  801292
  814939
]
1.86 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подружк туалет"
]
1.57 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "подругу в туалете"
]
1.49 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.