Query Metrics
7
Database Queries
7
Different statements
160.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.76 ms (83.96%) |
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 100685 183044 395182 398824 415592 418121 429596 432270 434313 434336 434376 435552 435553 449908 452720 454467 454531 455021 455793 456127 456939 460813 463420 464217 464959 466028 467877 468061 472066 475140 481961 489324 492695 498795 499789 502776 502877 503486 504474 506510 507032 511374 516656 519351 528407 531184 541567 541757 543648 546971 547762 554166 555245 555306 556896 561495 564767 565425 566843 569922 579863 583807 584125 586374 587442 593750 599961 602793 605742 618267 629771 629797 630270 633132 634472 643027 648220 648235 661061 669877 678836 678838 681251 703930 705427 714238 728465 733280 734868 736033 738518 747483 763724 767731 768881 777989 780553 793940 794030 794217 795029 797006 797178 798727 800884 801000 803046 807008 807011 807994 809679 810299 810461 811221 813296 813918 815695 816973 817113 828131 ] |
||||||||||||||||||||||||||||||
|
15.84 ms (9.87%) |
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 618267 398824 415592 489324 455021 435553 435552 434336 429596 418121 454531 452720 464217 434313 395182 554166 463420 555306 593750 503486 499789 541567 566843 602793 828131 648220 813918 586374 811221 541757 605742 763724 454467 546971 747483 797006 432270 504474 468061 547762 807011 728465 800884 472066 460813 475140 502776 516656 466028 511374 519351 502877 507032 543648 555245 810461 734868 793940 183044 467877 455793 643027 528407 579863 583807 498795 678836 661061 714238 556896 565425 629771 629797 807008 813296 767731 768881 705427 801000 795029 733280 798727 809679 464959 506510 564767 669877 681251 633132 587442 738518 703930 736033 797178 584125 817113 561495 648235 569922 634472 599961 434376 816973 815695 456939 456127 807994 481961 492695 678838 777989 780553 794217 449908 531184 810299 803046 100685 630270 794030 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.86%) |
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 100685 183044 395182 398824 415592 418121 429596 432270 434313 434336 434376 435552 435553 449908 452720 454467 454531 455021 455793 456127 456939 460813 463420 464217 464959 466028 467877 468061 472066 475140 481961 489324 492695 498795 499789 502776 502877 503486 504474 506510 507032 511374 516656 519351 528407 531184 541567 541757 543648 546971 547762 554166 555245 555306 556896 561495 564767 565425 566843 569922 579863 583807 584125 586374 587442 593750 599961 602793 605742 618267 629771 629797 630270 633132 634472 643027 648220 648235 661061 669877 678836 678838 681251 703930 705427 714238 728465 733280 734868 736033 738518 747483 763724 767731 768881 777989 780553 793940 794030 794217 795029 797006 797178 798727 800884 801000 803046 807008 807011 807994 809679 810299 810461 811221 813296 813918 815695 816973 817113 828131 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother squirt"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.00%) |
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.