Query Metrics
7
Database Queries
7
Different statements
193.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.05 ms (86.16%) |
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 233335 233410 327965 371790 381923 381962 386583 386996 390259 391513 391774 423951 426124 426731 428360 453206 461955 466000 470761 473692 478513 493363 493484 523690 528575 535972 537778 541264 541307 541518 547191 551051 551600 551794 554941 556464 558516 559510 560010 560361 562214 564502 575221 577999 578487 579184 579187 596179 600288 603463 609769 613622 621588 653479 653974 662212 663699 670405 678621 678714 685180 686453 691686 693424 693875 701964 705654 706553 709682 711715 711734 712361 712955 717716 718537 722248 722326 736065 739930 741170 741257 751043 751293 751679 754355 754540 755892 756149 764736 772987 774081 776063 778104 779254 781270 782900 782908 783288 785904 786198 789231 791340 793057 793259 795665 799838 799845 805073 809943 810904 812215 812243 812402 812668 813702 813942 819106 820088 825807 827970 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (7.95%) |
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 551051 685180 712955 653479 609769 799845 812215 772987 741257 751293 778104 712361 717716 233335 381962 327965 426124 428360 795665 453206 470761 579184 371790 386583 523690 578487 478513 386996 461955 528575 390259 233410 564502 426731 391774 423951 466000 577999 781270 537778 551794 754540 813702 547191 621588 785904 809943 791340 810904 793057 782900 381923 813942 819106 827970 493363 535972 556464 541518 554941 560010 579187 701964 722248 670405 678621 705654 693424 709682 711734 558516 559510 575221 596179 600288 789231 736065 812243 739930 751679 755892 754355 756149 764736 774081 751043 603463 711715 722326 783288 741170 493484 391513 820088 825807 473692 551600 562214 541264 541307 560361 653974 662212 686453 691686 706553 663699 678714 693875 718537 613622 779254 786198 793259 799838 812402 812668 776063 782908 805073 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (1.95%) |
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 233335 233410 327965 371790 381923 381962 386583 386996 390259 391513 391774 423951 426124 426731 428360 453206 461955 466000 470761 473692 478513 493363 493484 523690 528575 535972 537778 541264 541307 541518 547191 551051 551600 551794 554941 556464 558516 559510 560010 560361 562214 564502 575221 577999 578487 579184 579187 596179 600288 603463 609769 613622 621588 653479 653974 662212 663699 670405 678621 678714 685180 686453 691686 693424 693875 701964 705654 706553 709682 711715 711734 712361 712955 717716 718537 722248 722326 736065 739930 741170 741257 751043 751293 751679 754355 754540 755892 756149 764736 772987 774081 776063 778104 779254 781270 782900 782908 783288 785904 786198 789231 791340 793057 793259 795665 799838 799845 805073 809943 810904 812215 812243 812402 812668 813702 813942 819106 820088 825807 827970 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian solo girl"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск соло девушк"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск соло девушк"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
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.