Query Metrics
7
Database Queries
7
Different statements
164.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.73 ms (84.92%) |
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 386016 387490 401946 402346 405043 407279 411045 411715 411823 412790 415579 428700 440828 441280 441359 445086 446274 449092 452816 453099 453189 453734 455910 457999 459541 460009 462315 464228 467016 467691 474056 475889 484224 486590 489317 490399 490409 491431 494870 495852 500342 509060 511250 511274 513261 513474 513518 517121 518600 518908 518948 523019 523674 524370 524371 525376 526164 527158 528108 532932 532953 533884 540794 540802 544753 555130 555994 555996 557486 563425 570954 574456 577634 579840 586564 586862 588144 590255 590272 591131 591353 598277 601672 619508 619516 631970 635222 639742 645861 647612 660359 663263 664322 665273 668672 668690 669062 673142 714443 715807 722322 746774 758114 761583 767130 769645 769959 773404 774333 789690 800906 801948 804210 806793 807597 812987 814885 815600 815699 816423 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (9.14%) |
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 540802 524370 445086 411715 816423 446274 457999 495852 517121 526164 527158 532932 494870 518908 574456 563425 577634 665273 669062 664322 722322 663263 668690 673142 714443 579840 591353 631970 804210 807597 769959 774333 758114 767130 769645 800906 801948 387490 411823 460009 474056 440828 518600 525376 489317 405043 511274 555994 555996 590272 598277 773404 467016 490399 588144 591131 401946 715807 523674 645861 619516 462315 490409 386016 441359 415579 411045 441280 814885 815699 464228 449092 453189 484224 452816 532953 533884 528108 467691 647612 660359 601672 586862 812987 412790 459541 509060 453734 815600 455910 453099 475889 518948 635222 639742 619508 789690 511250 513518 524371 540794 486590 513474 402346 407279 668672 523019 586564 544753 761583 491431 590255 555130 500342 428700 513261 557486 570954 746774 806793 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.73%) |
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 386016 387490 401946 402346 405043 407279 411045 411715 411823 412790 415579 428700 440828 441280 441359 445086 446274 449092 452816 453099 453189 453734 455910 457999 459541 460009 462315 464228 467016 467691 474056 475889 484224 486590 489317 490399 490409 491431 494870 495852 500342 509060 511250 511274 513261 513474 513518 517121 518600 518908 518948 523019 523674 524370 524371 525376 526164 527158 528108 532932 532953 533884 540794 540802 544753 555130 555994 555996 557486 563425 570954 574456 577634 579840 586564 586862 588144 590255 590272 591131 591353 598277 601672 619508 619516 631970 635222 639742 645861 647612 660359 663263 664322 665273 668672 668690 669062 673142 714443 715807 722322 746774 758114 761583 767130 769645 769959 773404 774333 789690 800906 801948 804210 806793 807597 812987 814885 815600 815699 816423 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sexy ass"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature sexy жоп"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature sexy жоп"
]
|
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.