Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.67 ms
(53.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие член латинская"
]
160.52 ms
(41.02%)
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
  21478
  31604
  192951
  320786
  370875
  373905
  382488
  384811
  387604
  388224
  392266
  392928
  394768
  394772
  394874
  395273
  395310
  398230
  403458
  403476
  403495
  403543
  404664
  406080
  406281
  407322
  408206
  410452
  411895
  414209
  415476
  416092
  419150
  420131
  426612
  429278
  445554
  446697
  450673
  451827
  452380
  454642
  454948
  460011
  462914
  463726
  464601
  464926
  465034
  469105
  473459
  475993
  476600
  479874
  485616
  486698
  487972
  488324
  492065
  493278
  505061
  506352
  509729
  514381
  516848
  520256
  525144
  525896
  528700
  530059
  530574
  532487
  533029
  533475
  536828
  536861
  536911
  545269
  547066
  550062
  555754
  569124
  592238
  597757
  629610
  632936
  635124
  642634
  665902
  720206
  724556
  726826
  729975
  731694
  740526
  750691
  752407
  755759
  762820
  788248
  799312
  804968
  810225
  810227
  810624
  812821
  812825
  813112
  813693
  814651
  814719
  820950
  821997
  822246
  822653
  822885
  823118
  823200
  825377
]
15.02 ms
(3.84%)
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
  729975
  762820
  530574
  476600
  629610
  810624
  384811
  394768
  395310
  392266
  320786
  21478
  403476
  403458
  406080
  416092
  429278
  823200
  473459
  487972
  454948
  460011
  493278
  505061
  509729
  530059
  533475
  506352
  525896
  532487
  536828
  463726
  469105
  547066
  812825
  750691
  426612
  415476
  525144
  812821
  814651
  822246
  814719
  813693
  822885
  820950
  665902
  642634
  592238
  597757
  799312
  632936
  31604
  465034
  545269
  810227
  775033
  752407
  731694
  395273
  408206
  446697
  479874
  488324
  492065
  462914
  536911
  724556
  419150
  420131
  410452
  804968
  394874
  569124
  403543
  822653
  823118
  821997
  373905
  394772
  450673
  514381
  825377
  398230
  720206
  536861
  516848
  635124
  406281
  392928
  192951
  370875
  388224
  387604
  404664
  411895
  414209
  445554
  454642
  486698
  451827
  464601
  485616
  475993
  520256
  528700
  533029
  755759
  452380
  464926
  403495
  555754
  550062
  726826
  382488
  813112
  407322
  810225
  788248
  740526
]
2.76 ms
(0.70%)
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
  21478
  31604
  192951
  320786
  370875
  373905
  382488
  384811
  387604
  388224
  392266
  392928
  394768
  394772
  394874
  395273
  395310
  398230
  403458
  403476
  403495
  403543
  404664
  406080
  406281
  407322
  408206
  410452
  411895
  414209
  415476
  416092
  419150
  420131
  426612
  429278
  445554
  446697
  450673
  451827
  452380
  454642
  454948
  460011
  462914
  463726
  464601
  464926
  465034
  469105
  473459
  475993
  476600
  479874
  485616
  486698
  487972
  488324
  492065
  493278
  505061
  506352
  509729
  514381
  516848
  520256
  525144
  525896
  528700
  530059
  530574
  532487
  533029
  533475
  536828
  536861
  536911
  545269
  547066
  550062
  555754
  569124
  592238
  597757
  629610
  632936
  635124
  642634
  665902
  720206
  724556
  726826
  729975
  731694
  740526
  750691
  752407
  755759
  762820
  788248
  799312
  804968
  810225
  810227
  810624
  812821
  812825
  813112
  813693
  814651
  814719
  820950
  821997
  822246
  822653
  822885
  823118
  823200
  825377
]
1.89 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big dick latina"
]
1.83 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.