Query Metrics
7
Database Queries
7
Different statements
158.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.35 ms (86.46%) |
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 383497 383685 415755 415863 428828 435593 443804 449020 449022 452427 454688 454943 463804 464996 467966 475293 478523 484777 493342 494250 498454 499390 499921 513842 513981 515546 519672 522174 522184 537091 537120 546783 547762 548392 556880 562784 569572 571707 574381 574763 575401 581438 586557 599796 602261 602295 602298 602591 603817 604104 604418 613032 614504 620047 620260 623382 629572 629575 634692 639306 640894 641779 641946 643323 643325 644126 707812 709171 711651 736018 736796 740330 741750 742386 744187 749084 749697 753135 757540 759490 760538 760697 770963 772714 778869 786850 786873 787343 787466 790648 794211 794249 796452 797048 798429 800473 800697 802196 802912 803605 803745 804802 806391 806690 806933 807215 807579 808342 808562 808725 808947 808990 810461 811679 812067 812373 812385 812388 812496 812503 ] |
||||||||||||||||||||||||||||||
|
12.54 ms (7.90%) |
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 629572 641779 643323 599796 602261 602295 603817 604418 613032 620047 620260 643325 644126 614504 586557 602591 623382 629575 640894 786850 787466 803745 807215 807579 808562 810461 812373 778869 786873 794249 798429 800697 802196 803605 804802 806933 808947 808990 812067 812385 812388 741750 753135 759490 772714 787343 790648 794211 797048 800473 806690 808342 811679 749697 757540 760538 736018 742386 749084 770963 740330 760697 736796 744187 602298 604104 634692 639306 641946 707812 709171 711651 796452 802912 806391 808725 812496 812503 443804 463804 383685 435593 383497 415755 478523 428828 493342 494250 499390 484777 519672 522174 562784 547762 548392 454943 452427 513981 522184 498454 513842 415863 467966 475293 454688 449020 449022 464996 537091 499921 515546 537120 546783 574763 571707 575401 569572 556880 574381 581438 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.62%) |
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 383497 383685 415755 415863 428828 435593 443804 449020 449022 452427 454688 454943 463804 464996 467966 475293 478523 484777 493342 494250 498454 499390 499921 513842 513981 515546 519672 522174 522184 537091 537120 546783 547762 548392 556880 562784 569572 571707 574381 574763 575401 581438 586557 599796 602261 602295 602298 602591 603817 604104 604418 613032 614504 620047 620260 623382 629572 629575 634692 639306 640894 641779 641946 643323 643325 644126 707812 709171 711651 736018 736796 740330 741750 742386 744187 749084 749697 753135 757540 759490 760538 760697 770963 772714 778869 786850 786873 787343 787466 790648 794211 794249 796452 797048 798429 800473 800697 802196 802912 803605 803745 804802 806391 806690 806933 807215 807579 808342 808562 808725 808947 808990 810461 811679 812067 812373 812385 812388 812496 812503 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf solo toys"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf соло toys"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf соло toys"
]
|
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.