Query Metrics
7
Database Queries
7
Different statements
164.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.81 ms (86.84%) |
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 388552 388559 399936 441915 455104 461075 464738 469643 476980 482053 495439 505719 525299 533713 541827 546272 548803 559748 562219 570091 574829 591232 592557 600197 609824 619682 653974 659140 660652 664759 673191 673234 683294 687835 689981 691676 692367 693355 695039 697164 697725 697765 701855 705224 705861 710880 711633 715435 716086 721197 721211 721254 722874 723691 724732 724894 725327 725330 727060 728904 728974 730784 731835 732895 736176 736463 740561 743180 743807 743869 744738 747801 751031 754966 755130 757897 758172 759677 761681 763593 766151 768468 768528 768723 777874 778770 779301 779386 779511 779869 780240 780510 782157 783247 783442 785826 786547 786701 790923 791822 792301 792976 797824 799713 800741 800745 802881 803440 809802 811353 812458 813365 813596 817464 818003 819946 820199 820218 825392 826305 ] |
||||||||||||||||||||||||||||||
|
12.63 ms (7.68%) |
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 819946 820218 570091 697725 701855 721254 705224 664759 548803 591232 777874 780240 783442 786547 792976 800741 778770 779511 782157 783247 792301 723691 736176 736463 757897 799713 802881 803440 811353 725327 731835 759677 768723 725330 727060 728974 751031 743807 768528 732895 740561 758172 763593 711633 721197 791822 812458 469643 455104 476980 461075 388552 600197 779386 820199 464738 562219 482053 399936 388559 505719 495439 441915 813596 817464 818003 825392 826305 533713 525299 541827 546272 559748 574829 653974 673234 687835 693355 695039 697164 697765 716086 673191 689981 691676 659140 660652 683294 692367 705861 710880 715435 721211 722874 592557 619682 609824 790923 797824 800745 813365 724894 743180 743869 766151 747801 724732 728904 744738 768468 730784 754966 755130 761681 779301 779869 780510 785826 786701 809802 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.55%) |
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 388552 388559 399936 441915 455104 461075 464738 469643 476980 482053 495439 505719 525299 533713 541827 546272 548803 559748 562219 570091 574829 591232 592557 600197 609824 619682 653974 659140 660652 664759 673191 673234 683294 687835 689981 691676 692367 693355 695039 697164 697725 697765 701855 705224 705861 710880 711633 715435 716086 721197 721211 721254 722874 723691 724732 724894 725327 725330 727060 728904 728974 730784 731835 732895 736176 736463 740561 743180 743807 743869 744738 747801 751031 754966 755130 757897 758172 759677 761681 763593 766151 768468 768528 768723 777874 778770 779301 779386 779511 779869 780240 780510 782157 783247 783442 785826 786547 786701 790923 791822 792301 792976 797824 799713 800741 800745 802881 803440 809802 811353 812458 813365 813596 817464 818003 819946 820199 820218 825392 826305 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girlfriend russian"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"girlfriend русск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"girlfriend русск"
]
|
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.