Query Metrics
7
Database Queries
7
Different statements
185.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.67 ms (88.39%) |
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 44120 78709 97156 100449 192814 305892 388193 391904 397895 398552 403414 413643 417844 470637 476838 477633 478541 479067 479087 492689 501178 508720 509228 528665 530289 530930 533527 533646 535402 536219 537104 538883 539018 543360 544669 545090 547939 547961 547988 554876 561628 562591 563387 566412 566418 568187 583446 587629 588272 591165 591167 592708 603578 603646 603690 610816 619275 622090 622125 626814 631329 632423 635636 635788 638542 640727 645046 645050 646240 648996 650642 651423 653435 653603 653807 653880 654291 654695 663328 686024 690049 692452 692463 696167 702877 712634 714128 715534 718421 724802 725096 730753 731032 731113 731195 732652 732690 733024 733150 733179 742684 743644 745896 745906 745917 748711 759443 767868 768186 768194 775896 782783 784326 784331 803348 817546 818932 819767 823928 824228 ] |
||||||||||||||||||||||||||||||
|
11.81 ms (6.38%) |
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 640727 731113 547961 784326 530289 592708 725096 767868 732652 530930 645050 690049 686024 388193 823928 731195 645046 635636 305892 398552 591167 44120 775896 528665 536219 587629 543360 509228 768186 547939 568187 588272 391904 745917 759443 545090 622090 547988 622125 603578 583446 718421 745896 745906 397895 97156 566412 663328 626814 733024 748711 768194 470637 819767 535402 533527 566418 654695 730753 632423 501178 508720 743644 653435 631329 742684 479087 492689 635788 733150 692452 712634 563387 714128 650642 692463 603690 784331 702877 715534 78709 619275 478541 100449 818932 539018 646240 653603 733179 476838 654291 610816 591165 817546 824228 537104 538883 533646 479067 554876 562591 648996 651423 653807 653880 696167 544669 561628 638542 603646 782783 803348 724802 731032 403414 192814 477633 413643 417844 732690 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.56%) |
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 44120 78709 97156 100449 192814 305892 388193 391904 397895 398552 403414 413643 417844 470637 476838 477633 478541 479067 479087 492689 501178 508720 509228 528665 530289 530930 533527 533646 535402 536219 537104 538883 539018 543360 544669 545090 547939 547961 547988 554876 561628 562591 563387 566412 566418 568187 583446 587629 588272 591165 591167 592708 603578 603646 603690 610816 619275 622090 622125 626814 631329 632423 635636 635788 638542 640727 645046 645050 646240 648996 650642 651423 653435 653603 653807 653880 654291 654695 663328 686024 690049 692452 692463 696167 702877 712634 714128 715534 718421 724802 725096 730753 731032 731113 731195 732652 732690 733024 733150 733179 742684 743644 745896 745906 745917 748711 759443 767868 768186 768194 775896 782783 784326 784331 803348 817546 818932 819767 823928 824228 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ммж женой"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро жен"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.73%) |
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.