Query Metrics
7
Database Queries
7
Different statements
146.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.77 ms (83.96%) |
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 384945 387680 388127 392814 397135 441211 458779 460398 476980 479712 484153 521900 525299 533224 572277 588003 588121 588906 595743 599597 601554 603173 605819 606379 606950 619997 620666 621777 626235 627619 627690 627692 628912 629784 638500 643569 649072 656619 660652 660716 665332 666103 668084 668189 671628 672213 677913 678415 689180 689571 689981 690517 690558 691226 692380 693214 695057 697234 697937 697969 698482 699135 703352 718326 720310 720323 724306 726722 730030 735207 737491 739417 742875 743464 755144 755581 759711 761392 763991 766495 767820 771455 778145 779030 781100 781622 782115 782767 783064 783677 783816 784798 786636 787050 788449 790157 791454 791509 791537 792446 793332 794792 795765 798793 800889 801122 801466 804884 805007 811151 812321 813097 813596 813635 818438 819444 823704 825201 825952 827654 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (8.74%) |
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 699135 588003 595743 599597 787050 811151 812321 786636 788449 755144 783064 737491 724306 763991 767820 759711 766495 626235 697969 392814 476980 387680 388127 823704 818438 825201 827654 479712 660716 677913 695057 718326 665332 666103 697234 720323 668189 672213 689180 689571 690517 691226 692380 693214 588121 621777 629784 606950 627692 781622 783816 791454 792446 795765 798793 804884 778145 779030 735207 782115 783677 791537 801122 726722 739417 771455 730030 742875 743464 761392 627690 703352 781100 794792 801466 805007 397135 460398 384945 441211 813596 813635 819444 825952 458779 484153 521900 525299 533224 649072 656619 668084 671628 689981 698482 720310 660652 678415 690558 697937 572277 619997 627619 588906 603173 605819 620666 601554 628912 606379 638500 643569 782767 790157 793332 800889 813097 755581 784798 791509 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (2.08%) |
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 384945 387680 388127 392814 397135 441211 458779 460398 476980 479712 484153 521900 525299 533224 572277 588003 588121 588906 595743 599597 601554 603173 605819 606379 606950 619997 620666 621777 626235 627619 627690 627692 628912 629784 638500 643569 649072 656619 660652 660716 665332 666103 668084 668189 671628 672213 677913 678415 689180 689571 689981 690517 690558 691226 692380 693214 695057 697234 697937 697969 698482 699135 703352 718326 720310 720323 724306 726722 730030 735207 737491 739417 742875 743464 755144 755581 759711 761392 763991 766495 767820 771455 778145 779030 781100 781622 782115 782767 783064 783677 783816 784798 786636 787050 788449 790157 791454 791509 791537 792446 793332 794792 795765 798793 800889 801122 801466 804884 805007 811151 812321 813097 813596 813635 818438 819444 823704 825201 825952 827654 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girlfriend sex"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"girlfriend секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"girlfriend секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.14%) |
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.