Query Metrics
7
Database Queries
7
Different statements
189.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.47 ms (85.80%) |
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 120208 327981 384811 387437 413477 414753 415698 418895 420197 432928 435047 440742 442563 449091 449744 456142 459320 459942 460690 466957 470099 476990 478251 484067 486782 487162 488313 488388 494952 497946 505248 505423 517817 525775 526299 528054 528667 543231 544881 554740 569170 574084 574097 574473 575695 579553 579678 579941 579944 583947 589175 591426 595747 597665 602652 603032 604717 604789 604802 606511 617161 619852 620645 653272 670003 680588 693567 694044 704952 709181 714498 717278 717298 717984 719143 721140 722628 722847 722850 723131 726067 727650 728899 729781 747090 748339 748343 748752 758124 758482 761557 761561 763309 769354 775054 775127 778383 780046 781573 786414 786705 787209 788979 790761 792396 793311 799528 800071 801341 802552 803589 804817 804864 805867 806271 807358 809887 815461 820662 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (8.91%) |
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 748752 788979 809887 476990 717298 505248 761557 449744 466957 575695 775054 793311 800071 327981 815461 728899 747090 484067 470099 620645 595747 804864 761561 790761 680588 694044 693567 717278 583947 589175 442563 494952 748343 456142 820662 120208 459320 579941 604789 807358 758124 801341 709181 780046 525775 758482 449091 543231 670003 717984 606511 729781 721140 528054 387437 517817 579553 574473 597665 748339 418895 413477 440742 528667 526299 574097 579944 653272 714498 544881 569170 579678 591426 603032 781573 792396 804817 726067 763309 619852 775127 787209 803589 435047 459942 486782 806271 415698 723131 604802 487162 460690 722628 554740 604717 778383 786705 805867 786414 769354 772131 799528 802552 420197 478251 722847 384811 414753 432928 497946 488313 704952 574084 602652 617161 505423 488388 722850 727650 719143 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.58%) |
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 120208 327981 384811 387437 413477 414753 415698 418895 420197 432928 435047 440742 442563 449091 449744 456142 459320 459942 460690 466957 470099 476990 478251 484067 486782 487162 488313 488388 494952 497946 505248 505423 517817 525775 526299 528054 528667 543231 544881 554740 569170 574084 574097 574473 575695 579553 579678 579941 579944 583947 589175 591426 595747 597665 602652 603032 604717 604789 604802 606511 617161 619852 620645 653272 670003 680588 693567 694044 704952 709181 714498 717278 717298 717984 719143 721140 722628 722847 722850 723131 726067 727650 728899 729781 747090 748339 748343 748752 758124 758482 761557 761561 763309 769354 775054 775127 778383 780046 781573 786414 786705 787209 788979 790761 792396 793311 799528 800071 801341 802552 803589 804817 804864 805867 806271 807358 809887 815461 820662 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facial blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"facial минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"facial минет оральн секс"
]
|
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.