Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.16 ms
(82.77%)
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
  2208
  325743
  382276
  383581
  384570
  385528
  387716
  387883
  388108
  388925
  393442
  393700
  396748
  397389
  401089
  401350
  401979
  402060
  402062
  403377
  407618
  409372
  409613
  412315
  414092
  416090
  417023
  425954
  426933
  428141
  428366
  429239
  429391
  429936
  435420
  439729
  446350
  447628
  452208
  456198
  458170
  458830
  459443
  461500
  462508
  463120
  464433
  466029
  467069
  467361
  468485
  469863
  470260
  470510
  471533
  472340
  472560
  472796
  473803
  474990
  475496
  478865
  484872
  488902
  490653
  490839
  491145
  491472
  491958
  491976
  492081
  496065
  496796
  497576
  501169
  501519
  510535
  510662
  510664
  511064
  511188
  515310
  525714
  526393
  526968
  533464
  544521
  545720
  548620
  549773
  550374
  557910
  559985
  560390
  561312
  561701
  565819
  570218
  570648
  571615
  571876
  571924
  573093
  573306
  573545
  573831
  573882
  575761
  597114
  610688
  663386
  663410
  663857
  663973
  667829
  681216
  716804
  724050
  729886
  804876
]
15.32 ms
(10.64%)
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
  470260
  446350
  533464
  570218
  575761
  663973
  681216
  414092
  525714
  409372
  515310
  402060
  490839
  491958
  573306
  663410
  663857
  469863
  461500
  388925
  417023
  385528
  463120
  548620
  559985
  573093
  409613
  456198
  458170
  466029
  490653
  511188
  484872
  492081
  471533
  468485
  467069
  549773
  557910
  570648
  571924
  544521
  667829
  571876
  729886
  804876
  473803
  2208
  401350
  439729
  511064
  610688
  459443
  510664
  429391
  402062
  426933
  428366
  496796
  488902
  561701
  663386
  597114
  724050
  388108
  382276
  472796
  526393
  501169
  510535
  383581
  384570
  470510
  387883
  397389
  396748
  401979
  412315
  716804
  387716
  464433
  401089
  429936
  435420
  472340
  510662
  496065
  393442
  452208
  478865
  561312
  573545
  573831
  416090
  403377
  462508
  425954
  429239
  474990
  491472
  501519
  491145
  491976
  497576
  526968
  325743
  407618
  428141
  447628
  458830
  467361
  472560
  475496
  550374
  560390
  571615
  565819
  545720
  573882
  393700
]
2.53 ms
(1.76%)
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
  2208
  325743
  382276
  383581
  384570
  385528
  387716
  387883
  388108
  388925
  393442
  393700
  396748
  397389
  401089
  401350
  401979
  402060
  402062
  403377
  407618
  409372
  409613
  412315
  414092
  416090
  417023
  425954
  426933
  428141
  428366
  429239
  429391
  429936
  435420
  439729
  446350
  447628
  452208
  456198
  458170
  458830
  459443
  461500
  462508
  463120
  464433
  466029
  467069
  467361
  468485
  469863
  470260
  470510
  471533
  472340
  472560
  472796
  473803
  474990
  475496
  478865
  484872
  488902
  490653
  490839
  491145
  491472
  491958
  491976
  492081
  496065
  496796
  497576
  501169
  501519
  510535
  510662
  510664
  511064
  511188
  515310
  525714
  526393
  526968
  533464
  544521
  545720
  548620
  549773
  550374
  557910
  559985
  560390
  561312
  561701
  565819
  570218
  570648
  571615
  571876
  571924
  573093
  573306
  573545
  573831
  573882
  575761
  597114
  610688
  663386
  663410
  663857
  663973
  667829
  681216
  716804
  724050
  729886
  804876
]
1.84 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "оттрахали худенького …"
]
1.80 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс худой"
]
1.59 ms
(1.11%)
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.