Query Metrics
7
Database Queries
7
Different statements
141.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.44 ms (82.00%) |
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 311097 384501 384908 393417 397962 398230 399388 400439 400619 401614 401632 402080 403346 413258 415983 418077 418530 419233 419625 420331 420577 421122 423646 425891 426944 427869 445220 458511 458713 460661 462521 463737 463952 464427 468757 470380 474910 476632 476761 477734 481816 483243 484754 487088 488101 488137 489857 489875 491457 491641 494397 497586 500736 502124 510203 511179 511759 512258 513860 515835 516261 517911 519742 520417 522966 523155 536876 539442 546019 549373 553854 558045 559114 560653 566297 568124 570366 570435 572696 573848 586985 593897 598390 598599 604064 606817 617096 623435 631676 633518 650317 654974 659106 662125 670461 676527 678339 691584 696463 700251 704056 708725 709306 723629 724935 725891 744717 751485 751952 755387 758691 760970 760975 763746 773826 778102 778374 781343 791018 794060 ] |
||||||||||||||||||||||||||||||
|
15.60 ms (10.99%) |
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 462521 423646 497586 511179 517911 512258 384501 397962 723629 758691 401614 421122 413258 427869 460661 470380 494397 484754 520417 402080 403346 536876 445220 463737 700251 650317 708725 778102 393417 744717 566297 516261 491457 398230 458511 463952 425891 476761 481816 522966 491641 558045 549373 654974 604064 724935 420577 553854 678339 476632 510203 606817 419625 426944 418530 458713 488137 500736 523155 399388 511759 570435 670461 791018 794060 400439 420331 568124 633518 593897 696463 704056 598390 781343 760970 751485 311097 489857 489875 559114 572696 623435 760975 474910 415983 468757 477734 418077 419233 515835 519742 483243 502124 513860 488101 659106 751952 539442 763746 617096 709306 384908 401632 598599 464427 570366 560653 573848 676527 546019 586985 773826 725891 778374 487088 662125 631676 755387 400619 691584 ] |
||||||||||||||||||||||||||||||
|
2.75 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 311097 384501 384908 393417 397962 398230 399388 400439 400619 401614 401632 402080 403346 413258 415983 418077 418530 419233 419625 420331 420577 421122 423646 425891 426944 427869 445220 458511 458713 460661 462521 463737 463952 464427 468757 470380 474910 476632 476761 477734 481816 483243 484754 487088 488101 488137 489857 489875 491457 491641 494397 497586 500736 502124 510203 511179 511759 512258 513860 515835 516261 517911 519742 520417 522966 523155 536876 539442 546019 549373 553854 558045 559114 560653 566297 568124 570366 570435 572696 573848 586985 593897 598390 598599 604064 606817 617096 623435 631676 633518 650317 654974 659106 662125 670461 676527 678339 691584 696463 700251 704056 708725 709306 723629 724935 725891 744717 751485 751952 755387 758691 760970 760975 763746 773826 778102 778374 781343 791018 794060 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big girl beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие девушк красивая"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие девушк красивая"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.13%) |
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.