Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.65 ms
(86.68%)
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
  365056
  382578
  383947
  385234
  389611
  391940
  397656
  409560
  410685
  411145
  415503
  430581
  447154
  449144
  450434
  467197
  474893
  480457
  487283
  495736
  495750
  495765
  497519
  505368
  506371
  507243
  510822
  513979
  514852
  514867
  517664
  520767
  525351
  530295
  531824
  531868
  531876
  532826
  534554
  535261
  536124
  537256
  540593
  540685
  540915
  542705
  545224
  546284
  547852
  548453
  550806
  550816
  550929
  555797
  559339
  565575
  568264
  569592
  573187
  574090
  575360
  579394
  579517
  580190
  583689
  584164
  585644
  588854
  600304
  600508
  605209
  622048
  627162
  627466
  634021
  638998
  639371
  648679
  653520
  656919
  656936
  658788
  659194
  662194
  663216
  666888
  669030
  669034
  670354
  672937
  672945
  682986
  691355
  713153
  713167
  715743
  717543
  734839
  740816
  742742
  750123
  752595
  752621
  752638
  770219
  770274
  778395
  782791
  784298
  786872
  788735
  792692
  792708
  792739
  792743
  796768
  796840
  800593
  802902
  809351
]
14.95 ms
(7.92%)
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
  385234
  536124
  550806
  480457
  542705
  497519
  565575
  656936
  648679
  691355
  627162
  786872
  750123
  495765
  525351
  540915
  382578
  514852
  495750
  569592
  627466
  391940
  389611
  537256
  531876
  534554
  574090
  666888
  658788
  796768
  792739
  662194
  383947
  365056
  410685
  495736
  510822
  663216
  540593
  669034
  672937
  600508
  638998
  639371
  792708
  734839
  809351
  409560
  530295
  506371
  540685
  656919
  547852
  600304
  796840
  447154
  579517
  550816
  507243
  535261
  583689
  669030
  653520
  579394
  555797
  467197
  545224
  584164
  717543
  588854
  778395
  752595
  770274
  770219
  782791
  788735
  520767
  580190
  514867
  397656
  411145
  505368
  513979
  550929
  559339
  622048
  415503
  449144
  800593
  531824
  573187
  670354
  585644
  752638
  784298
  752621
  713153
  517664
  531868
  682986
  713167
  548453
  634021
  740816
  474893
  575360
  546284
  672945
  715743
  659194
  802902
  742742
  605209
  792692
  792743
  487283
  430581
  450434
  532826
  568264
]
2.97 ms
(1.57%)
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
  365056
  382578
  383947
  385234
  389611
  391940
  397656
  409560
  410685
  411145
  415503
  430581
  447154
  449144
  450434
  467197
  474893
  480457
  487283
  495736
  495750
  495765
  497519
  505368
  506371
  507243
  510822
  513979
  514852
  514867
  517664
  520767
  525351
  530295
  531824
  531868
  531876
  532826
  534554
  535261
  536124
  537256
  540593
  540685
  540915
  542705
  545224
  546284
  547852
  548453
  550806
  550816
  550929
  555797
  559339
  565575
  568264
  569592
  573187
  574090
  575360
  579394
  579517
  580190
  583689
  584164
  585644
  588854
  600304
  600508
  605209
  622048
  627162
  627466
  634021
  638998
  639371
  648679
  653520
  656919
  656936
  658788
  659194
  662194
  663216
  666888
  669030
  669034
  670354
  672937
  672945
  682986
  691355
  713153
  713167
  715743
  717543
  734839
  740816
  742742
  750123
  752595
  752621
  752638
  770219
  770274
  778395
  782791
  784298
  786872
  788735
  792692
  792708
  792739
  792743
  796768
  796840
  800593
  802902
  809351
]
2.29 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting girl"
]
1.75 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг девушк"
]
1.45 ms
(0.77%)
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.