Query Metrics
7
Database Queries
7
Different statements
156.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.48 ms (81.42%) |
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 389440 389500 396975 412663 419590 425509 428640 440631 443299 454933 456531 458764 459360 463034 464732 464953 465234 466369 474152 476634 476995 478596 486182 486438 486835 487350 491169 493102 495739 499628 505584 507771 510092 510194 510972 513669 515523 516721 519455 519962 520800 520815 520961 521173 521792 521931 521971 522050 525088 525921 526188 527602 528502 529100 529143 531106 533073 533802 536218 537207 537686 538283 540914 545832 548304 549706 552588 558543 559757 561674 561828 562001 562059 562374 565170 565254 567162 572077 573486 577369 577720 578139 578804 582790 584752 587056 587152 587293 587326 589344 590620 591214 592734 593656 597233 598494 600114 600123 602742 603992 605298 608106 608939 610317 614055 615979 619396 620266 621683 623681 624484 634495 640837 653249 654753 678764 681570 683438 790397 801610 ] |
||||||||||||||||||||||||||||||
|
18.51 ms (11.82%) |
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 549706 559757 561674 567162 577369 587293 600123 608939 623681 591214 592734 600114 602742 621683 640837 597233 624484 590620 619396 790397 603992 620266 801610 389440 412663 440631 476995 540914 487350 525088 521792 614055 634495 396975 419590 425509 527602 456531 474152 459360 478596 499628 510972 516721 519455 520800 526188 510092 515523 519962 521173 528502 536218 486182 545832 578139 681570 683438 678764 565170 584752 587152 615979 587326 593656 476634 454933 463034 464732 466369 491169 507771 521971 529100 520815 520961 577720 653249 608106 389500 458764 486438 505584 513669 529143 495739 510194 533802 531106 533073 538283 562059 573486 562374 565254 548304 582790 558543 578804 610317 428640 522050 465234 486835 537207 537686 464953 493102 552588 572077 587056 589344 598494 605298 521931 443299 525921 562001 561828 654753 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.67%) |
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 389440 389500 396975 412663 419590 425509 428640 440631 443299 454933 456531 458764 459360 463034 464732 464953 465234 466369 474152 476634 476995 478596 486182 486438 486835 487350 491169 493102 495739 499628 505584 507771 510092 510194 510972 513669 515523 516721 519455 519962 520800 520815 520961 521173 521792 521931 521971 522050 525088 525921 526188 527602 528502 529100 529143 531106 533073 533802 536218 537207 537686 538283 540914 545832 548304 549706 552588 558543 559757 561674 561828 562001 562059 562374 565170 565254 567162 572077 573486 577369 577720 578139 578804 582790 584752 587056 587152 587293 587326 589344 590620 591214 592734 593656 597233 598494 600114 600123 602742 603992 605298 608106 608939 610317 614055 615979 619396 620266 621683 623681 624484 634495 640837 653249 654753 678764 681570 683438 790397 801610 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding hard"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз hard"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"наездниц поз hard"
]
|
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.