Query Metrics
7
Database Queries
7
Different statements
155.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.47 ms (83.77%) |
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 381875 416928 426712 429792 431522 431537 431954 433589 442168 442864 445261 449855 453600 454129 458329 460781 461288 461346 461359 462685 462717 463176 466489 470395 472297 473609 474831 475441 476921 482148 487448 504042 512039 516828 518106 519849 523774 523793 526763 530886 531368 533209 534778 545052 545725 545865 557883 557961 558786 559717 562058 562718 562720 571711 577106 578565 579485 584087 584995 585012 586215 587110 590868 590906 591402 592750 593678 598185 600049 600973 608744 613815 615675 628185 628654 630638 632013 632031 637280 639975 648939 650634 654201 654289 654688 682914 692854 725297 762487 769971 770800 773981 778785 790862 792343 793593 795148 797152 797162 805181 805216 805276 807889 808257 809256 809317 809574 809620 809635 809663 810192 810967 811755 811964 813662 821469 821847 821849 827304 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (9.64%) |
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 584995 585012 470395 474831 809256 809663 725297 793593 805181 590906 827304 807889 795148 650634 571711 577106 805216 654201 584087 530886 648939 797152 779185 773981 472297 654688 431954 462685 545725 523774 458329 591402 562718 810192 534778 557961 523793 431522 813662 512039 692854 562720 805276 809620 809635 762487 579485 559717 637280 790862 545052 557883 810967 809317 519849 654289 630638 613815 808257 586215 475441 433589 608744 615675 797162 473609 682914 811755 600049 562058 461359 445261 533209 449855 632013 593678 809574 504042 578565 442168 639975 792343 770800 821849 453600 526763 592750 590868 778785 482148 431537 416928 632031 769971 462717 463176 487448 587110 821469 461346 442864 466489 516828 545865 598185 628185 628654 518106 426712 381875 531368 558786 476921 461288 811964 454129 429792 600973 821847 460781 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.94%) |
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 381875 416928 426712 429792 431522 431537 431954 433589 442168 442864 445261 449855 453600 454129 458329 460781 461288 461346 461359 462685 462717 463176 466489 470395 472297 473609 474831 475441 476921 482148 487448 504042 512039 516828 518106 519849 523774 523793 526763 530886 531368 533209 534778 545052 545725 545865 557883 557961 558786 559717 562058 562718 562720 571711 577106 578565 579485 584087 584995 585012 586215 587110 590868 590906 591402 592750 593678 598185 600049 600973 608744 613815 615675 628185 628654 630638 632013 632031 637280 639975 648939 650634 654201 654289 654688 682914 692854 725297 762487 769971 770800 773981 778785 790862 792343 793593 795148 797152 797162 805181 805216 805276 807889 808257 809256 809317 809574 809620 809635 809663 810192 810967 811755 811964 813662 821469 821847 821849 827304 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск пов секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur pov threesome"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск пов секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.