Query Metrics
7
Database Queries
7
Different statements
539.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
310.15 ms (57.44%) |
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 95808 328446 381882 387230 401978 410958 415346 415572 416273 450772 451491 452517 453270 453448 462110 463305 464559 465387 468097 470468 474105 474122 474465 476679 478378 483054 484621 485286 486571 486890 493136 502929 505663 513834 514903 516483 516562 518571 520899 522508 522885 526526 526886 527624 530143 532471 535314 536419 537196 538011 539546 545694 549231 554887 555110 556519 557514 559059 561423 561453 562989 563069 564818 567407 567412 569976 580611 591048 602947 610044 611520 614518 622794 663772 663898 665096 665357 666093 666741 667671 668529 696985 714911 725198 726491 726691 727022 733375 734324 736099 743829 746685 748504 750773 758122 758509 759849 761027 766582 770129 772114 777420 781689 781901 782194 782235 782259 788275 788959 789693 796957 803091 806311 807384 813085 815530 816629 819238 824149 826015 ] |
||||||||||||||||||||||||||||||
|
210.49 ms (38.98%) |
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 95808 328446 381882 387230 401978 410958 415346 415572 416273 450772 451491 452517 453270 453448 462110 463305 464559 465387 468097 470468 474105 474122 474465 476679 478378 483054 484621 485286 486571 486890 493136 502929 505663 513834 514903 516483 516562 518571 520899 522508 522885 526526 526886 527624 530143 532471 535314 536419 537196 538011 539546 545694 549231 554887 555110 556519 557514 559059 561423 561453 562989 563069 564818 567407 567412 569976 580611 591048 602947 610044 611520 614518 622794 663772 663898 665096 665357 666093 666741 667671 668529 696985 714911 725198 726491 726691 727022 733375 734324 736099 743829 746685 748504 750773 758122 758509 759849 761027 766582 770129 772114 777420 781689 781901 782194 782235 782259 788275 788959 789693 796957 803091 806311 807384 813085 815530 816629 819238 824149 826015 ] |
||||||||||||||||||||||||||||||
|
13.04 ms (2.41%) |
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 451491 468097 478378 516562 520899 502929 516483 522508 526526 538011 484621 486571 450772 486890 537196 554887 561423 415572 463305 527624 526886 328446 95808 387230 401978 416273 415346 816629 819238 824149 815530 826015 452517 470468 453270 464559 465387 474105 474465 493136 474122 476679 483054 485286 530143 532471 513834 505663 522885 539546 514903 518571 535314 536419 462110 545694 549231 562989 556519 559059 580611 557514 563069 564818 567407 663898 665096 666741 663772 665357 666093 714911 667671 668529 696985 555110 561453 567412 569976 611520 591048 622794 602947 614518 781689 782235 788275 807384 813085 777420 782194 788959 789693 796957 803091 725198 758509 772114 734324 746685 748504 759849 766582 743829 726691 750773 770129 726491 727022 733375 736099 758122 761027 610044 781901 782259 806311 381882 410958 453448 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature housewife"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature housewife"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature housewife"
]
|
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.