Query Metrics
7
Database Queries
7
Different statements
162.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.44 ms (85.15%) |
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 391833 411377 415309 420009 420021 423926 426769 438005 447997 456288 456857 459278 460850 461818 462299 465434 466551 466768 469104 469126 469146 470015 471674 472086 473117 478008 479283 482490 482892 483879 484012 484250 487872 491888 492747 494667 494681 499184 500886 502696 503495 507769 508740 513202 513587 519442 523593 534022 541517 541852 543636 543705 543945 545750 547839 552379 552805 558708 564932 565853 566918 567078 567100 573291 590495 597174 598191 613309 617237 619061 620240 627141 634276 650037 669936 671167 680797 695391 695417 695571 705786 709489 713493 715087 724692 725467 725472 726802 730719 731122 733780 739935 744899 746102 746125 746188 749797 751581 754047 757309 760281 769348 777214 777819 778656 779577 780654 782064 786493 788137 790274 795921 795964 795974 795987 806955 818697 820139 825825 827669 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (9.54%) |
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 470015 487872 423926 552805 598191 754047 507769 695417 782064 746188 627141 573291 552379 415309 465434 482490 420009 459278 466551 469146 508740 460850 494667 619061 724692 473117 757309 491888 543945 438005 680797 565853 566918 777819 426769 469126 519442 492747 543705 597174 541517 567078 502696 499184 669936 634276 788137 790274 613309 478008 523593 620240 820139 482892 503495 479283 461818 484012 462299 547839 564932 500886 456857 456288 472086 749797 751581 391833 466768 806955 733780 447997 513202 471674 411377 650037 484250 818697 825825 827669 483879 534022 494681 558708 567100 541852 545750 543636 705786 715087 671167 695391 695571 709489 713493 795987 778656 725472 730719 795964 769348 739935 744899 726802 760281 731122 746102 617237 777214 780654 786493 795921 795974 513587 590495 746125 725467 420021 469104 779577 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.50%) |
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 391833 411377 415309 420009 420021 423926 426769 438005 447997 456288 456857 459278 460850 461818 462299 465434 466551 466768 469104 469126 469146 470015 471674 472086 473117 478008 479283 482490 482892 483879 484012 484250 487872 491888 492747 494667 494681 499184 500886 502696 503495 507769 508740 513202 513587 519442 523593 534022 541517 541852 543636 543705 543945 545750 547839 552379 552805 558708 564932 565853 566918 567078 567100 573291 590495 597174 598191 613309 617237 619061 620240 627141 634276 650037 669936 671167 680797 695391 695417 695571 705786 709489 713493 715087 724692 725467 725472 726802 730719 731122 733780 739935 744899 746102 746125 746188 749797 751581 754047 757309 760281 769348 777214 777819 778656 779577 780654 782064 786493 788137 790274 795921 795964 795974 795987 806955 818697 820139 825825 827669 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife public"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.88%) |
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.