Query Metrics
7
Database Queries
7
Different statements
147.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.72 ms (84.61%) |
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 193890 233292 239555 384234 385591 387422 395891 396317 397918 398027 398544 403356 406650 407346 409313 409804 411777 413463 421155 422278 422298 427452 428512 428895 429550 431422 439589 440631 443163 443428 443727 448674 450847 453307 454053 458795 460709 462711 463177 464360 465331 465373 465821 465838 467545 471435 471945 477723 477794 481328 481332 484432 484600 488556 491416 491988 500463 502305 502495 505818 508619 511543 513408 518853 519016 519092 520387 535365 538329 542789 543332 546622 546771 547930 551572 560390 560396 561598 563208 563222 573755 578606 589139 602947 606807 606892 607426 612922 623350 629792 633412 640152 670282 675405 677097 688100 698235 705549 718499 719350 725401 725579 742022 757866 772318 781718 788196 792529 795539 796012 801323 801868 805399 807624 807944 810902 814857 817917 825102 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (9.15%) |
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 427452 561598 407346 413463 718499 725401 698235 398544 193890 396317 725579 538329 801868 387422 233292 460709 543332 560390 563222 481328 535365 688100 807624 757866 742022 612922 409804 385591 796012 428895 801323 409313 825102 633412 397918 411777 546622 792529 403356 443428 465821 467545 406650 465331 384234 443727 422298 623350 795539 805399 428512 450847 560396 422278 458795 602947 772318 477794 395891 471435 546771 547930 719350 398027 429550 484600 421155 817917 563208 705549 670282 578606 589139 607426 629792 606892 807944 491416 520387 502305 439589 465373 440631 471945 462711 491988 519016 453307 484432 518853 477723 814857 454053 464360 465838 502495 511543 542789 551572 675405 640152 606807 788196 781718 448674 488556 519092 431422 239555 481332 500463 513408 573755 677097 810902 463177 513476 505818 508619 443163 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.98%) |
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 193890 233292 239555 384234 385591 387422 395891 396317 397918 398027 398544 403356 406650 407346 409313 409804 411777 413463 421155 422278 422298 427452 428512 428895 429550 431422 439589 440631 443163 443428 443727 448674 450847 453307 454053 458795 460709 462711 463177 464360 465331 465373 465821 465838 467545 471435 471945 477723 477794 481328 481332 484432 484600 488556 491416 491988 500463 502305 502495 505818 508619 511543 513408 518853 519016 519092 520387 535365 538329 542789 543332 546622 546771 547930 551572 560390 560396 561598 563208 563222 573755 578606 589139 602947 606807 606892 607426 612922 623350 629792 633412 640152 670282 675405 677097 688100 698235 705549 718499 719350 725401 725579 742022 757866 772318 781718 788196 792529 795539 796012 801323 801868 805399 807624 807944 810902 814857 817917 825102 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom boy friend"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom парен friend"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom парен friend"
]
|
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.