Query Metrics
7
Database Queries
7
Different statements
182.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.05 ms (82.90%) |
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 366354 381917 384030 392028 398655 400497 400498 413161 415636 418747 421836 421851 421868 421918 426515 434251 437965 439770 439780 439791 440894 446293 447296 452620 453230 455357 455406 455428 455523 456926 457444 457542 457572 458942 459946 460348 464679 466005 467801 468896 473866 477453 477614 483983 489249 492199 494809 499295 501028 501506 503993 510761 512577 514610 517059 519838 520889 521410 524486 524499 526026 527060 528128 528777 529907 533874 533880 533920 535433 535446 544834 552071 556966 558461 558883 561345 563570 566107 566128 578678 580866 584192 586398 589634 590987 591033 591453 592386 592840 600829 609227 617277 625089 639788 642162 642290 642331 668139 697002 705327 705346 711685 726538 726546 736137 768844 770947 787719 790874 790882 791730 796105 796566 797756 798059 803428 804677 809502 810297 818142 ] |
||||||||||||||||||||||||||||||
|
21.74 ms (11.93%) |
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 483983 503993 521410 566107 711685 552071 556966 600829 642290 768844 770947 705327 797756 455357 466005 456926 421851 494809 492199 426515 459946 810297 467801 421918 524486 413161 578678 400498 787719 589634 591033 563570 418747 439780 558883 561345 668139 398655 586398 439770 439791 818142 384030 381917 415636 440894 434251 477614 452620 455523 457572 460348 533920 499295 524499 526026 527060 528128 580866 705346 584192 590987 617277 642162 609227 591453 592386 625089 639788 642331 592840 790882 790874 791730 796105 804677 809502 796566 726538 736137 726546 697002 803428 392028 457542 421836 468896 437965 458942 447296 455406 455428 477453 520889 529907 514610 519838 489249 512577 533874 528777 535433 535446 558461 501506 533880 798059 366354 453230 446293 464679 501028 510761 566128 473866 400497 544834 457444 421868 517059 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.29%) |
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 366354 381917 384030 392028 398655 400497 400498 413161 415636 418747 421836 421851 421868 421918 426515 434251 437965 439770 439780 439791 440894 446293 447296 452620 453230 455357 455406 455428 455523 456926 457444 457542 457572 458942 459946 460348 464679 466005 467801 468896 473866 477453 477614 483983 489249 492199 494809 499295 501028 501506 503993 510761 512577 514610 517059 519838 520889 521410 524486 524499 526026 527060 528128 528777 529907 533874 533880 533920 535433 535446 544834 552071 556966 558461 558883 561345 563570 566107 566128 578678 580866 584192 586398 589634 590987 591033 591453 592386 592840 600829 609227 617277 625089 639788 642162 642290 642331 668139 697002 705327 705346 711685 726538 726546 736137 768844 770947 787719 790874 790882 791730 796105 796566 797756 798059 803428 804677 809502 810297 818142 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass kitchen"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп кухн"
]
|
||||||||||||||||||||||||||||||
|
1.50 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.