Query Metrics
7
Database Queries
7
Different statements
197.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.55 ms (87.50%) |
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 78637 78760 274100 384138 387885 392589 427183 441550 456174 456859 460418 476619 477445 484721 504139 530286 530289 531860 533050 536219 536305 536958 536977 542766 543658 543688 543950 545014 545067 545106 547939 547980 551524 555653 556952 557069 566445 568180 575667 580413 583715 583943 585583 591151 592708 593075 593843 596906 603625 604698 604985 605485 605583 606471 606772 616368 621777 622089 624985 625117 630264 630668 631986 632048 632423 633179 635384 635634 636066 636550 640233 640727 641134 642524 643927 648984 651287 653619 653620 653628 663328 664481 667075 671243 676788 681530 683457 690885 691675 691731 691739 692452 693789 694346 695784 696794 702302 705398 712651 714126 717372 717417 719963 722104 725094 726311 727725 729170 732592 732644 732760 733045 736727 737028 741152 748441 749639 755134 761504 807186 ] |
||||||||||||||||||||||||||||||
|
14.07 ms (7.13%) |
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 456859 536958 568180 566445 733045 533050 456174 460418 605485 531860 543688 593075 616368 545067 536305 583715 664481 717372 717417 593843 732644 741152 580413 729170 732760 732592 635634 427183 530286 575667 651287 693789 653620 712651 695784 636066 640727 543658 622089 78760 504139 547980 690885 545106 591151 604985 749639 807186 274100 78637 551524 585583 725094 761504 748441 392589 737028 530289 536219 702302 653628 691731 603625 630668 592708 640233 631986 643927 542766 477445 671243 694346 648984 667075 705398 681530 696794 621777 633179 635384 642524 605583 606471 624985 630264 726311 736727 484721 692452 384138 441550 543950 583943 556952 596906 755134 719963 476619 722104 727725 536977 547939 683457 653619 663328 691739 632423 545014 604698 606772 691675 555653 641134 387885 676788 714126 557069 625117 632048 636550 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.36%) |
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 78637 78760 274100 384138 387885 392589 427183 441550 456174 456859 460418 476619 477445 484721 504139 530286 530289 531860 533050 536219 536305 536958 536977 542766 543658 543688 543950 545014 545067 545106 547939 547980 551524 555653 556952 557069 566445 568180 575667 580413 583715 583943 585583 591151 592708 593075 593843 596906 603625 604698 604985 605485 605583 606471 606772 616368 621777 622089 624985 625117 630264 630668 631986 632048 632423 633179 635384 635634 636066 636550 640233 640727 641134 642524 643927 648984 651287 653619 653620 653628 663328 664481 667075 671243 676788 681530 683457 690885 691675 691731 691739 692452 693789 694346 695784 696794 702302 705398 712651 714126 717372 717417 719963 722104 725094 726311 727725 729170 732592 732644 732760 733045 736727 737028 741152 748441 749639 755134 761504 807186 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swinger wife amateur"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"свингер жен любительск"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.87%) |
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.