Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
418.66 ms
(70.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob and slave"
]
145.57 ms
(24.56%)
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
  398888
  417866
  418538
  422805
  423563
  425118
  426368
  435207
  436358
  439432
  439575
  440581
  440991
  442239
  442280
  442642
  443183
  443383
  447803
  448713
  451563
  462504
  462811
  465484
  466356
  469700
  470420
  471934
  472784
  476107
  483487
  484571
  485315
  486522
  486706
  487390
  489092
  491365
  492762
  496259
  497899
  499990
  502277
  503690
  504651
  505398
  506496
  506783
  508699
  509321
  509406
  511238
  512610
  514119
  514709
  514818
  516245
  516307
  516351
  516610
  516652
  516763
  518003
  518206
  518558
  519729
  519771
  520037
  520630
  522130
  522460
  523189
  523856
  524029
  524155
  524207
  525339
  527247
  527280
  528640
  528791
  530010
  530024
  530763
  530771
  530805
  531114
  531419
  532792
  532948
  533368
  533738
  535584
  536586
  536748
  537885
  538077
  540785
  543471
  543855
  543860
  552608
  558017
  561114
  561117
  562066
  562374
  565247
  565423
  567597
  569452
  580290
  581843
  602655
  605443
  641667
  649545
  666540
  678495
  687484
]
20.98 ms
(3.54%)
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
  470420
  524207
  524155
  525339
  530771
  516610
  523856
  522460
  518003
  605443
  530763
  485315
  443183
  486522
  511238
  558017
  462811
  442642
  519729
  436358
  435207
  417866
  530010
  506496
  532792
  533368
  536748
  497899
  514709
  523189
  531114
  532948
  516307
  543855
  561117
  422805
  443383
  516351
  519771
  508699
  514119
  483487
  516652
  552608
  499990
  496259
  569452
  487390
  543860
  602655
  687484
  537885
  522130
  536586
  649545
  641667
  442239
  439432
  425118
  466356
  469700
  509406
  543471
  418538
  462504
  520630
  581843
  666540
  561114
  565247
  439575
  476107
  520037
  528791
  472784
  518206
  524029
  518558
  502277
  505398
  512610
  528640
  514818
  530024
  426368
  423563
  540785
  448713
  492762
  533738
  516763
  530805
  451563
  447803
  484571
  486706
  504651
  509321
  465484
  398888
  562066
  440581
  442280
  471934
  489092
  527247
  503690
  506783
  567597
  516245
  531419
  535584
  580290
  562374
  565423
  678495
  440991
  527280
  538077
  491365
]
2.73 ms
(0.46%)
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
  398888
  417866
  418538
  422805
  423563
  425118
  426368
  435207
  436358
  439432
  439575
  440581
  440991
  442239
  442280
  442642
  443183
  443383
  447803
  448713
  451563
  462504
  462811
  465484
  466356
  469700
  470420
  471934
  472784
  476107
  483487
  484571
  485315
  486522
  486706
  487390
  489092
  491365
  492762
  496259
  497899
  499990
  502277
  503690
  504651
  505398
  506496
  506783
  508699
  509321
  509406
  511238
  512610
  514119
  514709
  514818
  516245
  516307
  516351
  516610
  516652
  516763
  518003
  518206
  518558
  519729
  519771
  520037
  520630
  522130
  522460
  523189
  523856
  524029
  524155
  524207
  525339
  527247
  527280
  528640
  528791
  530010
  530024
  530763
  530771
  530805
  531114
  531419
  532792
  532948
  533368
  533738
  535584
  536586
  536748
  537885
  538077
  540785
  543471
  543855
  543860
  552608
  558017
  561114
  561117
  562066
  562374
  565247
  565423
  567597
  569452
  580290
  581843
  602655
  605443
  641667
  649545
  666540
  678495
  687484
]
1.71 ms
(0.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член доминирован"
]
1.48 ms
(0.25%)
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.