Query Metrics
7
Database Queries
7
Different statements
143.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.10 ms (84.65%) |
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 326164 388374 391208 406282 410808 411627 415814 443271 444593 444668 444808 458245 460082 471516 479792 483112 485172 485526 491151 492940 493431 495361 499205 500221 500349 501682 503046 503754 503768 506807 510565 513006 513404 517528 518290 521236 522753 524037 524581 524965 524976 525012 526368 528400 528733 529144 532820 535255 535794 535920 536865 540805 542662 544229 545852 547999 552609 555936 558361 559546 559818 560856 561534 561937 562055 567587 568718 571703 577451 578026 578365 578611 579103 587357 588946 589710 590537 590917 593068 594030 595115 598914 599135 601828 603882 603967 604857 611468 612608 615185 616012 616486 616824 616877 617214 617616 620309 624599 624601 625005 625582 625860 629520 630850 631316 632749 640905 641874 655457 681782 715842 717222 718438 719310 723238 731517 758385 758483 777806 809979 ] |
||||||||||||||||||||||||||||||
|
13.01 ms (9.09%) |
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 616486 655457 719310 723238 629520 503754 578611 588946 593068 641874 528733 444593 524976 510565 522753 524965 577451 443271 388374 491151 513404 411627 517528 535920 500349 545852 562055 616012 590917 598914 632749 615185 406282 503046 503768 524037 471516 458245 485526 485172 499205 483112 544229 561534 579103 616877 624599 590537 603882 640905 560856 568718 552609 681782 567587 594030 611468 616824 599135 731517 444808 625005 631316 777806 809979 717222 617214 528400 391208 460082 492940 493431 518290 525012 495361 526368 326164 479792 524581 521236 535794 532820 547999 578026 604857 630850 595115 758385 624601 444668 415814 500221 535255 620309 555936 558361 578365 603967 718438 612608 617616 758483 601828 506807 513006 529144 501682 536865 715842 542662 540805 561937 559546 559818 571703 589710 625582 625860 587357 410808 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.77%) |
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 326164 388374 391208 406282 410808 411627 415814 443271 444593 444668 444808 458245 460082 471516 479792 483112 485172 485526 491151 492940 493431 495361 499205 500221 500349 501682 503046 503754 503768 506807 510565 513006 513404 517528 518290 521236 522753 524037 524581 524965 524976 525012 526368 528400 528733 529144 532820 535255 535794 535920 536865 540805 542662 544229 545852 547999 552609 555936 558361 559546 559818 560856 561534 561937 562055 567587 568718 571703 577451 578026 578365 578611 579103 587357 588946 589710 590537 590917 593068 594030 595115 598914 599135 601828 603882 603967 604857 611468 612608 615185 616012 616486 616824 616877 617214 617616 620309 624599 624601 625005 625582 625860 629520 630850 631316 632749 640905 641874 655457 681782 715842 717222 718438 719310 723238 731517 758385 758483 777806 809979 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большой член рот"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член рот"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.09%) |
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.