Query Metrics
7
Database Queries
7
Different statements
199.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.26 ms (87.22%) |
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 33098 382491 394240 396218 399088 406022 410741 411838 412687 413809 418808 420804 424770 426468 426962 431231 434306 434336 436440 437558 437926 443229 443310 444338 446353 446473 446485 455248 459819 460366 466698 469848 476582 479539 480437 482758 482933 483517 484120 489355 489439 489606 490592 491365 495824 497417 497887 499004 501745 504321 504384 506556 508016 508141 511726 515279 519428 519687 520007 521454 521941 522743 523132 524691 525117 529041 534126 538354 544368 545811 549475 553920 555796 555853 556401 561359 561664 561905 562035 563823 564491 565551 566554 567957 575762 575792 576021 576033 576036 577837 581637 581959 584067 588359 595519 595592 598491 598774 600242 600623 601695 604147 613850 615662 620616 622230 625323 643681 663854 679808 680709 714082 718710 724556 730098 788800 788936 797512 800610 805675 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (7.23%) |
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 598774 613850 622230 595519 598491 600623 604147 615662 625323 595592 601695 588359 600242 620616 788936 797512 724556 730098 643681 718710 788800 800610 805675 412687 406022 443229 460366 466698 479539 394240 396218 410741 434306 436440 443310 444338 476582 418808 426468 426962 437926 459819 469848 413809 420804 431231 455248 508016 519428 522743 483517 489355 491365 497887 504321 508141 511726 515279 520007 521941 524691 484120 489439 489606 501745 523132 525117 482933 490592 497417 382491 33098 399088 434336 437558 424770 411838 482758 446353 446485 480437 446473 506556 534126 538354 495824 521454 499004 504384 529041 519687 555853 562035 566554 575762 576021 581959 549475 553920 555796 561359 565551 576033 581637 584067 544368 567957 575792 576036 577837 680709 663854 679808 714082 545811 556401 561664 561905 563823 564491 ] |
||||||||||||||||||||||||||||||
|
3.99 ms (2.00%) |
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 33098 382491 394240 396218 399088 406022 410741 411838 412687 413809 418808 420804 424770 426468 426962 431231 434306 434336 436440 437558 437926 443229 443310 444338 446353 446473 446485 455248 459819 460366 466698 469848 476582 479539 480437 482758 482933 483517 484120 489355 489439 489606 490592 491365 495824 497417 497887 499004 501745 504321 504384 506556 508016 508141 511726 515279 519428 519687 520007 521454 521941 522743 523132 524691 525117 529041 534126 538354 544368 545811 549475 553920 555796 555853 556401 561359 561664 561905 562035 563823 564491 565551 566554 567957 575762 575792 576021 576033 576036 577837 581637 581959 584067 588359 595519 595592 598491 598774 600242 600623 601695 604147 613850 615662 620616 622230 625323 643681 663854 679808 680709 714082 718710 724556 730098 788800 788936 797512 800610 805675 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cute skinny"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cute худые"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cute худые"
]
|
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.