Query Metrics
7
Database Queries
7
Different statements
226.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.10 ms (89.33%) |
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 394053 444707 450672 458070 473095 476848 483573 490134 509526 530066 532454 536100 538472 538474 558402 579421 584517 590804 591320 592528 592752 593932 602291 602511 603802 604181 604696 605798 606372 607782 607900 608088 610610 616194 636087 638751 648167 662172 662415 662833 664229 664409 669855 670960 677104 679190 682642 687913 693490 697194 700055 700735 703263 709355 709773 711249 715176 723368 724909 728702 729034 732201 734790 736735 736973 738145 738640 739071 740876 741824 741892 744044 744907 745540 745649 745974 746381 746902 747269 747433 750520 751417 753760 762246 765431 765678 765704 768648 771643 777337 778395 781011 784083 784114 786284 787947 788147 788707 789129 791130 792309 792460 794192 794514 796049 796375 796539 797325 797852 800380 805773 806054 807434 809681 809951 812038 813370 816670 818823 828798 ] |
||||||||||||||||||||||||||||||
|
13.84 ms (6.12%) |
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 777337 753760 800380 739071 746381 741892 771643 607782 473095 736973 786284 796049 797325 806054 787947 796375 724909 762246 794192 797852 765704 728702 738640 784083 741824 638751 828798 664229 538472 677104 662172 662415 664409 697194 670960 682642 610610 605798 606372 608088 636087 616194 700055 490134 584517 679190 607900 816670 530066 532454 602291 791130 794514 729034 765431 768648 788147 788707 744044 751417 734790 745540 745974 747433 750520 765678 711249 809951 450672 483573 538474 648167 792460 778395 781011 738145 807434 744907 746902 784114 789129 700735 669855 693490 703263 709773 592752 593932 604181 602511 592528 709355 603802 590804 444707 818823 558402 604696 591320 796539 736735 740876 747269 732201 715176 687913 458070 536100 476848 662833 805773 792309 813370 745649 723368 809681 812038 394053 509526 579421 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.32%) |
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 394053 444707 450672 458070 473095 476848 483573 490134 509526 530066 532454 536100 538472 538474 558402 579421 584517 590804 591320 592528 592752 593932 602291 602511 603802 604181 604696 605798 606372 607782 607900 608088 610610 616194 636087 638751 648167 662172 662415 662833 664229 664409 669855 670960 677104 679190 682642 687913 693490 697194 700055 700735 703263 709355 709773 711249 715176 723368 724909 728702 729034 732201 734790 736735 736973 738145 738640 739071 740876 741824 741892 744044 744907 745540 745649 745974 746381 746902 747269 747433 750520 751417 753760 762246 765431 765678 765704 768648 771643 777337 778395 781011 784083 784114 786284 787947 788147 788707 789129 791130 792309 792460 794192 794514 796049 796375 796539 797325 797852 800380 805773 806054 807434 809681 809951 812038 813370 816670 818823 828798 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"virgin домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"virgin homemade"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"virgin домашн любительск"
]
|
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.