Query Metrics
7
Database Queries
7
Different statements
151.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.12 ms (78.82%) |
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 95673 96872 317791 318315 327170 383722 391945 397349 398940 414135 415050 418395 421571 423485 423572 428224 428883 432735 434334 436393 437793 438013 439156 443832 452300 452659 452767 453710 454313 454535 459513 465252 466693 468393 468742 470403 474776 476112 476136 476559 481820 489975 493220 493316 494438 496997 506705 510855 511259 519765 528329 528380 530448 533040 536426 536458 537653 545515 545631 555094 556876 560917 592462 596738 597834 606546 613375 620231 624472 659960 660029 660690 666374 669189 671465 672806 674129 706030 710500 720174 720277 720713 720719 720747 724853 727799 728391 729136 730074 731813 735554 736207 750317 756233 756406 759967 760032 760507 765307 765860 768386 786525 787637 790504 790882 797447 800191 800508 801235 811007 811152 811445 812824 815080 815299 815559 817963 820771 823940 828746 ] |
||||||||||||||||||||||||||||||
|
21.01 ms (13.90%) |
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 800508 736207 720713 414135 556876 434334 506705 493316 536458 443832 468742 383722 537653 669189 606546 759967 452767 432735 428224 437793 454535 474776 530448 494438 511259 560917 596738 724853 750317 468393 729136 597834 436393 453710 496997 820771 660029 666374 710500 720277 706030 613375 728391 731813 735554 760507 765307 620231 811152 421571 96872 423572 481820 823940 815299 454313 519765 756233 452659 510855 95673 397349 428883 452300 438013 415050 465252 528380 811445 318315 459513 828746 817963 476136 659960 528329 674129 660690 671465 786525 787637 797447 756406 760032 391945 489975 476559 327170 720174 418395 423485 466693 536426 545515 545631 720747 672806 730074 768386 727799 398940 317791 624472 476112 815559 815080 493220 533040 555094 720719 592462 790882 800191 801235 765860 790504 811007 812824 439156 470403 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.93%) |
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 95673 96872 317791 318315 327170 383722 391945 397349 398940 414135 415050 418395 421571 423485 423572 428224 428883 432735 434334 436393 437793 438013 439156 443832 452300 452659 452767 453710 454313 454535 459513 465252 466693 468393 468742 470403 474776 476112 476136 476559 481820 489975 493220 493316 494438 496997 506705 510855 511259 519765 528329 528380 530448 533040 536426 536458 537653 545515 545631 555094 556876 560917 592462 596738 597834 606546 613375 620231 624472 659960 660029 660690 666374 669189 671465 672806 674129 706030 710500 720174 720277 720713 720719 720747 724853 727799 728391 729136 730074 731813 735554 736207 750317 756233 756406 759967 760032 760507 765307 765860 768386 786525 787637 790504 790882 797447 800191 800508 801235 811007 811152 811445 812824 815080 815299 815559 817963 820771 823940 828746 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard mother anal"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard мам женщин анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard мам женщин анал"
]
|
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.