Query Metrics
7
Database Queries
7
Different statements
151.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.03 ms (82.02%) |
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 407657 480379 480396 523051 531525 532170 532776 534268 534274 534334 534394 535017 535264 535369 546511 558904 561375 565150 566606 570726 577390 581596 582800 585689 586673 586674 586676 587257 587907 588211 588283 589023 589116 596075 596082 599200 604310 607618 607713 612431 621635 632018 633136 633150 633158 633166 633176 637758 640022 640691 640710 640713 642677 643113 643523 647595 650419 650421 650785 663566 683313 693642 713564 727482 746339 775814 785423 787020 788149 788815 790793 790794 790799 792610 792621 792626 792632 792655 797659 801960 807023 807707 808444 808467 808472 808579 808600 813228 814733 814738 814748 814749 814760 814784 814808 814814 814829 814832 814837 814842 814845 814847 814850 814857 814859 814865 814890 814892 814901 814908 814921 814928 814937 814938 814940 814945 815368 815530 815770 815931 ] |
||||||||||||||||||||||||||||||
|
18.01 ms (11.91%) |
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 570726 647595 585689 587907 775814 792655 808600 792626 633136 599200 815368 814857 814945 532170 788149 813228 792621 640691 546511 589116 532776 531525 815931 642677 586676 604310 814938 814808 814908 814738 814928 693642 650421 650785 640713 807707 607618 815770 814940 814850 814748 814760 814784 814837 814847 814814 814829 814921 534268 566606 581596 633150 596075 607713 787020 790794 790793 790799 792610 785423 727482 814749 792632 808467 808472 565150 621635 814842 582800 814865 814937 814832 480379 535264 612431 586674 596082 640710 808444 814859 814733 814845 640022 588283 643523 586673 801960 808579 633176 683313 577390 663566 788815 407657 815530 746339 637758 480396 535369 535017 561375 797659 534334 650419 814890 534274 534394 558904 588211 633158 589023 587257 807023 814892 633166 643113 713564 523051 814901 632018 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.64%) |
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 407657 480379 480396 523051 531525 532170 532776 534268 534274 534334 534394 535017 535264 535369 546511 558904 561375 565150 566606 570726 577390 581596 582800 585689 586673 586674 586676 587257 587907 588211 588283 589023 589116 596075 596082 599200 604310 607618 607713 612431 621635 632018 633136 633150 633158 633166 633176 637758 640022 640691 640710 640713 642677 643113 643523 647595 650419 650421 650785 663566 683313 693642 713564 727482 746339 775814 785423 787020 788149 788815 790793 790794 790799 792610 792621 792626 792632 792655 797659 801960 807023 807707 808444 808467 808472 808579 808600 813228 814733 814738 814748 814749 814760 814784 814808 814814 814829 814832 814837 814842 814845 814847 814850 814857 814859 814865 814890 814892 814901 814908 814921 814928 814937 814938 814940 814945 815368 815530 815770 815931 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers mom big"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers mom большие"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers mom большие"
]
|
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.