Query Metrics
7
Database Queries
7
Different statements
184.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.73 ms (87.53%) |
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 383110 393274 394297 395332 395803 398902 400677 407120 407487 409984 417709 436828 439829 440667 456125 460395 460895 463115 464570 466531 467782 476862 488851 504660 506555 516692 518309 519401 522857 525481 525734 527481 541071 545798 546825 547992 550107 550123 550941 559655 562927 563336 563408 569538 571725 572951 580990 581028 588549 590606 592851 604099 606408 608926 614455 615466 626351 627141 630399 630879 632054 638971 639218 644850 644854 649024 650037 651865 662097 663893 666978 677626 689143 689296 691240 691603 692824 693270 695646 695682 701604 701623 701644 705433 711548 713145 724039 728188 729564 733511 734372 736498 739151 742126 744933 750686 752625 754635 755737 763932 764879 768765 769118 773620 774033 778925 779852 780828 785454 785515 787458 787558 789033 798918 798975 805229 816187 817981 820475 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (7.35%) |
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 691603 742126 604099 695682 693270 519401 729564 550107 733511 754635 736498 752625 666978 677626 639218 592851 689143 780828 527481 816187 525481 394297 541071 638971 630399 650037 692824 590606 768765 785454 630879 608926 407120 627141 651865 798975 606408 739151 705433 417709 546825 572951 632054 787458 817981 464570 562927 711548 734372 393274 701623 701644 644850 769118 525734 663893 547992 785515 787558 559655 774033 546559 713145 744933 763932 506555 383110 466531 563336 805229 779852 436828 400677 439829 467782 476862 649024 460895 662097 614455 701604 563408 778925 789033 764879 820475 755737 728188 644854 488851 545798 550123 407487 456125 550941 615466 398902 691240 689296 516692 518309 440667 580990 773620 695646 724039 581028 798918 588549 522857 569538 460395 504660 463115 626351 409984 750686 571725 395332 395803 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.28%) |
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 383110 393274 394297 395332 395803 398902 400677 407120 407487 409984 417709 436828 439829 440667 456125 460395 460895 463115 464570 466531 467782 476862 488851 504660 506555 516692 518309 519401 522857 525481 525734 527481 541071 545798 546825 547992 550107 550123 550941 559655 562927 563336 563408 569538 571725 572951 580990 581028 588549 590606 592851 604099 606408 608926 614455 615466 626351 627141 630399 630879 632054 638971 639218 644850 644854 649024 650037 651865 662097 663893 666978 677626 689143 689296 691240 691603 692824 693270 695646 695682 701604 701623 701644 705433 711548 713145 724039 728188 729564 733511 734372 736498 739151 742126 744933 750686 752625 754635 755737 763932 764879 768765 769118 773620 774033 778925 779852 780828 785454 785515 787458 787558 789033 798918 798975 805229 816187 817981 820475 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public standing sex"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на standing улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на standing улиц секс"
]
|
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.