Query Metrics
7
Database Queries
7
Different statements
409.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.73 ms (51.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик мам женщин"
]
|
||||||||||||||||||||||||||||||
|
173.61 ms (42.41%) |
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 309604 382511 386479 388950 389964 394309 403501 413737 420044 423765 425251 427162 432190 435572 444474 448598 450840 459435 461942 463779 464490 466031 468509 470030 470033 470621 476042 478626 480469 480557 482339 488900 493154 496536 513641 515886 526656 531916 532043 532130 532818 537548 537717 537852 538952 539458 546409 547506 550331 555046 556341 560699 561587 562574 567889 570800 570869 579910 583822 586583 593042 595438 598429 599995 602293 605080 612059 612110 615395 615949 623983 660831 668082 668948 669219 676248 680778 709398 709746 710222 714496 715073 718746 724190 725465 726632 730555 733221 735847 735870 736692 741761 742539 742578 742770 744810 745865 746871 748411 751490 753123 755123 760158 761387 765546 776473 777329 784147 790051 790380 790671 796056 801600 806720 812054 813434 814602 816184 817037 817130 ] |
||||||||||||||||||||||||||||||
|
13.46 ms (3.29%) |
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 801600 745865 746871 742578 744810 751490 755123 761387 725465 796056 309604 493154 556341 513641 382511 388950 403501 444474 816184 466031 470621 488900 532043 537852 531916 546409 660831 668948 715073 710222 598429 595438 615395 593042 813434 733221 760158 741761 724190 726632 735847 742770 735870 742539 765546 753123 709746 776473 468509 480469 459435 515886 526656 777329 748411 450840 668082 623983 817037 550331 612059 790051 814602 386479 389964 413737 423765 427162 463779 478626 680778 806720 394309 435572 425251 476042 605080 817130 537548 537717 579910 570800 583822 676248 709398 562574 615949 784147 612110 790380 420044 532818 547506 561587 669219 714496 718746 599995 812054 464490 470030 480557 470033 496536 790671 730555 448598 538952 567889 570869 560699 482339 555046 586583 539458 461942 532130 602293 736692 432190 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (0.90%) |
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 309604 382511 386479 388950 389964 394309 403501 413737 420044 423765 425251 427162 432190 435572 444474 448598 450840 459435 461942 463779 464490 466031 468509 470030 470033 470621 476042 478626 480469 480557 482339 488900 493154 496536 513641 515886 526656 531916 532043 532130 532818 537548 537717 537852 538952 539458 546409 547506 550331 555046 556341 560699 561587 562574 567889 570800 570869 579910 583822 586583 593042 595438 598429 599995 602293 605080 612059 612110 615395 615949 623983 660831 668082 668948 669219 676248 680778 709398 709746 710222 714496 715073 718746 724190 725465 726632 730555 733221 735847 735870 736692 741761 742539 742578 742770 744810 745865 746871 748411 751490 753123 755123 760158 761387 765546 776473 777329 784147 790051 790380 790671 796056 801600 806720 812054 813434 814602 816184 817037 817130 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"эро мама"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.45%) |
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.