Query Metrics
7
Database Queries
7
Different statements
350.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.83 ms (58.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамка с син"
]
|
||||||||||||||||||||||||||||||
|
114.49 ms (32.62%) |
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 404598 420262 428814 431376 440581 449721 453565 453721 462481 471494 487749 492134 494867 495096 503098 505796 505965 507944 511066 514924 516742 517059 517287 518751 519337 519392 519520 520683 520819 523154 523256 523767 525121 526630 526751 526761 527226 527281 527933 528584 528607 528716 528719 528931 530528 532164 534239 536726 536868 539742 541230 542861 545982 550433 552350 553314 556049 557611 562831 562905 563035 566082 566951 568125 570998 580149 580340 583052 584667 587681 588078 590425 591706 591739 592046 593294 593812 596973 599703 599938 600837 601806 607620 608376 612863 616800 617370 618793 620851 625440 640710 642006 642037 643370 648466 657775 667795 668804 673537 675081 681681 690783 719326 785388 809396 ] |
||||||||||||||||||||||||||||||
|
21.83 ms (6.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 552350 563035 541230 584667 690783 648466 681681 553314 601806 428814 527933 545982 556049 593294 588078 640710 511066 600837 591706 612863 462481 494867 505796 519520 526751 536868 525121 527226 516742 526630 528584 530528 487749 583052 562905 673537 667795 668804 514924 528607 617370 657775 518751 642006 642037 534239 453721 431376 404598 520683 539742 520819 607620 643370 785388 440581 495096 523767 580149 599938 453565 492134 527281 536726 526761 557611 542861 675081 566951 592046 593812 596973 449721 517059 503098 519337 517287 562831 599703 616800 505965 532164 590425 719326 809396 620851 566082 528931 528719 568125 523154 523256 570998 420262 550433 507944 528716 519392 587681 580340 618793 625440 591739 608376 471494 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (0.92%) |
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 404598 420262 428814 431376 440581 449721 453565 453721 462481 471494 487749 492134 494867 495096 503098 505796 505965 507944 511066 514924 516742 517059 517287 518751 519337 519392 519520 520683 520819 523154 523256 523767 525121 526630 526751 526761 527226 527281 527933 528584 528607 528716 528719 528931 530528 532164 534239 536726 536868 539742 541230 542861 545982 550433 552350 553314 556049 557611 562831 562905 563035 566082 566951 568125 570998 580149 580340 583052 584667 587681 588078 590425 591706 591739 592046 593294 593812 596973 599703 599938 600837 601806 607620 608376 612863 616800 617370 618793 620851 625440 640710 642006 642037 643370 648466 657775 667795 668804 673537 675081 681681 690783 719326 785388 809396 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин син"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.42%) |
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.