Query Metrics
7
Database Queries
7
Different statements
218.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.69 ms (86.07%) |
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 108925 419022 419292 421967 430261 439331 439828 443092 445078 446745 447352 450277 454674 454802 464887 465629 465680 468664 469691 471101 473767 474539 481144 482900 483583 486761 486767 489676 493418 506098 518087 518372 518611 519349 523503 523640 530482 531144 531261 532741 533828 535358 536285 536562 536621 536631 537911 537913 537988 540291 544827 544963 546762 546854 548873 550124 550284 554989 558214 565640 568864 569610 573283 577240 579173 579506 580176 582399 582641 583557 595488 595847 597482 600290 602174 604404 605379 606254 607355 607661 613245 621125 621235 631249 633521 634122 639742 640800 642064 650175 652223 663766 665226 666681 668620 676092 705800 708494 710357 736022 739089 754436 760862 784351 790154 790552 793022 793709 796372 801275 803832 807606 809631 810606 811048 811330 813579 816164 820066 ] |
||||||||||||||||||||||||||||||
|
20.16 ms (9.25%) |
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 813579 530482 537911 607355 816164 465629 577240 613245 793709 506098 108925 595847 471101 486767 486761 537988 483583 604404 621235 533828 790552 621125 595488 446745 445078 473767 450277 518372 544963 580176 565640 579173 582641 568864 569610 579506 582399 705800 666681 663766 668620 550284 554989 573283 602174 605379 606254 597482 796372 803832 807606 811048 790154 793022 736022 784351 809631 760862 739089 754436 710357 419292 465680 439331 454674 518087 523503 523640 537913 810606 464887 468664 443092 430261 652223 493418 536285 540291 639742 531144 536562 535358 536631 550124 544827 631249 642064 600290 640800 481144 546854 820066 708494 811330 474539 665226 801275 782835 439828 532741 536621 531261 650175 676092 634122 633521 454802 421967 469691 518611 519349 583557 546762 548873 558214 607661 419022 447352 482900 489676 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.11%) |
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 108925 419022 419292 421967 430261 439331 439828 443092 445078 446745 447352 450277 454674 454802 464887 465629 465680 468664 469691 471101 473767 474539 481144 482900 483583 486761 486767 489676 493418 506098 518087 518372 518611 519349 523503 523640 530482 531144 531261 532741 533828 535358 536285 536562 536621 536631 537911 537913 537988 540291 544827 544963 546762 546854 548873 550124 550284 554989 558214 565640 568864 569610 573283 577240 579173 579506 580176 582399 582641 583557 595488 595847 597482 600290 602174 604404 605379 606254 607355 607661 613245 621125 621235 631249 633521 634122 639742 640800 642064 650175 652223 663766 665226 666681 668620 676092 705800 708494 710357 736022 739089 754436 760862 784351 790154 790552 793022 793709 796372 801275 803832 807606 809631 810606 811048 811330 813579 816164 820066 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob long dildo"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс длинные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.76%) |
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.