Query Metrics
7
Database Queries
7
Different statements
158.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.90 ms (84.25%) |
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 389683 404000 405048 434992 440986 441755 441892 451166 452695 456828 461267 474502 487205 490019 490853 504461 505897 514625 523486 525900 558048 560966 564750 566051 567599 579847 595137 601508 607622 610434 612029 622871 626688 627111 628502 629179 634362 635578 654261 658555 659324 661436 662469 669313 670623 674127 674292 676375 682877 684533 685931 694661 697296 701935 704034 707915 710094 712393 716364 717412 717453 719640 721793 723776 728494 729357 731382 732822 733176 735839 736361 737511 739773 740009 740764 744493 747563 747640 751925 761650 761777 762369 763236 765099 765456 767354 767722 768725 773740 777314 777327 781403 784284 784661 787843 788359 789033 790578 791405 791416 793036 793727 795003 795120 796734 797709 799145 799830 800054 805653 807982 808964 809004 811130 813565 818835 819874 819902 820882 822479 ] |
||||||||||||||||||||||||||||||
|
14.13 ms (8.89%) |
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 389683 441892 813565 819874 819902 670623 704034 717412 685931 710094 717453 654261 658555 669313 716364 560966 595137 610434 607622 626688 629179 796734 799830 800054 811130 805653 729357 739773 808964 809004 733176 744493 765456 767722 768725 765099 751925 736361 762369 773740 627111 712393 777327 784284 788359 797709 404000 440986 490853 505897 567599 740764 728494 701935 822479 818835 566051 674127 558048 793727 767354 799145 820882 474502 564750 697296 784661 761650 735839 763236 737511 719640 461267 405048 490019 504461 451166 523486 525900 579847 682877 659324 661436 662469 674292 676375 684533 694661 601508 628502 635578 612029 634362 622871 789033 790578 777314 781403 723776 740009 761777 787843 793036 795120 747640 732822 747563 731382 707915 721793 791405 791416 795003 807982 434992 514625 441755 456828 452695 487205 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (2.56%) |
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 389683 404000 405048 434992 440986 441755 441892 451166 452695 456828 461267 474502 487205 490019 490853 504461 505897 514625 523486 525900 558048 560966 564750 566051 567599 579847 595137 601508 607622 610434 612029 622871 626688 627111 628502 629179 634362 635578 654261 658555 659324 661436 662469 669313 670623 674127 674292 676375 682877 684533 685931 694661 697296 701935 704034 707915 710094 712393 716364 717412 717453 719640 721793 723776 728494 729357 731382 732822 733176 735839 736361 737511 739773 740009 740764 744493 747563 747640 751925 761650 761777 762369 763236 765099 765456 767354 767722 768725 773740 777314 777327 781403 784284 784661 787843 788359 789033 790578 791405 791416 793036 793727 795003 795120 796734 797709 799145 799830 800054 805653 807982 808964 809004 811130 813565 818835 819874 819902 820882 822479 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real sex teens"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real секс teens"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real секс teens"
]
|
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.