Query Metrics
7
Database Queries
7
Different statements
191.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.12 ms (87.41%) |
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 154374 183506 391916 391917 392004 394648 399028 401204 408692 413673 414103 414125 419824 439653 441067 443773 446386 448115 448354 455793 462840 467712 469096 469219 470453 473426 476163 480470 480502 484608 485546 500339 500341 510815 511254 513846 529713 529714 530679 531844 531884 532655 534372 534536 534560 537864 538879 540945 541276 541277 541317 541392 541851 541863 542142 543871 544843 544848 545395 545434 547475 547477 547890 550899 564288 564293 569150 571194 583713 590370 591805 599847 599880 599927 611164 624197 639739 641953 641996 642029 656626 656925 660369 660417 664166 668690 670366 671038 672315 695866 695871 695887 713508 717516 724309 745111 749064 749255 749264 750668 752612 752613 752641 752642 752651 752666 752669 752697 753614 757350 759370 780684 782789 795420 796905 799362 803687 809371 819238 827489 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (7.61%) |
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 547475 541276 542142 550899 660417 660369 672315 668690 671038 695871 695887 717516 545434 624197 591805 642029 782789 795420 752641 752697 752666 750668 752651 759370 799362 183506 391916 511254 469219 547890 401204 476163 392004 500339 541863 532655 531884 530679 564288 819238 571194 441067 500341 443773 656626 534372 537864 544843 419824 448354 543871 541851 656925 462840 414103 469096 470453 480470 599847 439653 467712 473426 484608 599880 599927 641953 639739 641996 455793 414125 670366 154374 394648 413673 531844 541277 544848 541392 564293 545395 547477 583713 664166 713508 724309 757350 796905 510815 446386 391917 408692 513846 485546 827489 480502 448115 529713 534536 529714 534560 538879 569150 540945 541317 695866 590370 780684 803687 749064 749264 745111 752612 752669 753614 749255 752613 752642 611164 809371 399028 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.32%) |
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 154374 183506 391916 391917 392004 394648 399028 401204 408692 413673 414103 414125 419824 439653 441067 443773 446386 448115 448354 455793 462840 467712 469096 469219 470453 473426 476163 480470 480502 484608 485546 500339 500341 510815 511254 513846 529713 529714 530679 531844 531884 532655 534372 534536 534560 537864 538879 540945 541276 541277 541317 541392 541851 541863 542142 543871 544843 544848 545395 545434 547475 547477 547890 550899 564288 564293 569150 571194 583713 590370 591805 599847 599880 599927 611164 624197 639739 641953 641996 642029 656626 656925 660369 660417 664166 668690 670366 671038 672315 695866 695871 695887 713508 717516 724309 745111 749064 749255 749264 750668 752612 752613 752641 752642 752651 752666 752669 752697 753614 757350 759370 780684 782789 795420 796905 799362 803687 809371 819238 827489 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анальный фистинг мамо…"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал фистинг мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.57 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.