Query Metrics
7
Database Queries
7
Different statements
197.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.40 ms (83.76%) |
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 65568 118086 397889 405078 411616 416094 419487 439469 440490 440872 448703 455600 456007 458308 460921 461406 466350 466860 466918 466995 467481 467484 468858 469459 470388 470768 470998 471710 472403 472527 473154 473226 474848 475667 475669 475686 475979 476041 479134 482951 483372 484689 485737 485745 485964 487347 489105 489207 496339 496389 501997 504367 506764 511167 511506 512358 512713 515076 515732 520913 521067 525498 525510 527016 527253 529400 529401 529471 533800 546950 548392 552760 554500 555062 555144 567601 570662 573828 577938 578190 586578 614522 614628 623481 628649 629743 633062 638014 645889 652246 656022 663895 663965 665187 666453 667392 675512 678738 681498 686620 705079 710502 712214 719872 735995 737192 741726 742383 743610 749052 749899 778613 791113 801259 801821 803039 808527 821705 824087 826691 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (8.70%) |
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 552760 656022 666453 652246 710502 719872 675512 633062 735995 749052 712214 397889 405078 439469 440490 411616 440872 469459 472527 473154 475979 476041 487347 475669 482951 485737 485745 466918 471710 511506 506764 548392 554500 578190 678738 663965 665187 546950 570662 614628 778613 801259 741726 742383 749899 614522 623481 65568 419487 460921 468858 479134 455600 466350 467481 472403 118086 448703 461406 416094 484689 489105 501997 511167 525510 485964 496389 512713 520913 496339 504367 515732 529471 467484 529401 529400 473226 475667 808527 515076 567601 681498 628649 803039 475686 456007 458308 474848 525498 527253 466860 555144 663895 555062 586578 743610 470768 466995 470388 512358 527016 489207 521067 483372 826691 824087 821705 470998 533800 577938 573828 645889 667392 686620 705079 629743 638014 737192 791113 801821 ] |
||||||||||||||||||||||||||||||
|
7.29 ms (3.69%) |
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 65568 118086 397889 405078 411616 416094 419487 439469 440490 440872 448703 455600 456007 458308 460921 461406 466350 466860 466918 466995 467481 467484 468858 469459 470388 470768 470998 471710 472403 472527 473154 473226 474848 475667 475669 475686 475979 476041 479134 482951 483372 484689 485737 485745 485964 487347 489105 489207 496339 496389 501997 504367 506764 511167 511506 512358 512713 515076 515732 520913 521067 525498 525510 527016 527253 529400 529401 529471 533800 546950 548392 552760 554500 555062 555144 567601 570662 573828 577938 578190 586578 614522 614628 623481 628649 629743 633062 638014 645889 652246 656022 663895 663965 665187 666453 667392 675512 678738 681498 686620 705079 710502 712214 719872 735995 737192 741726 742383 743610 749052 749899 778613 791113 801259 801821 803039 808527 821705 824087 826691 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair vagina"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair вагин"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair вагин"
]
|
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.