Query Metrics
7
Database Queries
7
Different statements
195.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.71 ms (85.40%) |
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 30958 266061 284922 381855 386627 386938 388390 389431 389593 389745 390320 390723 398804 425668 438369 440680 444336 448596 453299 454707 454755 457092 457593 464874 466002 473184 476137 476430 485336 489431 497920 499177 500441 507451 509673 521046 522813 524388 524594 524653 524680 525955 529975 541418 544472 544753 544788 544834 547717 551650 552848 557611 558219 558581 560791 565021 567742 570351 570500 571553 571854 572083 572381 572799 575441 589360 589545 591348 591948 594053 598388 598947 601679 602470 602594 616136 617785 623327 624204 624207 624729 626355 641096 642331 644276 650016 652906 653260 654151 673027 684847 704865 743610 755085 756202 767025 770899 774215 776570 783291 784657 790927 794035 797798 797893 800198 802783 810245 810681 812987 817039 817781 819232 ] |
||||||||||||||||||||||||||||||
|
17.99 ms (9.22%) |
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 653260 704865 589545 819232 572799 567742 654151 652906 684847 797893 755085 794035 756202 774215 398804 650016 644276 448596 570351 571854 673027 616136 522813 544788 284922 30958 389431 817039 591948 776570 790927 457593 524653 454707 453299 507451 571553 572083 623327 802783 386938 817781 521046 524594 558219 570500 572381 594053 598947 589360 626355 810681 810245 641096 797798 266061 381855 389593 509673 386627 464874 565021 598388 601679 602470 642331 617785 800198 812987 770899 783291 466002 444336 390320 438369 454755 457092 497920 499177 388390 425668 485336 529975 544753 560791 767025 743610 784657 390723 524680 500441 389745 489431 552848 558581 575441 551650 557611 544834 624207 624729 591348 476430 525955 440680 541418 624204 476137 547717 602594 524388 473184 544472 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.69%) |
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 30958 266061 284922 381855 386627 386938 388390 389431 389593 389745 390320 390723 398804 425668 438369 440680 444336 448596 453299 454707 454755 457092 457593 464874 466002 473184 476137 476430 485336 489431 497920 499177 500441 507451 509673 521046 522813 524388 524594 524653 524680 525955 529975 541418 544472 544753 544788 544834 547717 551650 552848 557611 558219 558581 560791 565021 567742 570351 570500 571553 571854 572083 572381 572799 575441 589360 589545 591348 591948 594053 598388 598947 601679 602470 602594 616136 617785 623327 624204 624207 624729 626355 641096 642331 644276 650016 652906 653260 654151 673027 684847 704865 743610 755085 756202 767025 770899 774215 776570 783291 784657 790927 794035 797798 797893 800198 802783 810245 810681 812987 817039 817781 819232 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy babe"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy babe"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy babe"
]
|
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.