Query Metrics
7
Database Queries
7
Different statements
188.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.42 ms (85.69%) |
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 383638 391934 411107 428562 437585 443661 445736 445946 447670 456737 459154 460272 460689 460829 464486 472603 476593 477043 477209 477470 479889 485319 489621 491967 493299 507182 513246 514693 515335 517654 531860 533195 533227 534855 536947 536980 538902 540523 542513 542695 544771 546720 550310 554841 558309 558436 558441 558788 559875 562588 562925 566216 566431 574396 577073 577126 580751 589598 591855 594980 599792 601361 605527 605563 605573 605617 606018 609589 610060 617739 625552 627846 628600 638396 650528 654217 663271 670495 678969 703522 707297 710313 714040 716841 720298 723043 725094 726038 727406 729170 729576 732697 732953 733243 734680 738888 742671 744892 748454 759484 768578 769399 769559 776584 785298 786403 788700 789064 789217 789295 789599 795825 796468 796506 801933 802054 805533 806412 807710 809745 ] |
||||||||||||||||||||||||||||||
|
15.20 ms (8.07%) |
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 609589 796506 805533 769559 733243 491967 605527 443661 477470 558436 610060 605617 514693 606018 716841 411107 445736 445946 460272 472603 558441 515335 589598 605563 456737 574396 720298 591855 428562 477209 485319 513246 533195 476593 479889 566431 650528 580751 748454 732697 627846 383638 489621 493299 536980 536947 577073 714040 654217 670495 601361 625552 786403 809745 738888 807710 742671 769399 638396 795825 727406 538902 542695 550310 554841 562925 566216 663271 707297 599792 617739 776584 789064 789599 801933 806412 789295 768578 703522 723043 788700 802054 517654 558788 464486 544771 605573 789217 796468 725094 744892 533227 540523 559875 558309 594980 628600 729170 785298 732953 726038 729576 759484 734680 710313 460689 460829 507182 546720 391934 437585 447670 678969 459154 477043 531860 534855 542513 577126 562588 ] |
||||||||||||||||||||||||||||||
|
3.91 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 383638 391934 411107 428562 437585 443661 445736 445946 447670 456737 459154 460272 460689 460829 464486 472603 476593 477043 477209 477470 479889 485319 489621 491967 493299 507182 513246 514693 515335 517654 531860 533195 533227 534855 536947 536980 538902 540523 542513 542695 544771 546720 550310 554841 558309 558436 558441 558788 559875 562588 562925 566216 566431 574396 577073 577126 580751 589598 591855 594980 599792 601361 605527 605563 605573 605617 606018 609589 610060 617739 625552 627846 628600 638396 650528 654217 663271 670495 678969 703522 707297 710313 714040 716841 720298 723043 725094 726038 727406 729170 729576 732697 732953 733243 734680 738888 742671 744892 748454 759484 768578 769399 769559 776584 785298 786403 788700 789064 789217 789295 789599 795825 796468 796506 801933 802054 805533 806412 807710 809745 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf wife cuckold"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf жен куколд"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf жен куколд"
]
|
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.