Query Metrics
7
Database Queries
7
Different statements
203.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.12 ms (87.73%) |
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 23815 123769 187956 329840 382671 383477 385638 410993 484063 512541 517605 517822 526204 526214 526264 530236 531914 532901 541901 543446 584017 589592 589718 590856 591289 595894 602998 603407 603539 611315 614194 618288 618612 618674 619604 620341 625171 625172 630654 631208 633548 663362 663478 663911 664848 664964 665260 665421 665478 666102 667195 667559 667640 667682 667974 669749 716297 719915 725451 725461 726078 728619 744992 745434 745975 747062 753023 754970 763134 766709 774410 781803 781805 781811 781814 781843 781845 781858 781872 781897 781903 781931 781967 781977 782002 792550 792625 793306 796619 797478 797525 801091 802748 802903 803784 805632 807589 807914 808071 811013 811124 812080 813310 813395 813825 814575 818446 819092 819271 819336 820280 823984 824495 824520 824622 825070 825384 826886 827013 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (7.26%) |
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 532901 667195 803784 807589 802903 753023 797478 595894 797525 766709 589718 811013 782002 811124 725451 792550 725461 590856 603539 631208 614194 620341 619604 618612 807914 618288 611315 517822 526264 591289 625171 603407 541901 526214 618674 512541 589592 382671 827013 602998 781845 802748 633548 630654 526204 824520 824622 812080 329840 410993 823984 667640 805632 187956 484063 663362 663478 625172 824495 826886 825070 663911 667559 665478 781931 781872 781811 781903 745434 23815 665421 813825 669749 745975 584017 819336 543446 781858 763134 754970 801091 813310 813395 781967 747062 781843 726078 383477 667269 818446 814575 667682 781803 781977 716297 123769 666102 664848 385638 531914 781814 728619 825384 774410 819092 820280 819271 530236 517605 664964 719915 667974 665260 781805 793306 808071 796619 781897 792625 744992 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.59%) |
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 23815 123769 187956 329840 382671 383477 385638 410993 484063 512541 517605 517822 526204 526214 526264 530236 531914 532901 541901 543446 584017 589592 589718 590856 591289 595894 602998 603407 603539 611315 614194 618288 618612 618674 619604 620341 625171 625172 630654 631208 633548 663362 663478 663911 664848 664964 665260 665421 665478 666102 667195 667559 667640 667682 667974 669749 716297 719915 725451 725461 726078 728619 744992 745434 745975 747062 753023 754970 763134 766709 774410 781803 781805 781811 781814 781843 781845 781858 781872 781897 781903 781931 781967 781977 782002 792550 792625 793306 796619 797478 797525 801091 802748 802903 803784 805632 807589 807914 808071 811013 811124 812080 813310 813395 813825 814575 818446 819092 819271 819336 820280 823984 824495 824520 824622 825070 825384 826886 827013 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbw blow job"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbw минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbw минет оральн секс"
]
|
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.