Query Metrics
7
Database Queries
7
Different statements
159.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.48 ms (80.99%) |
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 358437 390582 391156 391392 398802 398931 401807 403314 406587 406593 407809 411365 411708 411897 414358 419518 424480 424658 442975 443148 451488 451937 456697 457991 460760 462607 465949 465957 466026 466195 466229 466238 466835 469489 470148 470169 471073 474686 479090 480290 484685 488370 490406 491637 496862 497492 506908 518576 522343 522594 522605 523562 523662 526008 528749 533563 544478 546687 546953 560430 560958 565261 577355 581035 593842 596653 604327 619531 633115 640526 660120 672794 673791 699625 718560 720795 721983 724232 724268 727653 728445 730352 731832 731844 737152 738830 744994 750294 762805 765648 766663 766690 773577 781648 782428 789532 789950 793875 795867 798775 800624 801319 803941 804006 804013 805735 807327 807926 811488 811710 814952 815518 816052 816784 816785 818727 820683 824364 825114 826241 ] |
||||||||||||||||||||||||||||||
|
20.39 ms (12.75%) |
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 488370 720795 724268 466195 470169 419518 424658 480290 466229 795867 496862 522343 522605 465957 807926 391392 546687 728445 619531 479090 470148 490406 484685 781648 456697 807327 457991 390582 451488 465949 460760 442975 522594 789532 773577 766690 803941 398802 814952 718560 596653 604327 640526 727653 789950 782428 391156 816052 818727 824364 466835 750294 826241 805735 811488 811710 762805 406587 672794 560430 730352 533563 544478 401807 407809 451937 466238 660120 738830 546953 633115 804013 766663 731844 815518 800624 731832 793875 358437 816784 816785 801319 804006 737152 724232 411897 466026 414358 497492 523662 528749 565261 577355 443148 471073 518576 526008 491637 798775 820683 523562 581035 673791 699625 765648 398931 406593 411708 825114 462607 721983 593842 744994 403314 411365 560958 424480 469489 474686 506908 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.47%) |
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 358437 390582 391156 391392 398802 398931 401807 403314 406587 406593 407809 411365 411708 411897 414358 419518 424480 424658 442975 443148 451488 451937 456697 457991 460760 462607 465949 465957 466026 466195 466229 466238 466835 469489 470148 470169 471073 474686 479090 480290 484685 488370 490406 491637 496862 497492 506908 518576 522343 522594 522605 523562 523662 526008 528749 533563 544478 546687 546953 560430 560958 565261 577355 581035 593842 596653 604327 619531 633115 640526 660120 672794 673791 699625 718560 720795 721983 724232 724268 727653 728445 730352 731832 731844 737152 738830 744994 750294 762805 765648 766663 766690 773577 781648 782428 789532 789950 793875 795867 798775 800624 801319 803941 804006 804013 805735 807327 807926 811488 811710 814952 815518 816052 816784 816785 818727 820683 824364 825114 826241 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature lick anal"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature лиза анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature лиза анал"
]
|
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.