Query Metrics
7
Database Queries
7
Different statements
421.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
390.51 ms (92.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 391643 426794 427701 438452 438520 438528 440781 440848 441759 441876 442101 445104 449541 449696 450585 451555 451642 454474 454477 456807 458450 459586 461670 463324 466805 466983 479359 479370 479886 481391 483888 489285 493401 493455 495574 498898 499092 504214 504594 505429 507480 510405 512603 513132 514094 514852 518727 522719 527448 528468 529369 530106 541268 542436 545494 546721 549658 550516 552669 553260 555602 557729 557772 559396 561902 562541 564617 564679 567914 571059 571345 574446 579218 589512 589550 589654 590091 593776 604206 608635 610199 613956 618384 619514 619741 623216 624035 625895 644192 660351 662922 665323 666379 674255 675826 682267 690693 700299 700855 701522 705070 714357 724836 727023 748285 751260 751531 757910 765638 777634 777758 784005 787516 794766 796625 800488 808503 809913 826449 ] |
||||||||||||||||||||||||||||||
|
21.04 ms (5.00%) |
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 623216 590091 610199 619741 589654 777634 777758 800488 757910 787516 794766 748285 724836 751531 765638 727023 608635 619514 625895 784005 426794 441759 479370 391643 466805 461670 463324 449541 483888 493401 498898 528468 499092 493455 504214 505429 796625 451555 579218 589550 644192 808503 751260 809913 512603 495574 427701 438452 438528 441876 440781 442101 440848 445104 438520 826449 589512 449696 450585 451642 454474 454477 479886 456807 458450 459586 479359 489285 507480 510405 513132 514852 529369 504594 522719 527448 530106 514094 518727 466983 481391 542436 546721 549658 555602 564679 571345 567914 571059 541268 550516 557729 562541 564617 660351 675826 700299 701522 705070 662922 666379 690693 714357 665323 674255 682267 700855 545494 552669 553260 557772 559396 561902 574446 593776 604206 624035 598065 613956 618384 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (0.64%) |
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 391643 426794 427701 438452 438520 438528 440781 440848 441759 441876 442101 445104 449541 449696 450585 451555 451642 454474 454477 456807 458450 459586 461670 463324 466805 466983 479359 479370 479886 481391 483888 489285 493401 493455 495574 498898 499092 504214 504594 505429 507480 510405 512603 513132 514094 514852 518727 522719 527448 528468 529369 530106 541268 542436 545494 546721 549658 550516 552669 553260 555602 557729 557772 559396 561902 562541 564617 564679 567914 571059 571345 574446 579218 589512 589550 589654 590091 593776 604206 608635 610199 613956 618384 619514 619741 623216 624035 625895 644192 660351 662922 665323 666379 674255 675826 682267 690693 700299 700855 701522 705070 714357 724836 727023 748285 751260 751531 757910 765638 777634 777758 784005 787516 794766 796625 800488 808503 809913 826449 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"morning жен"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"morning wife"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"morning жен"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.