Query Metrics
7
Database Queries
7
Different statements
162.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.11 ms (81.83%) |
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 382777 389479 389728 393761 393781 395622 396171 396224 398032 400443 403190 407404 410573 417692 418400 418910 419198 419428 419590 420543 425946 430333 442747 444465 444834 445672 446089 447560 448697 451243 452442 456802 460723 463873 464282 467135 470732 470796 470849 471527 472248 472467 473807 473954 475100 476951 477441 481785 482805 483244 483500 484786 485784 487902 487910 488003 489661 490202 490763 491644 491702 498822 499850 505004 508198 508527 511733 515128 515135 515136 515171 515202 520003 523265 523815 523822 524589 526024 527664 528459 529183 531433 545804 550130 550360 550436 552617 556320 558050 560113 564772 564808 567003 567153 569677 571383 571623 575737 580996 604069 607387 621705 627804 678573 679387 709359 751331 759639 788604 790242 814562 814757 815394 816541 819611 820924 821581 821839 826764 827120 ] |
||||||||||||||||||||||||||||||
|
19.08 ms (11.73%) |
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 580996 556320 679387 788604 759639 490763 523822 445672 515128 389728 467135 678573 790242 751331 607387 527664 550436 487910 621705 451243 471527 485784 508527 531433 550130 564808 567003 571383 545804 552617 564772 560113 604069 410573 419198 444465 447560 463873 475100 477441 481785 389479 395622 419428 472467 464282 470849 472248 499850 508198 483244 484786 489661 491702 529183 487902 490202 515135 520003 523265 523815 526024 528459 491644 498822 505004 511733 524589 550360 571623 709359 398032 473954 419590 444834 488003 567153 569677 575737 558050 627804 473807 483500 515136 515171 515202 382777 393761 393781 396171 396224 400443 403190 430333 407404 417692 420543 442747 418400 418910 425946 814757 815394 821839 814562 819611 820924 821581 826764 827120 816541 482805 470732 448697 456802 460723 470796 476951 446089 452442 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.70%) |
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 382777 389479 389728 393761 393781 395622 396171 396224 398032 400443 403190 407404 410573 417692 418400 418910 419198 419428 419590 420543 425946 430333 442747 444465 444834 445672 446089 447560 448697 451243 452442 456802 460723 463873 464282 467135 470732 470796 470849 471527 472248 472467 473807 473954 475100 476951 477441 481785 482805 483244 483500 484786 485784 487902 487910 488003 489661 490202 490763 491644 491702 498822 499850 505004 508198 508527 511733 515128 515135 515136 515171 515202 520003 523265 523815 523822 524589 526024 527664 528459 529183 531433 545804 550130 550360 550436 552617 556320 558050 560113 564772 564808 567003 567153 569677 571383 571623 575737 580996 604069 607387 621705 627804 678573 679387 709359 751331 759639 788604 790242 814562 814757 815394 816541 819611 820924 821581 821839 826764 827120 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful young pussy"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая young pussy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая young pussy"
]
|
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.