Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.65 ms
(83.22%)
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
  161823
  384201
  395319
  400226
  401027
  402425
  403833
  415040
  417311
  418869
  420082
  421942
  423433
  424969
  425947
  426962
  427855
  432389
  432404
  432477
  432479
  432507
  432519
  432706
  433792
  433815
  435931
  443073
  446952
  450025
  451254
  451530
  453872
  455995
  456578
  459298
  461710
  461912
  462823
  463448
  464915
  465361
  465906
  467953
  469349
  469716
  475309
  476568
  477205
  481263
  481392
  485139
  488529
  489381
  489760
  490005
  490522
  490883
  491138
  494180
  495002
  505996
  506494
  507771
  508641
  509634
  510219
  513060
  514151
  516490
  517978
  522647
  522953
  522993
  524447
  527362
  529516
  531080
  538794
  542113
  542386
  546781
  552889
  554064
  554577
  560837
  560996
  562601
  565000
  577330
  577644
  578578
  580425
  581855
  585344
  586400
  588987
  590145
  598218
  600704
  608007
  610838
  612821
  613379
  620059
  628696
  636355
  650359
  661531
  675427
  688962
  700059
  739301
  757878
  770600
  773924
  782565
  784976
  788060
  798962
]
14.45 ms
(10.22%)
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
  636355
  432389
  455995
  463448
  477205
  506494
  494180
  469716
  585344
  425947
  578578
  505996
  577644
  516490
  608007
  161823
  421942
  522953
  527362
  491138
  628696
  590145
  586400
  490005
  401027
  451530
  490883
  475309
  577330
  453872
  426962
  464915
  488529
  490522
  459298
  465906
  538794
  456578
  395319
  403833
  417311
  435931
  418869
  443073
  446952
  469349
  462823
  467953
  562601
  546781
  552889
  600704
  481263
  433815
  461912
  420082
  424969
  427855
  432519
  476568
  415040
  465361
  481392
  509634
  485139
  489760
  402425
  542386
  432477
  423433
  700059
  782565
  739301
  798962
  531080
  384201
  581855
  432706
  522993
  513060
  542113
  580425
  588987
  620059
  529516
  450025
  507771
  514151
  524447
  495002
  560837
  554577
  565000
  675427
  433792
  432404
  432479
  598218
  613379
  451254
  461710
  510219
  517978
  489381
  757878
  661531
  688962
  650359
  773924
  432507
  522647
  508641
  400226
  560996
  554064
  612821
  610838
  784976
  788060
  770600
]
2.34 ms
(1.65%)
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
  161823
  384201
  395319
  400226
  401027
  402425
  403833
  415040
  417311
  418869
  420082
  421942
  423433
  424969
  425947
  426962
  427855
  432389
  432404
  432477
  432479
  432507
  432519
  432706
  433792
  433815
  435931
  443073
  446952
  450025
  451254
  451530
  453872
  455995
  456578
  459298
  461710
  461912
  462823
  463448
  464915
  465361
  465906
  467953
  469349
  469716
  475309
  476568
  477205
  481263
  481392
  485139
  488529
  489381
  489760
  490005
  490522
  490883
  491138
  494180
  495002
  505996
  506494
  507771
  508641
  509634
  510219
  513060
  514151
  516490
  517978
  522647
  522953
  522993
  524447
  527362
  529516
  531080
  538794
  542113
  542386
  546781
  552889
  554064
  554577
  560837
  560996
  562601
  565000
  577330
  577644
  578578
  580425
  581855
  585344
  586400
  588987
  590145
  598218
  600704
  608007
  610838
  612821
  613379
  620059
  628696
  636355
  650359
  661531
  675427
  688962
  700059
  739301
  757878
  770600
  773924
  782565
  784976
  788060
  798962
]
2.13 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сперма в труси"
]
1.85 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в трусик нижн бел"
]
1.41 ms
(1.00%)
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.