Query Metrics
7
Database Queries
7
Different statements
151.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.03 ms (83.75%) |
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 381950 385875 388087 389110 389966 414666 417789 418966 419096 420742 421139 425719 425984 429954 438543 438880 442679 443432 444283 455975 460368 460847 463182 463973 467837 469393 483443 486970 487418 487525 488820 491860 492309 493411 501553 504053 505526 505548 508963 510063 511856 516574 517511 521682 522152 523164 523796 524191 527390 528071 531347 531424 531473 531491 531517 531905 531991 538949 540704 545844 547430 550817 552938 555402 557605 563278 565929 566262 566361 573196 575339 582430 582722 583114 584481 584950 589296 592388 594179 594556 595097 595158 595763 596445 599249 602753 604066 604984 605646 606732 607710 607717 615919 618299 618969 620038 623564 623815 624222 630659 635694 640260 641997 644657 650570 664241 682031 687511 690882 707432 728469 730994 731004 752653 761289 764420 766605 787336 815297 ] |
||||||||||||||||||||||||||||||
|
14.51 ms (9.57%) |
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 605646 606732 589296 604066 604621 624222 635694 592388 594556 596445 615919 607710 618299 623564 623815 640260 641997 761289 731004 766605 730994 752653 728469 764420 602753 604984 644657 707432 787336 385875 438543 381950 389110 460847 463182 419096 425719 467837 421139 540704 483443 504053 522152 528071 516574 521682 488820 510063 463973 389966 429954 493411 599249 630659 388087 414666 418966 442679 425984 443432 420742 438880 444283 417789 815297 487525 455975 491860 469393 486970 508963 523164 517511 523796 531491 531517 531905 531991 538949 505526 505548 527390 531347 531473 501553 511856 524191 531424 460368 487418 492309 550817 555402 583114 584481 584950 563278 565929 566262 573196 582430 582722 545844 547430 557605 650570 664241 690882 682031 687511 552938 566361 575339 595158 595763 607717 618969 620038 594179 595097 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.97%) |
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 381950 385875 388087 389110 389966 414666 417789 418966 419096 420742 421139 425719 425984 429954 438543 438880 442679 443432 444283 455975 460368 460847 463182 463973 467837 469393 483443 486970 487418 487525 488820 491860 492309 493411 501553 504053 505526 505548 508963 510063 511856 516574 517511 521682 522152 523164 523796 524191 527390 528071 531347 531424 531473 531491 531517 531905 531991 538949 540704 545844 547430 550817 552938 555402 557605 563278 565929 566262 566361 573196 575339 582430 582722 583114 584481 584950 589296 592388 594179 594556 595097 595158 595763 596445 599249 602753 604066 604984 605646 606732 607710 607717 615919 618299 618969 620038 623564 623815 624222 630659 635694 640260 641997 644657 650570 664241 682031 687511 690882 707432 728469 730994 731004 752653 761289 764420 766605 787336 815297 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy riding"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая riding"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая riding"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.08%) |
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.