Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.69 ms
(86.75%)
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
  132148
  212893
  233398
  311007
  381941
  383281
  385171
  386350
  386576
  402375
  412578
  428543
  428845
  431496
  445104
  450383
  454195
  455834
  458826
  459494
  461918
  463978
  465910
  467032
  467239
  470395
  470734
  472705
  474124
  474410
  474711
  474722
  479691
  482867
  483586
  485512
  488931
  491357
  494203
  494919
  494935
  501434
  503933
  505851
  509760
  511815
  512063
  512593
  515909
  518452
  518843
  520545
  520796
  522582
  523219
  523674
  525153
  525762
  528664
  538590
  539360
  542855
  546764
  546934
  547686
  552059
  555917
  556396
  556506
  558284
  559590
  565358
  566206
  568060
  572287
  574085
  580029
  580129
  589679
  590343
  596141
  598565
  599327
  600758
  603460
  610859
  619452
  622929
  624865
  630686
  663418
  667671
  675527
  677360
  678971
  679441
  680102
  710250
  711295
  712130
  712558
  713156
  719464
  725687
  730249
  732782
  735893
  736054
  749621
  770888
  774209
  793341
  794416
  795065
  798701
  808542
  810954
  812993
  814087
  814512
]
14.22 ms
(7.97%)
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
  474722
  488931
  494935
  710250
  712130
  719464
  622929
  810954
  749621
  795065
  381941
  412578
  491357
  523674
  212893
  770888
  385171
  470395
  538590
  494919
  679441
  619452
  598565
  501434
  455834
  522582
  483586
  556506
  574085
  675527
  711295
  663418
  546764
  580129
  630686
  600758
  808542
  736054
  610859
  798701
  812993
  494203
  512063
  467032
  542855
  680102
  713156
  814087
  461918
  518843
  566206
  712558
  677360
  667671
  794416
  520545
  386576
  233398
  445104
  814512
  474410
  546934
  555917
  678971
  558284
  730249
  735893
  774209
  431496
  386350
  472705
  450383
  505851
  503933
  132148
  311007
  454195
  525153
  467239
  474711
  565358
  552059
  559590
  547686
  556396
  572287
  589679
  599327
  624865
  590343
  596141
  603460
  793341
  725687
  732782
  428845
  458826
  402375
  459494
  470734
  511815
  528664
  525762
  482867
  485512
  512593
  383281
  428543
  463978
  474124
  479691
  515909
  523219
  509760
  518452
  520796
  539360
  465910
  568060
  580029
]
2.69 ms
(1.51%)
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
  132148
  212893
  233398
  311007
  381941
  383281
  385171
  386350
  386576
  402375
  412578
  428543
  428845
  431496
  445104
  450383
  454195
  455834
  458826
  459494
  461918
  463978
  465910
  467032
  467239
  470395
  470734
  472705
  474124
  474410
  474711
  474722
  479691
  482867
  483586
  485512
  488931
  491357
  494203
  494919
  494935
  501434
  503933
  505851
  509760
  511815
  512063
  512593
  515909
  518452
  518843
  520545
  520796
  522582
  523219
  523674
  525153
  525762
  528664
  538590
  539360
  542855
  546764
  546934
  547686
  552059
  555917
  556396
  556506
  558284
  559590
  565358
  566206
  568060
  572287
  574085
  580029
  580129
  589679
  590343
  596141
  598565
  599327
  600758
  603460
  610859
  619452
  622929
  624865
  630686
  663418
  667671
  675527
  677360
  678971
  679441
  680102
  710250
  711295
  712130
  712558
  713156
  719464
  725687
  730249
  732782
  735893
  736054
  749621
  770888
  774209
  793341
  794416
  795065
  798701
  808542
  810954
  812993
  814087
  814512
]
1.93 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck woman"
]
1.67 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс woman"
]
1.55 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс woman"
]

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.