Query Metrics
7
Database Queries
7
Different statements
159.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.23 ms (84.10%) |
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 282430 382285 382519 386936 387015 388198 389551 406816 423595 423782 424560 428595 428596 433815 434566 437239 443523 443992 445413 445784 447273 447735 449379 450435 453618 453791 457014 457761 459855 461316 463501 467373 468399 473784 475478 476935 478482 479756 495673 504393 505716 509859 509975 510061 510474 511683 511811 524225 525126 536275 543501 552584 554929 560952 561861 562618 564423 564524 569097 576560 583022 591393 591750 594261 595115 595868 602627 602847 610504 610825 611252 618533 618852 619470 620597 623856 624160 624162 630937 632983 636428 646183 653461 653854 655071 660048 662203 664558 666049 669430 669763 670848 671342 672192 674815 690490 691242 695893 712859 713206 717314 720042 722101 724483 727923 728802 737786 744958 746983 753575 760955 766786 776310 777168 788402 796950 800474 801942 803244 806715 ] |
||||||||||||||||||||||||||||||
|
16.05 ms (10.05%) |
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 583022 560952 561861 564524 660048 671342 672192 674815 720042 653854 655071 669430 690490 722101 662203 691242 712859 576560 602627 632983 610504 611252 591393 618533 623856 806715 776310 796950 737786 760955 766786 728802 744958 746983 753575 630937 713206 777168 788402 803244 382285 382519 389551 406816 453618 468399 386936 433815 387015 461316 423595 443523 478482 524225 504393 505716 509859 509975 569097 443992 434566 428595 428596 447273 449379 450435 453791 457014 475478 459855 495673 510474 511811 536275 510061 525126 511683 463501 543501 552584 562618 554929 564423 646183 664558 669763 695893 653461 666049 670848 602847 610825 619470 624162 636428 594261 618852 624160 591750 595115 595868 800474 801942 724483 727923 620597 717314 445413 447735 457761 423782 445784 476935 479756 282430 437239 467373 473784 388198 424560 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.78%) |
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 282430 382285 382519 386936 387015 388198 389551 406816 423595 423782 424560 428595 428596 433815 434566 437239 443523 443992 445413 445784 447273 447735 449379 450435 453618 453791 457014 457761 459855 461316 463501 467373 468399 473784 475478 476935 478482 479756 495673 504393 505716 509859 509975 510061 510474 511683 511811 524225 525126 536275 543501 552584 554929 560952 561861 562618 564423 564524 569097 576560 583022 591393 591750 594261 595115 595868 602627 602847 610504 610825 611252 618533 618852 619470 620597 623856 624160 624162 630937 632983 636428 646183 653461 653854 655071 660048 662203 664558 666049 669430 669763 670848 671342 672192 674815 690490 691242 695893 712859 713206 717314 720042 722101 724483 727923 728802 737786 744958 746983 753575 760955 766786 776310 777168 788402 796950 800474 801942 803244 806715 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girlfriend teen"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"girlfriend teen"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"girlfriend teen"
]
|
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.