Query Metrics
7
Database Queries
7
Different statements
166.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.50 ms (85.84%) |
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 382165 395305 397508 400677 416163 417343 435045 438010 438062 440749 443986 448273 449643 452448 453692 455278 459222 459536 462151 463146 464713 470077 471517 472389 476553 476972 481913 482211 487747 488937 497056 497298 498757 499621 500218 500252 501066 501998 502754 503233 505773 510723 514475 519442 521439 521530 522659 523269 524462 524774 527312 527314 534583 534785 537021 541852 544562 547717 549624 550963 553949 554161 555234 560942 563650 563707 568834 570087 571733 577607 580982 581729 585755 597172 609187 638496 641109 647212 667436 680936 691240 711509 713693 724265 741591 743764 745685 747340 748134 750030 753645 760217 761211 762475 762629 763886 766417 766473 769376 770017 784191 784410 789922 793019 795363 797537 798735 798852 807289 809223 816752 817391 817409 817428 817611 817697 818701 818792 825641 827406 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (8.44%) |
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 825641 563707 760217 395305 766417 537021 455278 549624 519442 521439 680936 784410 784191 459222 563650 641109 797537 471517 713693 711509 482211 547717 521530 762475 554161 417343 527312 488937 743764 524774 817391 817409 443986 609187 741591 745685 763886 400677 523269 435045 638496 550963 440749 452448 807289 798735 382165 581729 795363 724265 453692 568834 827406 748134 762629 472389 449643 462151 481913 647212 500252 501998 500218 534583 497056 524462 464713 497298 747340 789922 597172 438010 501066 809223 544562 522659 691240 585755 514475 499621 667436 818701 498757 534785 560942 770017 577607 769376 505773 541852 571733 553949 476553 503233 416163 817428 817611 753645 750030 502754 510723 438062 570087 463146 448273 397508 487747 470077 476972 527314 817697 818792 816752 793019 459536 580982 798852 555234 761211 766473 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.79%) |
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 382165 395305 397508 400677 416163 417343 435045 438010 438062 440749 443986 448273 449643 452448 453692 455278 459222 459536 462151 463146 464713 470077 471517 472389 476553 476972 481913 482211 487747 488937 497056 497298 498757 499621 500218 500252 501066 501998 502754 503233 505773 510723 514475 519442 521439 521530 522659 523269 524462 524774 527312 527314 534583 534785 537021 541852 544562 547717 549624 550963 553949 554161 555234 560942 563650 563707 568834 570087 571733 577607 580982 581729 585755 597172 609187 638496 641109 647212 667436 680936 691240 711509 713693 724265 741591 743764 745685 747340 748134 750030 753645 760217 761211 762475 762629 763886 766417 766473 769376 770017 784191 784410 789922 793019 795363 797537 798735 798852 807289 809223 816752 817391 817409 817428 817611 817697 818701 818792 825641 827406 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob amateur car"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс любительск вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.78%) |
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.