Query Metrics
7
Database Queries
7
Different statements
198.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.71 ms (88.36%) |
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 80505 384104 397371 534944 535082 535189 539983 543274 545210 552875 555640 559237 583314 585343 585769 586346 586562 589923 590653 591516 594579 600871 603449 603617 604585 605701 606497 606887 608177 610711 611443 613998 619292 622086 626903 627253 631986 634298 637521 638396 641473 641870 642288 646012 650978 651268 656915 659479 660649 663270 664705 665983 666563 666733 674550 677553 682291 684430 687832 689038 689214 693776 696365 697597 699556 700858 702056 705398 706555 707145 709878 710398 712226 720311 724583 727724 730158 735252 736861 737720 740058 740663 745317 749465 749623 749756 751845 759580 761509 766300 766890 767197 768190 770417 776933 780731 786403 787117 788094 790086 790654 793664 793792 793869 794676 795606 795795 795895 796464 796811 800901 801760 805103 809347 811877 813698 817981 825201 825255 825715 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (6.49%) |
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 646012 660649 666563 693776 666733 684430 699556 702056 706555 707145 656915 555640 594579 610711 638396 586562 589923 604585 631986 641473 793792 796464 793869 749623 767197 766890 735252 749756 766300 613998 637521 700858 384104 397371 80505 825715 825255 813698 817981 825201 535189 539983 534944 535082 543274 559237 545210 651268 659479 663270 665983 677553 696365 697597 650978 682291 687832 689038 705398 709878 710398 712226 720311 664705 674550 689214 552875 583314 585769 622086 626903 641870 591516 603449 634298 586346 600871 603617 619292 642288 585343 590653 605701 606497 606887 608177 611443 627253 776933 780731 786403 788094 790086 790654 794676 795606 795795 809347 811877 787117 800901 805103 730158 737720 740058 749465 759580 793664 795895 796811 801760 724583 727724 740663 745317 761509 770417 736861 751845 768190 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.67%) |
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 80505 384104 397371 534944 535082 535189 539983 543274 545210 552875 555640 559237 583314 585343 585769 586346 586562 589923 590653 591516 594579 600871 603449 603617 604585 605701 606497 606887 608177 610711 611443 613998 619292 622086 626903 627253 631986 634298 637521 638396 641473 641870 642288 646012 650978 651268 656915 659479 660649 663270 664705 665983 666563 666733 674550 677553 682291 684430 687832 689038 689214 693776 696365 697597 699556 700858 702056 705398 706555 707145 709878 710398 712226 720311 724583 727724 730158 735252 736861 737720 740058 740663 745317 749465 749623 749756 751845 759580 761509 766300 766890 767197 768190 770417 776933 780731 786403 787117 788094 790086 790654 793664 793792 793869 794676 795606 795795 795895 796464 796811 800901 801760 805103 809347 811877 813698 817981 825201 825255 825715 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband girl"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband девушк"
]
|
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.