Query Metrics
7
Database Queries
7
Different statements
174.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.40 ms (83.41%) |
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 21279 188600 395246 397838 400307 435563 442050 446645 454292 469479 475676 475752 477535 480317 480476 485527 487537 497421 499306 499904 501170 502793 503255 505283 508895 510591 510946 512902 513967 514837 514921 515230 515959 520180 520985 524294 525446 525727 526077 528348 529828 532176 533922 539319 539673 540864 541889 542610 548855 548859 553720 554407 554410 554733 555396 557468 559047 560935 560943 563325 567427 570409 571358 577214 577916 578198 579432 585806 585999 586157 586981 588228 589615 591299 592533 592585 593003 593486 594144 595158 595209 603109 604426 604651 605579 605686 605734 605979 606901 610031 613919 614827 621275 623076 626885 633018 634519 647241 648056 649678 653538 655030 655648 656457 663722 663924 664306 671780 675453 679657 683054 685001 702365 721451 748031 751046 757121 760566 763879 778377 ] |
||||||||||||||||||||||||||||||
|
18.28 ms (10.48%) |
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 577916 579432 605734 606901 603109 525446 533922 554407 648056 605686 526077 548859 604651 510946 499904 520180 515230 487537 480476 502793 513967 528348 554410 653538 563325 605579 593486 614827 514921 671780 675453 435563 555396 560935 559047 586157 446645 501170 514837 560943 595158 593003 570409 778377 508895 578198 588228 604426 469479 454292 623076 683054 497421 503255 524294 475676 571358 554733 610031 485527 685001 586981 594144 595209 477535 512902 529828 663722 679657 515959 585999 592585 542610 567427 626885 475752 557468 480317 591299 634519 510591 188600 748031 553720 541889 633018 656457 539319 21279 532176 655030 647241 548855 655648 751046 760566 395246 664306 592533 605979 525727 621275 397838 763879 442050 400307 589615 505283 577214 585806 757121 539673 520985 540864 499306 702365 649678 663924 721451 613919 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.73%) |
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 21279 188600 395246 397838 400307 435563 442050 446645 454292 469479 475676 475752 477535 480317 480476 485527 487537 497421 499306 499904 501170 502793 503255 505283 508895 510591 510946 512902 513967 514837 514921 515230 515959 520180 520985 524294 525446 525727 526077 528348 529828 532176 533922 539319 539673 540864 541889 542610 548855 548859 553720 554407 554410 554733 555396 557468 559047 560935 560943 563325 567427 570409 571358 577214 577916 578198 579432 585806 585999 586157 586981 588228 589615 591299 592533 592585 593003 593486 594144 595158 595209 603109 604426 604651 605579 605686 605734 605979 606901 610031 613919 614827 621275 623076 626885 633018 634519 647241 648056 649678 653538 655030 655648 656457 663722 663924 664306 671780 675453 679657 683054 685001 702365 721451 748031 751046 757121 760566 763879 778377 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жопы раздвигают"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп раздвига"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
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.