Query Metrics
7
Database Queries
7
Different statements
226.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.62 ms (87.78%) |
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 421015 430404 430433 430446 433730 434044 434097 435745 442697 446729 450767 450804 454523 454883 454916 460751 465198 466241 468017 470280 474114 474463 477881 478931 485066 486125 489328 489373 489955 493156 494231 498045 501477 502304 510217 510296 510456 513722 514575 515416 517282 518497 519169 519653 519825 519845 521761 522917 524573 526161 527416 531066 533186 534823 535488 541831 541833 542993 543193 545802 546116 556525 556938 558012 558762 563220 568463 568505 569002 569031 569092 569228 570845 571217 572537 575302 578496 580388 586499 587418 590312 592570 592675 593294 593596 595011 603258 604109 606608 607355 612074 612843 614308 619466 630916 632694 633150 639060 639257 642714 644718 647995 649836 651601 667232 699554 740690 785909 788132 788994 790696 792550 792553 792555 792557 797464 806060 811220 813249 816007 ] |
||||||||||||||||||||||||||||||
|
18.61 ms (8.22%) |
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 450767 486125 531066 603258 546116 785909 792553 474463 434097 493156 699554 633150 489328 430446 541833 556525 430433 593294 465198 578496 569228 575302 571217 569031 604109 587418 806060 478931 446729 450804 614308 468017 421015 647995 454916 797464 524573 619466 811220 545802 570845 790696 792550 813249 642714 517282 519653 649836 667232 639060 527416 533186 502304 518497 535488 541831 474114 514575 563220 606608 460751 498045 644718 651601 595011 580388 607355 489373 630916 612843 740690 430404 485066 434044 510217 466241 593596 592570 542993 568463 515416 534823 632694 435745 519825 586499 558762 454523 519169 543193 568505 612074 639257 788994 792557 526161 501477 510296 519845 556938 569002 569092 592675 590312 489955 433730 572537 558012 522917 816007 788132 521761 792555 477881 470280 454883 510456 513722 494231 442697 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.08%) |
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 421015 430404 430433 430446 433730 434044 434097 435745 442697 446729 450767 450804 454523 454883 454916 460751 465198 466241 468017 470280 474114 474463 477881 478931 485066 486125 489328 489373 489955 493156 494231 498045 501477 502304 510217 510296 510456 513722 514575 515416 517282 518497 519169 519653 519825 519845 521761 522917 524573 526161 527416 531066 533186 534823 535488 541831 541833 542993 543193 545802 546116 556525 556938 558012 558762 563220 568463 568505 569002 569031 569092 569228 570845 571217 572537 575302 578496 580388 586499 587418 590312 592570 592675 593294 593596 595011 603258 604109 606608 607355 612074 612843 614308 619466 630916 632694 633150 639060 639257 642714 644718 647995 649836 651601 667232 699554 740690 785909 788132 788994 790696 792550 792553 792555 792557 797464 806060 811220 813249 816007 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom blowjob compilation"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom минет оральн секс подборк"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom минет оральн секс подборк"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.63%) |
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.