Query Metrics
7
Database Queries
7
Different statements
232.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.90 ms (89.83%) |
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 6806 55349 188223 188556 191361 370715 382786 385007 387366 395479 452445 452640 456046 459133 464896 472271 482815 483140 485688 488402 489172 501263 504176 505074 513972 529286 531489 540543 543943 544792 545106 545449 546026 547042 548996 549719 550904 552853 555004 555297 555302 556408 558715 560410 560533 563709 563710 563989 564764 565026 565097 567432 586219 586973 588929 589650 595316 602488 604822 607814 610911 622823 624751 625779 628709 640321 656200 660043 663902 665346 698251 700660 707497 717386 726423 732579 733352 733668 735939 737554 742560 745968 748653 753550 758048 758754 759397 760713 760959 761162 761754 761759 762449 765729 765927 766658 766696 767172 769094 771147 776264 776993 778103 778298 782628 786197 787521 790191 791555 791601 798633 799567 799683 800974 803532 804335 807304 810625 813181 814940 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (5.80%) |
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 472271 543943 544792 545449 546026 549719 558715 560410 560533 565097 550904 555302 556408 563710 547042 548996 552853 563989 663902 656200 698251 717386 660043 665346 545106 555004 563709 565026 604822 607814 589650 595316 602488 622823 640321 588929 610911 624751 628709 586973 776264 782628 786197 799567 800974 776993 778298 791601 798633 803532 804335 733352 748653 761754 761759 766696 767172 769094 791555 807304 810625 813181 737554 753550 759397 762449 766658 742560 758754 760959 733668 735939 761162 771147 726423 732579 745968 758048 760713 765729 765927 625779 700660 707497 778103 787521 790191 799683 6806 464896 395479 456046 55349 191361 382786 459133 188223 385007 489172 505074 586219 188556 370715 387366 814940 452445 452640 488402 482815 485688 504176 513972 529286 531489 540543 501263 483140 564764 555297 567432 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (1.60%) |
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 6806 55349 188223 188556 191361 370715 382786 385007 387366 395479 452445 452640 456046 459133 464896 472271 482815 483140 485688 488402 489172 501263 504176 505074 513972 529286 531489 540543 543943 544792 545106 545449 546026 547042 548996 549719 550904 552853 555004 555297 555302 556408 558715 560410 560533 563709 563710 563989 564764 565026 565097 567432 586219 586973 588929 589650 595316 602488 604822 607814 610911 622823 624751 625779 628709 640321 656200 660043 663902 665346 698251 700660 707497 717386 726423 732579 733352 733668 735939 737554 742560 745968 748653 753550 758048 758754 759397 760713 760959 761162 761754 761759 762449 765729 765927 766658 766696 767172 769094 771147 776264 776993 778103 778298 782628 786197 787521 790191 791555 791601 798633 799567 799683 800974 803532 804335 807304 810625 813181 814940 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding mature"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding mature"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding mature"
]
|
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.