Query Metrics
7
Database Queries
7
Different statements
176.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.90 ms (85.31%) |
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 384457 418761 419599 427997 432618 432663 435114 437793 440779 440788 440860 440897 440923 441359 441416 442211 442775 445350 449158 450371 452862 454306 454926 455218 456202 456587 457171 460660 460873 461767 464800 464808 465097 465270 466797 467631 467935 468288 471538 472438 474444 474894 475452 477007 478740 480718 482191 485273 491583 492460 493426 495437 496539 499840 504450 507674 510937 512937 513510 513975 515959 529249 529331 530005 534808 546107 547584 549686 549708 552664 552697 555377 555592 555593 558883 562975 569094 573751 579471 588082 589070 590929 591355 592596 606626 612235 630351 631607 641160 652010 656498 666695 669275 670625 678868 680440 697010 711417 712549 716693 733144 738347 741779 742728 742735 756990 759920 760980 761137 761169 761722 761848 767116 767252 768031 768032 785530 795485 796804 809666 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (9.21%) |
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 761169 767116 768031 741779 742728 742735 759920 760980 761722 761848 738347 756990 767252 768032 630351 641160 711417 795485 809666 432618 460660 465097 467935 461767 477007 418761 452862 471538 460873 478740 456587 510937 496539 507674 465270 482191 712549 606626 733144 441416 449158 442775 467631 384457 440788 466797 579471 761137 697010 440779 472438 499840 529249 468288 504450 530005 515959 552664 573751 569094 455218 456202 493426 485273 513510 475452 558883 612235 796804 441359 427997 440923 432663 435114 440860 440897 419599 437793 442211 445350 450371 454306 457171 474894 474444 480718 491583 454926 492460 495437 513975 534808 512937 529331 464800 464808 546107 547584 549686 549708 555377 555592 666695 680440 652010 669275 678868 656498 670625 716693 552697 555593 562975 590929 591355 592596 631607 588082 589070 785530 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.55%) |
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 384457 418761 419599 427997 432618 432663 435114 437793 440779 440788 440860 440897 440923 441359 441416 442211 442775 445350 449158 450371 452862 454306 454926 455218 456202 456587 457171 460660 460873 461767 464800 464808 465097 465270 466797 467631 467935 468288 471538 472438 474444 474894 475452 477007 478740 480718 482191 485273 491583 492460 493426 495437 496539 499840 504450 507674 510937 512937 513510 513975 515959 529249 529331 530005 534808 546107 547584 549686 549708 552664 552697 555377 555592 555593 558883 562975 569094 573751 579471 588082 589070 590929 591355 592596 606626 612235 630351 631607 641160 652010 656498 666695 669275 670625 678868 680440 697010 711417 712549 716693 733144 738347 741779 742728 742735 756990 759920 760980 761137 761169 761722 761848 767116 767252 768031 768032 785530 795485 796804 809666 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature wife creampie"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature жен creampie"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature жен creampie"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
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.