Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.21 ms
(85.13%)
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
  150305
  392735
  402556
  402842
  420001
  420833
  449478
  463379
  478274
  480968
  481409
  485343
  487824
  492017
  503085
  508407
  511932
  516809
  530587
  531806
  533084
  537378
  537608
  542819
  547741
  551728
  553854
  554888
  555547
  556686
  558264
  562522
  566220
  566407
  568821
  576607
  586928
  589601
  590214
  593214
  593261
  610891
  612508
  612706
  616845
  619964
  620568
  621500
  641516
  642259
  645052
  646076
  648193
  648758
  652422
  663516
  664473
  672340
  678339
  679908
  682691
  689121
  690621
  692832
  693151
  711639
  714018
  715154
  717131
  721083
  722035
  727352
  729549
  733501
  733767
  734792
  735678
  736642
  742131
  746230
  747171
  750030
  752492
  753645
  754146
  756785
  757667
  761161
  770095
  770715
  775297
  777276
  778945
  779557
  780304
  782365
  787142
  788045
  789580
  789911
  790237
  791827
  794142
  794425
  795672
  796111
  798863
  800493
  801833
  803501
  804360
  804904
  808082
  808143
  808468
  809607
  813428
]
11.05 ms
(7.83%)
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
  714018
  690621
  642259
  619964
  778945
  754040
  754146
  803501
  733767
  762229
  478274
  150305
  485343
  492017
  576607
  693151
  692832
  566220
  566407
  586928
  589601
  590214
  808143
  717131
  508407
  663516
  621500
  463379
  487824
  392735
  402556
  420833
  530587
  531806
  537378
  537608
  533084
  553854
  558264
  542819
  551728
  555547
  554888
  562522
  648193
  664473
  679908
  689121
  646076
  652422
  678339
  715154
  721083
  645052
  672340
  682691
  556686
  616845
  620568
  593261
  610891
  612508
  612706
  593214
  641516
  777276
  779557
  780304
  782365
  789580
  801833
  790237
  795672
  809607
  813428
  727352
  729549
  734792
  770715
  784610
  787142
  789911
  794142
  800493
  808082
  742131
  733501
  747171
  752492
  756785
  736642
  753645
  761161
  770095
  746230
  750030
  711639
  788045
  791827
  794425
  796111
  798863
  804360
  804904
  402842
  420001
  449478
  511932
  503085
  516809
  480968
  481409
  547741
  648758
  722035
  568821
  775297
  808468
  735678
  757667
]
2.53 ms
(1.79%)
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
  150305
  392735
  402556
  402842
  420001
  420833
  449478
  463379
  478274
  480968
  481409
  485343
  487824
  492017
  503085
  508407
  511932
  516809
  530587
  531806
  533084
  537378
  537608
  542819
  547741
  551728
  553854
  554888
  555547
  556686
  558264
  562522
  566220
  566407
  568821
  576607
  586928
  589601
  590214
  593214
  593261
  610891
  612508
  612706
  616845
  619964
  620568
  621500
  641516
  642259
  645052
  646076
  648193
  648758
  652422
  663516
  664473
  672340
  678339
  679908
  682691
  689121
  690621
  692832
  693151
  711639
  714018
  715154
  717131
  721083
  722035
  727352
  729549
  733501
  733767
  734792
  735678
  736642
  742131
  746230
  747171
  750030
  752492
  753645
  754146
  756785
  757667
  761161
  770095
  770715
  775297
  777276
  778945
  779557
  780304
  782365
  787142
  788045
  789580
  789911
  790237
  791827
  794142
  794425
  795672
  796111
  798863
  800493
  801833
  803501
  804360
  804904
  808082
  808143
  808468
  809607
  813428
]
1.95 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "красивая жена изменяе…"
]
1.91 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая жен жен"
]
1.83 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.22%)
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.