Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.08 ms
(89.12%)
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
  233353
  450686
  463868
  494760
  501073
  506257
  514463
  518823
  550276
  562899
  564682
  571863
  581318
  589422
  590261
  593300
  600261
  607394
  608980
  616966
  619244
  619786
  623596
  623848
  625504
  635549
  636798
  642274
  645836
  647800
  648393
  659140
  663203
  666770
  672691
  674256
  677136
  683559
  683804
  687187
  695764
  703350
  704347
  705178
  705339
  705428
  708164
  711909
  715124
  719524
  720588
  722829
  728246
  728463
  728673
  729857
  733161
  735554
  736835
  737255
  738222
  741314
  743434
  743959
  744902
  747793
  751130
  751929
  756716
  760210
  761589
  761666
  763331
  766131
  766461
  767548
  770343
  774562
  775161
  777699
  778096
  778572
  779711
  780252
  780723
  781067
  781606
  782436
  783567
  783666
  784881
  785285
  785998
  789399
  789531
  791773
  792015
  792355
  793452
  797043
  797951
  799311
  799590
  800101
  801216
  801424
  802822
  804162
  804493
  804637
  806731
  807941
  810129
  810847
  811655
  811818
  812579
  813770
  814461
  825217
]
10.65 ms
(5.55%)
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
  810129
  736835
  761589
  763331
  735554
  233353
  705428
  518823
  722829
  642274
  623848
  783567
  792355
  793452
  802822
  777699
  789531
  806731
  807941
  811818
  751130
  767548
  728463
  751929
  728673
  733161
  737255
  760210
  766131
  770343
  715124
  450686
  463868
  501073
  506257
  581318
  562899
  571863
  550276
  645836
  648393
  719524
  683559
  711909
  647800
  663203
  695764
  703350
  590261
  619786
  589422
  600261
  616966
  608980
  636798
  779711
  780252
  781606
  783666
  799590
  801424
  812579
  775161
  778096
  782436
  791773
  804493
  804637
  738222
  743959
  744902
  766461
  785285
  789399
  797951
  800101
  804162
  810847
  743434
  747793
  741314
  728246
  729857
  756716
  761666
  607394
  704347
  774562
  780723
  785998
  792015
  813770
  814461
  825217
  494760
  514463
  564682
  677136
  683804
  705339
  674256
  705178
  659140
  666770
  672691
  687187
  708164
  720588
  593300
  619244
  625504
  635549
  623596
  778572
  781067
  784881
  797043
  799311
  801216
  811655
]
2.65 ms
(1.38%)
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
  233353
  450686
  463868
  494760
  501073
  506257
  514463
  518823
  550276
  562899
  564682
  571863
  581318
  589422
  590261
  593300
  600261
  607394
  608980
  616966
  619244
  619786
  623596
  623848
  625504
  635549
  636798
  642274
  645836
  647800
  648393
  659140
  663203
  666770
  672691
  674256
  677136
  683559
  683804
  687187
  695764
  703350
  704347
  705178
  705339
  705428
  708164
  711909
  715124
  719524
  720588
  722829
  728246
  728463
  728673
  729857
  733161
  735554
  736835
  737255
  738222
  741314
  743434
  743959
  744902
  747793
  751130
  751929
  756716
  760210
  761589
  761666
  763331
  766131
  766461
  767548
  770343
  774562
  775161
  777699
  778096
  778572
  779711
  780252
  780723
  781067
  781606
  782436
  783567
  783666
  784881
  785285
  785998
  789399
  789531
  791773
  792015
  792355
  793452
  797043
  797951
  799311
  799590
  800101
  801216
  801424
  802822
  804162
  804493
  804637
  806731
  807941
  810129
  810847
  811655
  811818
  812579
  813770
  814461
  825217
]
2.06 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жестка трахают"
]
2.00 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор секс"
]
1.85 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор секс"
]
1.68 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.