Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.66 ms
(85.81%)
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
  370949
  417835
  418996
  427634
  429492
  431709
  432778
  437325
  445767
  449153
  449719
  449851
  452696
  452789
  452796
  454538
  460033
  460129
  460458
  465276
  467077
  469486
  474886
  481805
  482305
  483657
  485432
  492049
  493214
  502809
  507225
  507799
  509082
  513366
  514765
  515047
  521160
  525145
  529249
  534190
  536353
  539531
  552758
  555077
  557049
  557366
  560989
  562938
  562957
  563003
  563098
  563920
  565709
  567214
  571044
  573757
  576127
  584414
  604313
  605708
  609584
  610058
  611264
  612700
  623147
  623392
  623396
  637403
  668786
  672251
  680852
  682269
  682363
  700202
  701167
  701192
  701215
  703439
  709204
  710595
  712641
  713105
  714553
  717948
  721580
  723138
  723975
  723981
  726598
  726845
  726873
  731256
  740162
  742839
  742986
  743809
  744240
  749635
  753510
  760164
  761102
  767681
  771489
  780343
  785180
  788223
  788374
  793165
  793526
  794623
  796098
  802182
  802274
  811712
  817492
  819918
  819919
  823557
  824505
  827577
]
12.30 ms
(7.96%)
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
  452789
  460033
  417835
  623147
  623396
  485432
  521160
  726873
  452796
  493214
  562957
  802182
  761102
  744240
  610058
  760164
  827577
  793165
  793526
  753510
  811712
  721580
  623392
  370949
  525145
  563098
  482305
  483657
  571044
  563003
  567214
  449719
  460458
  584414
  710595
  605708
  611264
  785180
  573757
  604313
  465276
  726598
  788223
  431709
  507225
  452696
  552758
  529249
  823557
  612700
  723981
  731256
  788374
  726845
  701192
  474886
  539531
  557366
  576127
  680852
  709204
  712641
  700202
  701215
  668786
  796098
  723975
  713105
  467077
  432778
  492049
  555077
  449851
  429492
  469486
  563920
  743809
  802274
  819919
  418996
  460129
  437325
  507799
  513366
  717948
  560989
  742839
  565709
  536353
  682363
  703439
  672251
  557049
  819918
  824505
  714553
  723138
  794623
  742986
  767681
  771489
  749635
  780343
  562938
  502809
  427634
  481805
  515047
  509082
  701167
  445767
  534190
  609584
  514765
  682269
  637403
  740162
  817492
  449153
  454538
]
2.56 ms
(1.66%)
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
  370949
  417835
  418996
  427634
  429492
  431709
  432778
  437325
  445767
  449153
  449719
  449851
  452696
  452789
  452796
  454538
  460033
  460129
  460458
  465276
  467077
  469486
  474886
  481805
  482305
  483657
  485432
  492049
  493214
  502809
  507225
  507799
  509082
  513366
  514765
  515047
  521160
  525145
  529249
  534190
  536353
  539531
  552758
  555077
  557049
  557366
  560989
  562938
  562957
  563003
  563098
  563920
  565709
  567214
  571044
  573757
  576127
  584414
  604313
  605708
  609584
  610058
  611264
  612700
  623147
  623392
  623396
  637403
  668786
  672251
  680852
  682269
  682363
  700202
  701167
  701192
  701215
  703439
  709204
  710595
  712641
  713105
  714553
  717948
  721580
  723138
  723975
  723981
  726598
  726845
  726873
  731256
  740162
  742839
  742986
  743809
  744240
  749635
  753510
  760164
  761102
  767681
  771489
  780343
  785180
  788223
  788374
  793165
  793526
  794623
  796098
  802182
  802274
  811712
  817492
  819918
  819919
  823557
  824505
  827577
]
2.03 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "спящие мамки домашнее…"
]
1.75 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спящ мам женщин домашн любительск"
]
1.71 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.03%)
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.