Query Metrics
7
Database Queries
7
Different statements
165.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.06 ms (81.48%) |
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 33917 387742 393481 400480 411199 421819 421829 421843 421851 421854 422198 422203 429416 430783 435747 437793 439292 439696 439714 439809 440894 443822 444344 448374 452547 453493 453750 457420 457431 459520 459541 464248 465532 469347 469487 469489 470949 472857 480757 481971 482298 483567 484440 484696 485216 485276 486884 490418 490822 490898 491925 493167 497005 499904 500797 502253 502816 505843 509559 513686 514585 517863 521142 526454 528386 528708 530729 534035 535433 535441 544292 549824 549845 551468 554913 555593 561004 563158 563228 563445 583097 601848 618847 620237 622064 630053 635916 642346 643263 643316 666527 667824 668660 670951 670959 671584 673772 718890 723153 724153 724371 733315 743065 744389 756115 757312 760965 766734 775473 778172 786537 788944 790190 791926 799949 802028 802493 806143 806146 819534 ] |
||||||||||||||||||||||||||||||
|
19.90 ms (12.00%) |
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 465532 544292 563445 718890 667824 723153 620237 622064 635916 786537 757312 459520 429416 411199 490898 819534 472857 448374 673772 802028 778172 788944 790190 799949 744389 756115 760965 802493 806143 453750 671584 555593 561004 766734 439809 459541 733315 469489 439696 480757 443822 490418 393481 551468 549845 554913 421854 422198 422203 444344 439714 481971 505843 535441 485276 530729 534035 502253 630053 743065 517863 528708 563158 490822 643316 470949 453493 502816 528386 486884 583097 670959 549824 601848 482298 457420 469347 521142 485216 509559 514585 535433 493167 500797 513686 526454 670951 484440 33917 387742 400480 439292 440894 437793 457431 464248 452547 483567 499904 497005 668660 618847 643263 642346 775473 791926 724371 806146 421829 421843 469487 421819 430783 421851 491925 563228 724153 666527 484696 435747 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (2.05%) |
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 33917 387742 393481 400480 411199 421819 421829 421843 421851 421854 422198 422203 429416 430783 435747 437793 439292 439696 439714 439809 440894 443822 444344 448374 452547 453493 453750 457420 457431 459520 459541 464248 465532 469347 469487 469489 470949 472857 480757 481971 482298 483567 484440 484696 485216 485276 486884 490418 490822 490898 491925 493167 497005 499904 500797 502253 502816 505843 509559 513686 514585 517863 521142 526454 528386 528708 530729 534035 535433 535441 544292 549824 549845 551468 554913 555593 561004 563158 563228 563445 583097 601848 618847 620237 622064 630053 635916 642346 643263 643316 666527 667824 668660 670951 670959 671584 673772 718890 723153 724153 724371 733315 743065 744389 756115 757312 760965 766734 775473 778172 786537 788944 790190 791926 799949 802028 802493 806143 806146 819534 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature maid anal"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature горничн анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature горничн анал"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
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.