Query Metrics
7
Database Queries
7
Different statements
174.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.46 ms (85.76%) |
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 4387 6965 263536 382846 387543 388309 392184 404402 424394 429901 439439 440265 441499 445828 455745 456816 465246 472814 478103 487862 488984 494174 504024 525351 527223 529609 535359 535408 545867 547941 552497 554709 555601 556093 560493 561306 564227 567891 568612 571155 576493 578713 579523 579564 584360 592408 592741 606022 607017 611541 617242 619012 619646 626411 628669 628709 633563 635569 655601 670835 670839 685389 685527 689266 690153 692437 695375 700925 704602 705790 710890 712549 712785 714050 715085 717548 717900 718703 718717 719314 721982 722019 724023 724068 724169 730418 732584 732629 732865 734261 735235 739718 739975 740238 740761 744099 745074 747497 759155 767166 780884 784104 786588 789650 789672 798737 798760 798819 798857 800663 801306 802023 803841 819817 824580 826901 828155 828175 828286 828406 ] |
||||||||||||||||||||||||||||||
|
14.89 ms (8.55%) |
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 568612 718717 547941 554709 611541 592741 789650 798857 734261 740761 740238 735235 633563 780884 800663 798760 561306 529609 576493 717548 655601 710890 717900 724023 719314 722019 789672 392184 759155 826901 828406 828155 828286 798737 455745 263536 606022 714050 628709 767166 747497 724169 744099 382846 571155 692437 404402 712785 724068 445828 387543 798819 628669 535408 465246 578713 440265 429901 456816 487862 564227 670835 670839 619012 828175 592408 579523 472814 690153 525351 527223 441499 824580 700925 715085 730418 721982 6965 388309 685527 488984 819817 552497 556093 718703 626411 535359 560493 567891 689266 584360 635569 619646 786588 784104 739718 732584 745074 617242 607017 4387 504024 802023 545867 705790 732629 739975 704602 494174 685389 424394 439439 712549 803841 555601 695375 478103 579564 732865 801306 ] |
||||||||||||||||||||||||||||||
|
2.77 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 4387 6965 263536 382846 387543 388309 392184 404402 424394 429901 439439 440265 441499 445828 455745 456816 465246 472814 478103 487862 488984 494174 504024 525351 527223 529609 535359 535408 545867 547941 552497 554709 555601 556093 560493 561306 564227 567891 568612 571155 576493 578713 579523 579564 584360 592408 592741 606022 607017 611541 617242 619012 619646 626411 628669 628709 633563 635569 655601 670835 670839 685389 685527 689266 690153 692437 695375 700925 704602 705790 710890 712549 712785 714050 715085 717548 717900 718703 718717 719314 721982 722019 724023 724068 724169 730418 732584 732629 732865 734261 735235 739718 739975 740238 740761 744099 745074 747497 759155 767166 780884 784104 786588 789650 789672 798737 798760 798819 798857 800663 801306 802023 803841 819817 824580 826901 828155 828175 828286 828406 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife public anal"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен на улиц анал"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.