Query Metrics
7
Database Queries
7
Different statements
149.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.57 ms (84.90%) |
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 102043 102334 383325 384238 385953 386024 387777 387946 389234 389570 393095 395145 399876 400055 400964 401218 410324 416200 416784 417324 417783 418028 418689 419211 421260 429563 430436 434392 434971 435452 435496 435731 440680 442702 442720 443241 447039 448108 449880 457368 458206 458209 461755 462222 464646 467110 467111 468525 472257 472768 473500 475481 475994 479016 479703 483570 483573 484797 485175 486181 488931 496285 496310 501329 502900 508450 512534 513669 514071 518976 520734 520739 523361 536927 540381 556181 575197 584576 586460 589544 599781 601074 601181 604498 604526 604583 614053 622285 649867 651083 651094 667278 668961 710872 716140 719938 720667 724536 729890 729937 729940 737717 754170 758557 770524 775532 787738 792587 792817 796241 804370 807362 808786 810455 815658 815812 816218 821739 822298 823396 ] |
||||||||||||||||||||||||||||||
|
11.82 ms (7.93%) |
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 651094 719938 508450 443241 485175 417783 410324 448108 484797 457368 668961 716140 807362 792587 808786 754170 418028 435452 440680 449880 395145 421260 479703 651083 584576 724536 416784 435496 514071 429563 496285 386024 385953 435731 473500 815658 472257 520734 821739 540381 442702 384238 387777 418689 667278 823396 483573 729937 102043 496310 416200 720667 710872 599781 601074 622285 604498 604583 729890 419211 486181 614053 770524 729940 796241 447039 737717 810455 816218 556181 389570 400055 501329 775532 468525 479016 417324 387946 458206 512534 536927 758557 472768 399876 518976 520739 601181 430436 649867 586460 383325 401218 488931 461755 393095 464646 483570 102334 389234 467110 523361 787738 604526 792817 475481 458209 462222 815812 804370 442720 434971 513669 400964 575197 589544 434392 822298 467111 475994 502900 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.86%) |
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 102043 102334 383325 384238 385953 386024 387777 387946 389234 389570 393095 395145 399876 400055 400964 401218 410324 416200 416784 417324 417783 418028 418689 419211 421260 429563 430436 434392 434971 435452 435496 435731 440680 442702 442720 443241 447039 448108 449880 457368 458206 458209 461755 462222 464646 467110 467111 468525 472257 472768 473500 475481 475994 479016 479703 483570 483573 484797 485175 486181 488931 496285 496310 501329 502900 508450 512534 513669 514071 518976 520734 520739 523361 536927 540381 556181 575197 584576 586460 589544 599781 601074 601181 604498 604526 604583 614053 622285 649867 651083 651094 667278 668961 710872 716140 719938 720667 724536 729890 729937 729940 737717 754170 758557 770524 775532 787738 792587 792817 796241 804370 807362 808786 810455 815658 815812 816218 821739 822298 823396 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс чернокожая"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс чернокожая"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.