Query Metrics
7
Database Queries
7
Different statements
221.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.71 ms (88.27%) |
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 46580 187956 384518 393476 396040 396397 396814 397498 401666 402450 406372 407570 409820 415551 419653 426608 428610 428756 439034 439822 442664 444433 445771 459446 461628 465780 466831 469559 470406 473211 473921 476180 478043 478644 482981 484404 493245 501534 508442 517617 524096 525085 532846 537216 537665 548116 554552 564543 577087 580626 582708 584112 589070 590063 604327 604340 605825 608121 616036 620310 626316 630082 632578 637853 643263 651837 659052 670900 685949 696232 700930 701005 707181 711728 711802 716189 720099 720111 720195 720715 722011 723300 723911 724739 725009 725156 727764 728356 734411 734452 740000 742852 746627 749865 750141 750269 751585 754034 758971 759914 761046 761573 761701 761712 761718 762085 762902 764161 764198 774188 775377 790900 795977 798823 804758 805706 813067 817308 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (7.08%) |
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 476180 620310 804758 554552 584112 589070 397498 548116 711728 670900 722011 723300 604340 630082 637853 734411 734452 740000 761701 724739 764198 749865 720715 396040 700930 716189 384518 187956 651837 696232 564543 775377 790900 805706 761718 580626 632578 439822 762085 537665 402450 470406 604327 751585 409820 524096 798823 728356 764161 761712 439034 701005 750269 754034 406372 459446 532846 746627 396397 401666 415551 473921 21478 426608 711802 626316 725009 725156 742852 750141 396814 817308 537216 774188 428610 445771 469559 478644 720111 616036 525085 685949 605825 428756 393476 707181 758971 727764 720195 407570 442664 444433 466831 473211 482981 461628 517617 720099 643263 761573 761046 723911 762902 512847 484404 501534 493245 46580 813067 419653 465780 478043 508442 659052 608121 590063 759914 795977 582708 577087 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.30%) |
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 46580 187956 384518 393476 396040 396397 396814 397498 401666 402450 406372 407570 409820 415551 419653 426608 428610 428756 439034 439822 442664 444433 445771 459446 461628 465780 466831 469559 470406 473211 473921 476180 478043 478644 482981 484404 493245 501534 508442 517617 524096 525085 532846 537216 537665 548116 554552 564543 577087 580626 582708 584112 589070 590063 604327 604340 605825 608121 616036 620310 626316 630082 632578 637853 643263 651837 659052 670900 685949 696232 700930 701005 707181 711728 711802 716189 720099 720111 720195 720715 722011 723300 723911 724739 725009 725156 727764 728356 734411 734452 740000 742852 746627 749865 750141 750269 751585 754034 758971 759914 761046 761573 761701 761712 761718 762085 762902 764161 764198 774188 775377 790900 795977 798823 804758 805706 813067 817308 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big anal ass"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие анал жоп"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.