Query Metrics
7
Database Queries
7
Different statements
180.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.05 ms (86.68%) |
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 136203 212914 213573 388796 397862 397872 398938 402874 405494 406347 411323 411385 411399 423332 425472 428424 428890 429659 431664 437344 439307 439671 443639 451541 466044 470166 470764 470956 470962 472922 475977 477975 482335 488160 491902 492522 495877 496854 500949 501528 501663 516652 519488 525503 532927 546970 548833 560381 561024 562859 563004 563182 563483 570851 580424 599202 604907 610669 615740 618712 619474 626097 627063 650418 674620 688958 689738 695707 695738 695773 698440 699233 707429 712089 715145 715940 716149 716188 719407 725378 725507 726560 732808 733230 741577 744355 748354 748489 750198 754877 756225 757350 760056 760889 766837 767548 772072 776227 788773 789491 789757 794104 796833 799298 800012 802599 803158 804706 804710 806737 809592 809926 810970 812573 815167 815444 815566 817454 817822 825909 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (8.19%) |
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 451541 470962 429659 615740 496854 212914 707429 431664 817822 804710 466044 439671 470166 397872 815167 563182 715940 716149 806737 725507 733230 741577 802599 754877 626097 411399 516652 815444 688958 766837 726560 501663 580424 428890 796833 748354 695707 488160 213573 472922 560381 674620 627063 810970 812573 757350 619474 402874 406347 470764 423332 815566 475977 492522 525503 546970 719407 610669 744355 715145 470956 477975 428424 443639 501528 491902 136203 482335 804706 799298 789757 725378 767548 732808 825909 695738 599202 776227 750198 439307 532927 695773 650418 712089 716188 618712 772072 800012 748489 760889 788773 809926 411323 604907 425472 388796 519488 562859 689738 437344 563483 794104 548833 561024 495877 817454 500949 563004 809592 760056 756225 789491 803158 398938 411385 397862 405494 698440 699233 570851 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.48%) |
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 136203 212914 213573 388796 397862 397872 398938 402874 405494 406347 411323 411385 411399 423332 425472 428424 428890 429659 431664 437344 439307 439671 443639 451541 466044 470166 470764 470956 470962 472922 475977 477975 482335 488160 491902 492522 495877 496854 500949 501528 501663 516652 519488 525503 532927 546970 548833 560381 561024 562859 563004 563182 563483 570851 580424 599202 604907 610669 615740 618712 619474 626097 627063 650418 674620 688958 689738 695707 695738 695773 698440 699233 707429 712089 715145 715940 716149 716188 719407 725378 725507 726560 732808 733230 741577 744355 748354 748489 750198 754877 756225 757350 760056 760889 766837 767548 772072 776227 788773 789491 789757 794104 796833 799298 800012 802599 803158 804706 804710 806737 809592 809926 810970 812573 815167 815444 815566 817454 817822 825909 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose ass licking"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose жоп лиза"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose жоп лиза"
]
|
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.