Query Metrics
7
Database Queries
7
Different statements
209.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.61 ms (88.12%) |
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 265677 383685 421420 423837 426297 428793 440644 445401 446815 452223 454382 463804 464543 466452 475280 478983 482441 492651 493342 505385 508257 509113 513174 518977 519309 523156 523596 525204 528536 529713 529880 532118 532273 532545 533140 533642 542885 552382 553545 555189 555321 557471 559358 562048 566622 566625 568136 568293 569382 574086 575026 576229 576759 577284 579594 579707 579826 580129 585284 589408 590410 592184 594131 596033 602591 603414 605184 617065 619791 626066 627311 628527 628655 629387 632750 645928 649489 662444 674206 695603 697284 705129 710379 710559 742092 749359 751795 753582 759133 759992 765854 768385 770963 778498 781309 784662 787334 787599 789109 789773 790810 793940 796695 797180 797182 800381 801016 803233 804417 804420 804422 804458 804713 806930 809517 809548 810076 810798 813802 823887 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (6.53%) |
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 617065 705129 710379 800381 529880 523596 475280 579707 553545 519309 823887 813802 528536 532118 533140 559358 566622 577284 579826 555321 557471 579594 555189 575026 645928 649489 697284 568136 568293 569382 576759 585284 596033 628655 632750 602591 778498 797182 803233 789109 809548 753582 759992 787334 790810 804713 810076 751795 770963 749359 768385 603414 793940 804417 804420 809517 463804 464543 383685 513174 493342 452223 590410 440644 445401 518977 508257 566625 574086 626066 592184 784662 525204 426297 428793 423837 454382 478983 466452 492651 446815 532545 505385 529713 532273 523156 533642 482441 552382 562048 542885 695603 674206 576229 580129 594131 589408 619791 605184 628527 629387 789773 797180 810798 796695 801016 806930 759133 781309 787599 765854 742092 627311 710559 804422 804458 421420 265677 509113 662444 ] |
||||||||||||||||||||||||||||||
|
3.10 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 265677 383685 421420 423837 426297 428793 440644 445401 446815 452223 454382 463804 464543 466452 475280 478983 482441 492651 493342 505385 508257 509113 513174 518977 519309 523156 523596 525204 528536 529713 529880 532118 532273 532545 533140 533642 542885 552382 553545 555189 555321 557471 559358 562048 566622 566625 568136 568293 569382 574086 575026 576229 576759 577284 579594 579707 579826 580129 585284 589408 590410 592184 594131 596033 602591 603414 605184 617065 619791 626066 627311 628527 628655 629387 632750 645928 649489 662444 674206 695603 697284 705129 710379 710559 742092 749359 751795 753582 759133 759992 765854 768385 770963 778498 781309 784662 787334 787599 789109 789773 790810 793940 796695 797180 797182 800381 801016 803233 804417 804420 804422 804458 804713 806930 809517 809548 810076 810798 813802 823887 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло milf ван"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло milf ван"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo milf bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.