Query Metrics
7
Database Queries
7
Different statements
196.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.46 ms (87.08%) |
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 417841 419765 420534 422074 423499 426101 427592 430355 432647 432690 432692 432732 432778 432803 435177 435472 441430 441519 445340 447007 452636 454926 456551 460663 461778 462071 462757 463810 464155 464811 464837 465267 468956 470425 471300 471330 471554 472692 476975 480714 484423 486204 487382 488948 489271 491802 492495 493172 495364 495607 496616 500884 500938 505803 510456 511348 513508 513552 514024 516136 518451 519436 521205 522216 525391 526466 527874 529616 534494 538266 541732 542127 542161 545814 546752 547865 548907 549697 550337 554552 556445 556973 558490 560844 562883 563031 563082 566128 576516 578438 580418 586897 589278 592956 593787 595549 604631 608725 608751 622932 625572 628614 630751 632096 638024 680422 720132 735195 743068 750668 754160 761048 761496 761583 765493 766996 785319 787556 794135 801259 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (7.64%) |
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 754160 761048 743068 765493 766996 761496 750668 632096 720132 787556 432803 441430 435177 452636 461778 432778 500938 538266 489271 495364 513508 500884 522216 487382 505803 527874 445340 471554 417841 441519 432732 422074 420534 432690 447007 463810 465267 486204 454926 460663 511348 526466 496616 529616 464837 480714 488948 492495 542161 549697 547865 548907 562883 563082 680422 554552 556445 576516 592956 593787 628614 595549 589278 794135 801259 735195 608725 462757 472692 471300 464811 464155 470425 513552 514024 493172 495607 510456 426101 560844 471330 546752 419765 556973 427592 491802 622932 423499 432692 435472 432647 462071 476975 468956 534494 518451 519436 541732 542127 545814 550337 558490 563031 566128 578438 580418 608751 625572 630751 638024 586897 785319 761583 604631 430355 456551 516136 521205 525391 484423 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.39%) |
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 417841 419765 420534 422074 423499 426101 427592 430355 432647 432690 432692 432732 432778 432803 435177 435472 441430 441519 445340 447007 452636 454926 456551 460663 461778 462071 462757 463810 464155 464811 464837 465267 468956 470425 471300 471330 471554 472692 476975 480714 484423 486204 487382 488948 489271 491802 492495 493172 495364 495607 496616 500884 500938 505803 510456 511348 513508 513552 514024 516136 518451 519436 521205 522216 525391 526466 527874 529616 534494 538266 541732 542127 542161 545814 546752 547865 548907 549697 550337 554552 556445 556973 558490 560844 562883 563031 563082 566128 576516 578438 580418 586897 589278 592956 593787 595549 604631 608725 608751 622932 625572 628614 630751 632096 638024 680422 720132 735195 743068 750668 754160 761048 761496 761583 765493 766996 785319 787556 794135 801259 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife is crying"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.82%) |
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.