Query Metrics
7
Database Queries
7
Different statements
168.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.72 ms (84.85%) |
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 7373 17058 386623 391871 410857 417067 418265 433589 450204 456445 457401 466787 470391 472297 473321 474044 474831 474955 483377 485488 494666 504416 510059 510508 512949 513301 516631 517466 519092 524169 526122 531606 533679 534074 534132 534825 536959 543405 544064 544739 544749 545094 545431 545766 547929 550852 557987 558790 566449 568666 573394 577106 584018 585269 592817 594577 600377 600955 603649 604463 605626 605648 610811 614698 618236 622158 622835 631993 632851 635854 641921 649614 651408 651650 653343 653758 654290 654624 654634 654688 656674 662896 663546 665226 667757 676871 679561 681740 703496 712470 718388 720293 720877 729216 729258 732666 743644 745391 745548 747560 748985 760247 761145 770672 774293 782916 784279 788108 790615 795584 796632 800475 802488 807889 807949 809644 810106 816803 824420 826232 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (9.07%) |
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 544739 545766 605648 610811 782916 747560 732666 654290 418265 651408 795584 524169 456445 17058 810106 592817 450204 494666 544064 663546 667757 474955 474831 558790 557987 545094 622158 635854 614698 745391 391871 417067 824420 826232 457401 517466 531606 545431 720877 584018 585269 790615 729258 632851 605626 654624 665226 544749 7373 472297 654634 654688 676871 796632 809644 483377 679561 802488 745548 516631 526122 577106 550852 656674 788108 474044 433589 534825 510059 504416 513301 547929 649614 720293 622835 603649 519092 761145 533679 534132 534074 536959 466787 543405 653343 653758 618236 600955 748985 760247 729216 807889 807949 510508 573394 410857 662896 816803 568666 681740 600377 604463 631993 784279 770672 473321 470391 743644 712470 594577 774293 386623 512949 485488 566449 718388 651650 703496 641921 800475 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.87%) |
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 7373 17058 386623 391871 410857 417067 418265 433589 450204 456445 457401 466787 470391 472297 473321 474044 474831 474955 483377 485488 494666 504416 510059 510508 512949 513301 516631 517466 519092 524169 526122 531606 533679 534074 534132 534825 536959 543405 544064 544739 544749 545094 545431 545766 547929 550852 557987 558790 566449 568666 573394 577106 584018 585269 592817 594577 600377 600955 603649 604463 605626 605648 610811 614698 618236 622158 622835 631993 632851 635854 641921 649614 651408 651650 653343 653758 654290 654624 654634 654688 656674 662896 663546 665226 667757 676871 679561 681740 703496 712470 718388 720293 720877 729216 729258 732666 743644 745391 745548 747560 748985 760247 761145 770672 774293 782916 784279 788108 790615 795584 796632 800475 802488 807889 807949 809644 810106 816803 824420 826232 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife trio threesome"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен секс втро секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.