Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.10 ms
(85.05%)
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
  372346
  391567
  393937
  400096
  401803
  403272
  404121
  404390
  412914
  416446
  417021
  417940
  418466
  419658
  420248
  421027
  423919
  425160
  426153
  427857
  430267
  432547
  433063
  436529
  437914
  443010
  443554
  444244
  444257
  444873
  445329
  446220
  446611
  447277
  449660
  452286
  452496
  458038
  462078
  462556
  463628
  468106
  471596
  473345
  473430
  473715
  476012
  482080
  488496
  492773
  493508
  498872
  502689
  503725
  505876
  508345
  509010
  510321
  511983
  512954
  517330
  520703
  529109
  548701
  557523
  566866
  574522
  577638
  584576
  584837
  586310
  592323
  594415
  599306
  604346
  604413
  625100
  628258
  642097
  670820
  687432
  691170
  691472
  704644
  707233
  712380
  712959
  714235
  717853
  720136
  723628
  730928
  732822
  740009
  742005
  744381
  752565
  752603
  756331
  757564
  761611
  761628
  765545
  766849
  766969
  769418
  772729
  774038
  779689
  782187
  786988
  790464
  792735
  794917
  804859
  805643
  807190
  813277
  816625
  827590
]
15.14 ms
(9.26%)
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
  557523
  418466
  463628
  416446
  436529
  403272
  427857
  508345
  502689
  604413
  510321
  372346
  712380
  599306
  642097
  730928
  761628
  765545
  807190
  757564
  761611
  804859
  391567
  827590
  509010
  720136
  444244
  473715
  443554
  447277
  446220
  473430
  444873
  468106
  471596
  437914
  446611
  420248
  473345
  449660
  503725
  488496
  423919
  492773
  452286
  412914
  594415
  417940
  433063
  452496
  432547
  520703
  670820
  401803
  404390
  816625
  498872
  584837
  577638
  707233
  717853
  586310
  740009
  790464
  794917
  732822
  756331
  752565
  786988
  393937
  404121
  419658
  574522
  529109
  476012
  517330
  462556
  604346
  493508
  443010
  566866
  548701
  687432
  691170
  691472
  712959
  714235
  584576
  628258
  592323
  625100
  813277
  779689
  782187
  744381
  752603
  769418
  772729
  766969
  742005
  774038
  704644
  792735
  805643
  400096
  458038
  505876
  482080
  444257
  421027
  426153
  425160
  445329
  462078
  512954
  430267
  766849
  511983
  417021
  723628
]
3.00 ms
(1.84%)
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
  372346
  391567
  393937
  400096
  401803
  403272
  404121
  404390
  412914
  416446
  417021
  417940
  418466
  419658
  420248
  421027
  423919
  425160
  426153
  427857
  430267
  432547
  433063
  436529
  437914
  443010
  443554
  444244
  444257
  444873
  445329
  446220
  446611
  447277
  449660
  452286
  452496
  458038
  462078
  462556
  463628
  468106
  471596
  473345
  473430
  473715
  476012
  482080
  488496
  492773
  493508
  498872
  502689
  503725
  505876
  508345
  509010
  510321
  511983
  512954
  517330
  520703
  529109
  548701
  557523
  566866
  574522
  577638
  584576
  584837
  586310
  592323
  594415
  599306
  604346
  604413
  625100
  628258
  642097
  670820
  687432
  691170
  691472
  704644
  707233
  712380
  712959
  714235
  717853
  720136
  723628
  730928
  732822
  740009
  742005
  744381
  752565
  752603
  756331
  757564
  761611
  761628
  765545
  766849
  766969
  769418
  772729
  774038
  779689
  782187
  786988
  790464
  792735
  794917
  804859
  805643
  807190
  813277
  816625
  827590
]
1.94 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam teen blowjob"
]
1.52 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер teen минет оральн секс"
]
1.51 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер teen минет оральн секс"
]

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.