Query Metrics
7
Database Queries
7
Different statements
178.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.75 ms (85.70%) |
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 400475 419628 420352 439382 440833 445723 453978 455719 456080 457853 471128 471393 474761 482226 496562 500913 503693 507976 509986 510220 510339 511784 512399 513572 514379 514404 517965 519605 520832 522669 523832 524773 525254 525682 526819 527350 528960 532531 536903 537455 537944 541803 542724 543191 544680 547353 548574 554733 555898 556661 557128 557233 557551 558350 559933 559939 561389 561833 563041 563049 563883 564701 565346 565751 566312 569060 569168 569613 570736 571813 574136 574243 575632 576002 577328 577351 578497 580296 580665 582234 583681 584421 584492 585967 586566 587143 587164 590076 594975 595127 598078 598606 601686 601806 602002 602183 603783 605058 608084 608804 612008 616481 617175 619451 620265 621271 621374 622356 632578 650486 654468 663212 666603 668480 673364 675012 681382 684902 685613 687941 ] |
||||||||||||||||||||||||||||||
|
15.70 ms (8.81%) |
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 510339 555898 666603 587143 621374 602183 525254 536903 574136 527350 522669 520832 578497 594975 601806 445723 453978 557233 684902 685613 509986 650486 566312 619451 471128 524773 525682 577328 616481 598606 587164 583681 532531 561389 605058 439382 541803 558350 668480 571813 608804 547353 602002 556661 574243 632578 673364 482226 511784 543191 526819 471393 457853 512399 561833 557551 598078 585967 563049 577351 563041 687941 622356 474761 523832 595127 681382 554733 575632 601686 603783 620265 557128 400475 456080 510220 528960 569168 586566 559933 559939 590076 563883 542724 419628 569613 440833 519605 576002 565751 564701 654468 621271 514379 569060 584421 514404 608084 582234 507976 565346 537944 420352 537455 503693 517965 455719 513572 500913 548574 570736 584492 612008 663212 617175 580296 675012 496562 544680 580665 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.38%) |
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 400475 419628 420352 439382 440833 445723 453978 455719 456080 457853 471128 471393 474761 482226 496562 500913 503693 507976 509986 510220 510339 511784 512399 513572 514379 514404 517965 519605 520832 522669 523832 524773 525254 525682 526819 527350 528960 532531 536903 537455 537944 541803 542724 543191 544680 547353 548574 554733 555898 556661 557128 557233 557551 558350 559933 559939 561389 561833 563041 563049 563883 564701 565346 565751 566312 569060 569168 569613 570736 571813 574136 574243 575632 576002 577328 577351 578497 580296 580665 582234 583681 584421 584492 585967 586566 587143 587164 590076 594975 595127 598078 598606 601686 601806 602002 602183 603783 605058 608084 608804 612008 616481 617175 619451 620265 621271 621374 622356 632578 650486 654468 663212 666603 668480 673364 675012 681382 684902 685613 687941 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties in ass"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел жоп"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.89%) |
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.