Query Metrics
7
Database Queries
7
Different statements
158.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.88 ms (81.17%) |
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 386765 398440 402715 406621 409864 416185 417097 419411 420101 426250 438192 441961 442131 448219 448235 448616 450894 461122 461317 463132 468577 473546 476372 476430 480125 480476 480933 486306 486376 487496 491487 494143 494361 495027 500780 502722 504546 505038 506021 508076 508841 510093 511738 511762 512333 519621 520492 522997 523042 526122 527042 527495 527518 528906 528946 529107 531078 532793 536889 539540 542680 543254 543835 544050 545528 548778 554071 556307 557976 561105 561879 566032 566970 570933 574486 574880 574986 576027 585995 586595 586600 589087 589749 590683 590821 591194 594224 595337 598998 599418 600799 603893 605274 607204 607328 610714 614095 622704 627018 640777 644186 647815 651136 652358 653520 665113 671816 676154 682460 687271 690190 693955 693965 711006 730098 753960 776869 792910 815466 817917 ] |
||||||||||||||||||||||||||||||
|
18.53 ms (11.67%) |
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 495027 576027 730098 500780 511738 417097 815466 448219 526122 647815 607328 610714 600799 605274 711006 461317 510093 386765 426250 539540 543835 566970 574880 776869 753960 473546 502722 442131 527518 653520 687271 548778 599418 594224 476372 480933 468577 441961 448235 494361 506021 542680 544050 652358 590683 603893 420101 487496 505038 528946 416185 508841 398440 491487 448616 545528 556307 595337 508076 494143 532793 519621 671816 690190 554071 586600 589749 486306 504546 511762 409864 817917 463132 480476 523042 561105 585995 644186 598998 406621 461122 574486 589087 419411 574986 676154 640777 527042 651136 528906 527495 531078 476430 693965 614095 512333 486376 529107 557976 622704 590821 522997 561879 543254 570933 665113 682460 566032 607204 627018 792910 450894 536889 586595 591194 402715 438192 693955 480125 520492 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (2.54%) |
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 386765 398440 402715 406621 409864 416185 417097 419411 420101 426250 438192 441961 442131 448219 448235 448616 450894 461122 461317 463132 468577 473546 476372 476430 480125 480476 480933 486306 486376 487496 491487 494143 494361 495027 500780 502722 504546 505038 506021 508076 508841 510093 511738 511762 512333 519621 520492 522997 523042 526122 527042 527495 527518 528906 528946 529107 531078 532793 536889 539540 542680 543254 543835 544050 545528 548778 554071 556307 557976 561105 561879 566032 566970 570933 574486 574880 574986 576027 585995 586595 586600 589087 589749 590683 590821 591194 594224 595337 598998 599418 600799 603893 605274 607204 607328 610714 614095 622704 627018 640777 644186 647815 651136 652358 653520 665113 671816 676154 682460 687271 690190 693955 693965 711006 730098 753960 776869 792910 815466 817917 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shy girls"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shy девушк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shy девушк"
]
|
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.