Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.17 ms
(84.38%)
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
  388912
  415954
  420267
  421520
  429762
  429898
  430081
  437686
  443103
  443636
  447803
  447851
  448034
  448878
  448987
  452535
  456690
  460412
  464932
  468433
  470527
  472784
  474021
  474688
  475194
  477073
  477470
  477553
  477554
  484571
  484636
  484818
  485597
  486706
  488571
  491508
  491664
  491776
  492273
  494171
  494276
  500971
  506195
  508156
  509810
  509879
  510821
  512447
  512538
  513710
  513979
  515329
  516103
  517847
  518206
  518558
  519985
  521738
  522871
  522976
  523567
  524417
  524628
  528791
  529855
  530024
  530030
  530053
  530487
  530637
  530694
  530703
  530808
  531174
  532762
  534027
  537584
  537595
  541644
  541721
  542148
  543848
  545785
  548552
  550315
  556774
  558601
  559886
  560429
  561136
  561140
  561142
  561814
  567347
  575806
  576079
  576219
  576371
  576372
  582972
  583512
  583670
  583722
  587879
  590584
  593863
  605636
  609958
  610692
  610786
  628312
  632383
  640770
  642723
  644691
  647952
  650380
  653889
  782030
  794944
]
18.07 ms
(10.29%)
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
  523567
  430081
  509879
  474688
  437686
  475194
  593863
  519985
  610786
  575806
  491664
  420267
  576219
  515329
  477470
  429898
  528791
  530053
  468433
  486706
  492273
  583670
  605636
  472784
  429762
  561142
  448034
  443103
  477554
  517847
  530487
  640770
  447803
  518206
  448987
  644691
  464932
  610692
  447851
  460412
  556774
  583722
  388912
  642723
  794944
  576371
  561140
  470527
  456690
  484571
  509810
  513979
  484636
  518558
  561814
  452535
  415954
  587879
  576079
  650380
  537584
  530030
  531174
  532762
  647952
  512538
  448878
  560429
  506195
  512447
  522871
  609958
  545785
  558601
  541644
  477553
  474021
  529855
  521738
  561136
  508156
  537595
  576372
  485597
  530703
  582972
  530808
  513710
  524417
  491776
  534027
  550315
  488571
  477073
  421520
  548552
  632383
  494171
  516103
  530694
  500971
  524628
  530024
  522976
  541721
  567347
  542148
  628312
  510821
  530637
  484818
  443636
  543848
  491508
  559886
  653889
  494276
  590584
  782030
  583512
]
2.76 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
  388912
  415954
  420267
  421520
  429762
  429898
  430081
  437686
  443103
  443636
  447803
  447851
  448034
  448878
  448987
  452535
  456690
  460412
  464932
  468433
  470527
  472784
  474021
  474688
  475194
  477073
  477470
  477553
  477554
  484571
  484636
  484818
  485597
  486706
  488571
  491508
  491664
  491776
  492273
  494171
  494276
  500971
  506195
  508156
  509810
  509879
  510821
  512447
  512538
  513710
  513979
  515329
  516103
  517847
  518206
  518558
  519985
  521738
  522871
  522976
  523567
  524417
  524628
  528791
  529855
  530024
  530030
  530053
  530487
  530637
  530694
  530703
  530808
  531174
  532762
  534027
  537584
  537595
  541644
  541721
  542148
  543848
  545785
  548552
  550315
  556774
  558601
  559886
  560429
  561136
  561140
  561142
  561814
  567347
  575806
  576079
  576219
  576371
  576372
  582972
  583512
  583670
  583722
  587879
  590584
  593863
  605636
  609958
  610692
  610786
  628312
  632383
  640770
  642723
  644691
  647952
  650380
  653889
  782030
  794944
]
1.91 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bondage blowjob mmf"
]
1.70 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм минет оральн секс мжм секс втро"
]
1.51 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм минет оральн секс мжм секс втро"
]
1.48 ms
(0.84%)
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.