Query Metrics
7
Database Queries
7
Different statements
164.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.30 ms (86.43%) |
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 358603 383105 384977 386403 390537 396482 399659 401615 414317 415734 421856 424850 430351 431234 433826 437316 438004 438049 445530 452216 454140 454540 455362 461902 464419 465324 466178 469004 470647 473800 477532 488337 488476 490539 492537 495446 506353 513839 519649 522881 523147 539370 540541 542793 543896 550720 555443 563204 571217 571961 574957 575553 584981 591861 596763 597663 604519 615057 633435 639398 639879 653061 662522 664192 669894 677707 691179 697760 698457 701476 718437 721571 726479 726494 726681 727513 733264 736354 742674 742891 742970 748197 748451 752965 755121 762882 765884 765913 773709 783205 783494 787248 791182 794135 794559 794567 794581 795536 796014 796635 800191 800835 800968 801235 801521 802011 803927 804474 804612 806032 809533 810618 819152 819412 819836 823750 824913 825249 826112 826495 ] |
||||||||||||||||||||||||||||||
|
12.44 ms (7.55%) |
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 726479 765884 726681 415734 465324 490539 522881 809533 358603 727513 574957 464419 571961 597663 791182 794567 748197 615057 804612 384977 488476 701476 438004 431234 495446 633435 445530 421856 819412 826495 823750 825249 826112 824913 819152 819836 543896 653061 662522 718437 669894 639398 800968 783494 794559 801521 803927 773709 794581 810618 742674 762882 733264 755121 748451 765913 787248 796635 800835 396482 461902 454540 470647 571217 677707 698457 604519 800191 801235 783205 454140 466178 430351 539370 506353 563204 721571 742970 424850 383105 437316 488337 469004 542793 752965 455362 390537 438049 523147 492537 519649 401615 584981 550720 555443 697760 575553 802011 795536 806032 433826 386403 513839 399659 414317 477532 452216 473800 540541 691179 664192 591861 596763 639879 796014 804474 794135 736354 742891 726494 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.76%) |
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 358603 383105 384977 386403 390537 396482 399659 401615 414317 415734 421856 424850 430351 431234 433826 437316 438004 438049 445530 452216 454140 454540 455362 461902 464419 465324 466178 469004 470647 473800 477532 488337 488476 490539 492537 495446 506353 513839 519649 522881 523147 539370 540541 542793 543896 550720 555443 563204 571217 571961 574957 575553 584981 591861 596763 597663 604519 615057 633435 639398 639879 653061 662522 664192 669894 677707 691179 697760 698457 701476 718437 721571 726479 726494 726681 727513 733264 736354 742674 742891 742970 748197 748451 752965 755121 762882 765884 765913 773709 783205 783494 787248 791182 794135 794559 794567 794581 795536 796014 796635 800191 800835 800968 801235 801521 802011 803927 804474 804612 806032 809533 810618 819152 819412 819836 823750 824913 825249 826112 826495 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother love"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин love"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин love"
]
|
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.