Query Metrics
7
Database Queries
7
Different statements
223.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
200.44 ms (89.81%) |
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 119495 398794 399218 399952 400957 401049 426021 428173 429107 438973 441656 444204 455363 457800 459503 461984 464754 467689 470067 470143 470269 472192 473231 474067 476754 478850 479571 480854 480856 481483 485535 487173 487446 488726 490847 491476 491549 491720 491946 492348 494062 497993 500236 500704 500873 501883 505031 508946 509518 510979 511912 511959 512258 512288 513203 516919 519680 531012 533580 533768 540730 542072 542876 542951 544442 545670 551244 552076 552236 552620 562242 565439 566299 570334 573582 574843 588899 596629 597196 598821 600064 619949 626882 643541 653546 654721 654783 656728 658496 658698 660499 660525 672457 676517 679351 689458 691812 697135 721277 722296 723599 740807 741261 742938 761471 761797 766792 770437 778226 778647 778761 779300 779724 781120 783857 785965 790186 791060 813319 825679 ] |
||||||||||||||||||||||||||||||
|
12.70 ms (5.69%) |
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 542951 551244 570334 573582 574843 598821 600064 596629 399218 459503 473231 480854 480856 470269 481483 474067 476754 444204 457800 461984 438973 464754 491946 494062 501883 509518 510979 485535 500704 500873 512288 487173 497993 511912 676517 697135 643541 479571 508946 512258 533580 619949 779724 783857 492348 542876 470143 513203 516919 505031 597196 545670 565439 588899 426021 470067 401049 491549 491720 429107 742938 119495 531012 533768 552620 723599 540730 689458 778761 778226 781120 761471 741261 761797 399952 778647 790186 488726 721277 400957 491476 552076 542072 441656 428173 467689 478850 472192 511959 519680 487446 398794 455363 500236 656728 691812 740807 813319 490847 791060 825679 544442 566299 654783 658496 658698 660525 672457 654721 660499 679351 722296 653546 552236 562242 626882 785965 779300 766792 770437 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.47%) |
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 119495 398794 399218 399952 400957 401049 426021 428173 429107 438973 441656 444204 455363 457800 459503 461984 464754 467689 470067 470143 470269 472192 473231 474067 476754 478850 479571 480854 480856 481483 485535 487173 487446 488726 490847 491476 491549 491720 491946 492348 494062 497993 500236 500704 500873 501883 505031 508946 509518 510979 511912 511959 512258 512288 513203 516919 519680 531012 533580 533768 540730 542072 542876 542951 544442 545670 551244 552076 552236 552620 562242 565439 566299 570334 573582 574843 588899 596629 597196 598821 600064 619949 626882 643541 653546 654721 654783 656728 658496 658698 660499 660525 672457 676517 679351 689458 691812 697135 721277 722296 723599 740807 741261 742938 761471 761797 766792 770437 778226 778647 778761 779300 779724 781120 783857 785965 790186 791060 813319 825679 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful russian girl"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая русск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.