Query Metrics
7
Database Queries
7
Different statements
205.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.08 ms (87.46%) |
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 88436 382275 382578 397685 399083 400571 401546 414071 414137 414604 416523 417601 420686 420864 423435 423783 423787 423936 428927 442430 445012 447597 448263 457814 460540 463435 465148 471088 471148 473038 476054 477516 479816 491642 493807 495379 497799 502641 508924 510729 511273 511407 518884 522173 531579 532560 534636 536224 540746 544964 547743 554980 555004 561972 568236 569258 569746 571042 586136 598940 599104 605900 607686 616236 621229 622025 624688 639315 642403 644219 648898 649583 663811 674625 678816 679093 680578 697614 697958 698385 703806 705507 715168 721521 729327 735535 739125 744963 746096 749215 755592 756108 756192 763739 766335 768765 769435 770270 774883 780165 781455 782548 784035 784738 785816 785960 786365 789234 791523 791871 795714 803770 803931 805219 806543 808446 808612 810870 814970 825004 ] |
||||||||||||||||||||||||||||||
|
14.58 ms (7.08%) |
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 739125 770270 763739 423787 442430 476054 382578 416523 423435 491642 518884 531579 447597 423936 495379 414071 448263 511407 532560 534636 571042 649583 544964 586136 598940 642403 756192 766335 399083 460540 511273 493807 497799 471148 569258 814970 648898 703806 715168 678816 680578 639315 616236 644219 621229 780165 805219 755592 768765 785960 789234 810870 729327 735535 744963 746096 698385 705507 784035 791871 803770 803931 808612 428927 397685 825004 569746 756108 795714 414137 465148 400571 420686 420864 473038 540746 536224 554980 607686 599104 382275 463435 88436 445012 477516 502641 508924 510729 522173 568236 457814 401546 471088 423783 479816 414604 417601 561972 547743 674625 679093 697614 663811 697958 721521 555004 605900 624688 622025 774883 781455 784738 785816 786365 806543 808446 749215 769435 782548 791523 ] |
||||||||||||||||||||||||||||||
|
4.51 ms (2.19%) |
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 88436 382275 382578 397685 399083 400571 401546 414071 414137 414604 416523 417601 420686 420864 423435 423783 423787 423936 428927 442430 445012 447597 448263 457814 460540 463435 465148 471088 471148 473038 476054 477516 479816 491642 493807 495379 497799 502641 508924 510729 511273 511407 518884 522173 531579 532560 534636 536224 540746 544964 547743 554980 555004 561972 568236 569258 569746 571042 586136 598940 599104 605900 607686 616236 621229 622025 624688 639315 642403 644219 648898 649583 663811 674625 678816 679093 680578 697614 697958 698385 703806 705507 715168 721521 729327 735535 739125 744963 746096 749215 755592 756108 756192 763739 766335 768765 769435 770270 774883 780165 781455 782548 784035 784738 785816 785960 786365 789234 791523 791871 795714 803770 803931 805219 806543 808446 808612 810870 814970 825004 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty dildo"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty дилд"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty дилд"
]
|
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.