Query Metrics
7
Database Queries
7
Different statements
193.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.74 ms (87.65%) |
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 14599 14806 29166 81565 161358 362615 381790 386024 388004 395456 396107 396540 396575 396781 397648 399386 401379 405812 409066 420116 420499 427033 430380 430770 445730 446994 451431 459731 461718 461755 465669 468089 468475 475731 479703 480357 503036 517407 521631 526453 529664 530304 533305 536725 547364 547650 554834 561237 579195 585365 587081 594535 595214 596919 597111 597678 599006 604464 605244 608083 616561 622582 630621 633609 634523 635202 640331 641075 649863 673731 680030 681511 682675 683404 700468 701309 701406 705702 708667 717162 720667 720889 722489 722549 724536 725676 729890 732767 737470 738926 743935 751309 757458 761083 770544 774243 774524 775607 783053 784740 787215 787402 788194 788835 790988 792587 793923 794560 798601 804597 807142 807173 809000 810122 811727 813459 813584 822286 822419 ] |
||||||||||||||||||||||||||||||
|
14.40 ms (7.43%) |
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 634523 722549 81565 395456 397648 430770 396540 517407 533305 809000 725676 701309 708667 596919 605244 798601 738926 761083 701406 788194 521631 821926 445730 465669 547650 720667 649863 579195 595214 790988 787215 811727 751309 743935 381790 468089 14806 446994 480357 420116 161358 14599 396575 430380 409066 822286 468475 526453 530304 536725 529664 461755 479703 554834 561237 717162 673731 680030 681511 683404 705702 720889 722489 635202 585365 597678 604464 599006 622582 641075 804597 774524 775607 794560 737470 787402 792587 724536 732767 774243 757458 608083 630621 633609 784740 396107 399386 405812 362615 396781 459731 451431 388004 401379 427033 475731 386024 29166 822419 813584 503036 461718 700468 682675 547364 640331 587081 594535 597111 616561 807173 793923 807142 729890 788835 813459 770544 783053 810122 420499 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.55%) |
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 14599 14806 29166 81565 161358 362615 381790 386024 388004 395456 396107 396540 396575 396781 397648 399386 401379 405812 409066 420116 420499 427033 430380 430770 445730 446994 451431 459731 461718 461755 465669 468089 468475 475731 479703 480357 503036 517407 521631 526453 529664 530304 533305 536725 547364 547650 554834 561237 579195 585365 587081 594535 595214 596919 597111 597678 599006 604464 605244 608083 616561 622582 630621 633609 634523 635202 640331 641075 649863 673731 680030 681511 682675 683404 700468 701309 701406 705702 708667 717162 720667 720889 722489 722549 724536 725676 729890 732767 737470 738926 743935 751309 757458 761083 770544 774243 774524 775607 783053 784740 787215 787402 788194 788835 790988 792587 793923 794560 798601 804597 807142 807173 809000 810122 811727 813459 813584 822286 822419 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black black girls"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black black девушк"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black black девушк"
]
|
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.