Query Metrics
7
Database Queries
7
Different statements
165.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.08 ms (83.96%) |
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 3561 391371 398543 422180 424721 429861 432884 439393 441160 445041 445078 446446 449377 452822 452948 452960 455915 456230 457292 460016 460196 467878 467885 467886 467903 468146 471022 471113 471682 476191 477021 478523 479106 480676 483537 483735 490232 490731 495566 500787 504509 507032 513630 513642 513977 517810 519358 519700 527923 528608 530021 532830 534546 541276 541322 541394 541832 542142 545395 545434 554489 554989 555062 555236 555771 564293 569050 571726 574386 577313 586975 589701 594340 594606 595072 599354 604265 605274 605379 606503 607706 607716 622385 624197 628113 632107 633119 648710 660364 678707 707408 722388 726946 740141 748522 752641 752697 754436 757883 758785 758786 758790 761608 766124 772578 777094 794647 794669 796675 799161 800508 802742 804432 806794 806947 807597 812367 812542 813597 819237 ] |
||||||||||||||||||||||||||||||
|
16.39 ms (9.89%) |
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 455915 477021 513977 571726 607706 429861 468146 483735 432884 439393 422180 445078 490232 449377 452948 471682 452822 460196 532830 534546 530021 500787 519700 541394 541322 564293 541276 542142 545395 577313 648710 660364 678707 545434 554989 605379 606503 586975 589701 604265 624197 594340 628113 605274 802742 806794 812367 812542 794669 799161 806947 807597 752641 752697 757883 758785 726946 758786 758790 761608 766124 754436 633119 707408 722388 777094 796675 391371 441160 467885 452960 513630 446446 495566 467878 813597 398543 819237 794647 800508 772578 804432 748522 527923 479106 594606 3561 445041 483537 471022 507032 555236 555771 595072 740141 478523 513642 476191 574386 457292 424721 460016 456230 528608 554489 569050 555062 599354 622385 632107 607716 467886 467903 471113 480676 519358 490731 504509 517810 541832 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.81%) |
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 3561 391371 398543 422180 424721 429861 432884 439393 441160 445041 445078 446446 449377 452822 452948 452960 455915 456230 457292 460016 460196 467878 467885 467886 467903 468146 471022 471113 471682 476191 477021 478523 479106 480676 483537 483735 490232 490731 495566 500787 504509 507032 513630 513642 513977 517810 519358 519700 527923 528608 530021 532830 534546 541276 541322 541394 541832 542142 545395 545434 554489 554989 555062 555236 555771 564293 569050 571726 574386 577313 586975 589701 594340 594606 595072 599354 604265 605274 605379 606503 607706 607716 622385 624197 628113 632107 633119 648710 660364 678707 707408 722388 726946 740141 748522 752641 752697 754436 757883 758785 758786 758790 761608 766124 772578 777094 794647 794669 796675 799161 800508 802742 804432 806794 806947 807597 812367 812542 813597 819237 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature solo dildo"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature соло дилд"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"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.