Query Metrics
7
Database Queries
7
Different statements
193.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.00 ms (87.27%) |
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 206202 381776 383925 390967 391072 393756 394198 395841 395929 395975 400459 400465 401116 401993 414498 418649 428523 429214 429342 447675 451741 453553 464595 468085 468805 474162 476075 477543 492595 515140 520251 520718 527503 529117 536674 562804 563053 566505 566523 570054 575072 581628 595863 596650 597960 598069 598470 600165 603304 605322 605324 605328 605330 609884 626553 627740 628362 630018 630977 635968 640427 645003 663437 667563 678803 681808 682022 683515 684914 691992 696995 698293 703113 704533 707312 712719 714428 715575 717708 717713 720439 720825 721445 722915 724509 727747 728359 728384 730728 731869 732001 735396 736042 738283 740704 742434 743341 743383 744329 746472 748091 748128 748685 753320 757367 757442 774178 777646 788595 789417 795704 799002 800305 800332 800563 810032 811128 811164 811647 825808 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (7.66%) |
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 630977 777646 740704 743341 757367 800305 811647 724509 728384 757442 748685 698293 715575 717708 717713 799002 811128 414498 390967 527503 825808 581628 683515 682022 681808 600165 789417 795704 735396 746472 738283 748091 703113 720439 206202 393756 381776 428523 418649 645003 453553 468805 515140 529117 474162 563053 562804 570054 566505 663437 714428 667563 684914 696995 707312 678803 720825 722915 566523 596650 603304 595863 626553 744329 748128 774178 704533 788595 394198 400459 429342 520251 520718 492595 395975 391072 400465 451741 464595 476075 468085 536674 575072 691992 712719 721445 597960 598069 598470 605324 635968 609884 605322 605328 605330 627740 628362 811164 800563 727747 810032 731869 736042 728359 743383 732001 730728 742434 753320 630018 640427 800332 447675 477543 395841 401993 429214 383925 395929 401116 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (2.04%) |
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 206202 381776 383925 390967 391072 393756 394198 395841 395929 395975 400459 400465 401116 401993 414498 418649 428523 429214 429342 447675 451741 453553 464595 468085 468805 474162 476075 477543 492595 515140 520251 520718 527503 529117 536674 562804 563053 566505 566523 570054 575072 581628 595863 596650 597960 598069 598470 600165 603304 605322 605324 605328 605330 609884 626553 627740 628362 630018 630977 635968 640427 645003 663437 667563 678803 681808 682022 683515 684914 691992 696995 698293 703113 704533 707312 712719 714428 715575 717708 717713 720439 720825 721445 722915 724509 727747 728359 728384 730728 731869 732001 735396 736042 738283 740704 742434 743341 743383 744329 746472 748091 748128 748685 753320 757367 757442 774178 777646 788595 789417 795704 799002 800305 800332 800563 810032 811128 811164 811647 825808 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen old"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen and old"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen old"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.