Query Metrics
7
Database Queries
7
Different statements
173.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.49 ms (84.56%) |
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 413468 419616 425994 443118 443415 455361 455391 458591 461313 462064 467300 473195 473868 474768 477565 481997 482418 483766 483781 487679 499045 504110 505296 507835 508777 509417 511258 512899 516079 518897 520206 526613 528566 538483 542289 545763 550491 553749 556299 557831 558722 565493 565880 567336 568583 572303 573349 576001 578521 582744 588142 602179 605635 609099 610275 610859 618378 618752 619259 625240 626771 630725 633447 635195 635202 635207 635351 635751 635786 636715 645048 648475 650911 664476 680030 691407 692818 693884 700010 703792 707524 709505 710597 714608 714795 716324 720655 723486 727560 727571 733337 739985 742015 744053 744982 746267 746890 750909 753025 754487 754731 757994 759917 763174 767052 772117 773427 773974 782554 784102 788590 789528 790064 793434 793871 795125 800573 805225 809004 813581 ] |
||||||||||||||||||||||||||||||
|
17.41 ms (10.05%) |
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 773427 744053 714795 419616 482418 576001 692818 700010 710597 625240 635751 720655 458591 455361 483781 553749 565493 556299 703792 610275 788590 782554 809004 746267 750909 754487 744982 507835 742015 618378 516079 467300 709505 573349 753025 757994 813581 680030 754731 443415 473868 512899 648475 650911 664476 567336 609099 746890 790064 795125 636715 727571 767052 635351 425994 461313 483766 578521 582744 568583 691407 723486 635202 602179 784102 793871 635786 800573 645048 805225 528566 763174 477565 511258 635195 626771 789528 545763 526613 550491 693884 714608 605635 772117 462064 487679 565880 557831 558722 619259 759917 630725 481997 455391 518897 538483 504110 520206 707524 588142 635207 733337 610859 618752 716324 443118 473195 572303 633447 739985 499045 509417 542289 727560 773974 793434 508777 505296 413468 474768 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.54%) |
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 413468 419616 425994 443118 443415 455361 455391 458591 461313 462064 467300 473195 473868 474768 477565 481997 482418 483766 483781 487679 499045 504110 505296 507835 508777 509417 511258 512899 516079 518897 520206 526613 528566 538483 542289 545763 550491 553749 556299 557831 558722 565493 565880 567336 568583 572303 573349 576001 578521 582744 588142 602179 605635 609099 610275 610859 618378 618752 619259 625240 626771 630725 633447 635195 635202 635207 635351 635751 635786 636715 645048 648475 650911 664476 680030 691407 692818 693884 700010 703792 707524 709505 710597 714608 714795 716324 720655 723486 727560 727571 733337 739985 742015 744053 744982 746267 746890 750909 753025 754487 754731 757994 759917 763174 767052 772117 773427 773974 782554 784102 788590 789528 790064 793434 793871 795125 800573 805225 809004 813581 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pregnant fuck"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беремен секс"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.75%) |
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.