Query Metrics
7
Database Queries
7
Different statements
184.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.41 ms (85.82%) |
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 391915 391921 411374 419998 420015 421600 423773 424042 424202 426767 427144 435518 435581 435698 435883 438455 438459 438646 439257 439285 440217 447597 450520 451317 455119 459622 462118 462143 466763 469106 469117 469119 470023 470105 470195 474214 477646 481226 483854 484962 485596 486618 495498 495499 497893 500304 500825 501476 502201 510828 513530 513658 516572 519352 523606 523623 523687 523710 524402 525515 525967 526555 526747 529924 535396 535603 541771 543680 545149 547770 549563 564022 566564 576447 580819 581569 652971 663715 669305 669851 669870 669941 671189 672791 672816 675596 679266 680806 680809 681355 684749 688252 689830 690663 690726 691388 695552 697997 698144 700059 704700 707578 711777 713323 813963 816169 816170 816836 819950 823552 823738 824530 825329 825397 825430 827284 827633 827652 827654 827656 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (8.03%) |
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 435518 435698 438459 438646 447597 459622 462143 469106 469117 470195 440217 470105 411374 419998 421600 424042 435883 439257 439285 450520 455119 469119 470023 474214 391921 420015 451317 481226 427144 438455 477646 513530 523687 524402 525515 526747 483854 485596 486618 495498 513658 525967 526555 501476 502201 510828 523606 523623 484962 495499 497893 523710 675596 704700 423773 391915 435581 424202 426767 813963 816169 823552 819950 823738 825329 827284 816170 816836 824530 825430 827656 827654 827652 827633 825397 519352 529924 500825 516572 535396 500304 535603 462118 466763 541771 576447 545149 547770 549563 543680 564022 566564 580819 581569 671189 672791 684749 690663 691388 697997 707578 713323 663715 669305 669851 669941 672816 679266 680806 680809 689830 690726 695552 698144 700059 711777 652971 669870 681355 688252 ] |
||||||||||||||||||||||||||||||
|
4.18 ms (2.26%) |
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 391915 391921 411374 419998 420015 421600 423773 424042 424202 426767 427144 435518 435581 435698 435883 438455 438459 438646 439257 439285 440217 447597 450520 451317 455119 459622 462118 462143 466763 469106 469117 469119 470023 470105 470195 474214 477646 481226 483854 484962 485596 486618 495498 495499 497893 500304 500825 501476 502201 510828 513530 513658 516572 519352 523606 523623 523687 523710 524402 525515 525967 526555 526747 529924 535396 535603 541771 543680 545149 547770 549563 564022 566564 576447 580819 581569 652971 663715 669305 669851 669870 669941 671189 672791 672816 675596 679266 680806 680809 681355 684749 688252 689830 690663 690726 691388 695552 697997 698144 700059 704700 707578 711777 713323 813963 816169 816170 816836 819950 823552 823738 824530 825329 825397 825430 827284 827633 827652 827654 827656 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife solo"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен соло"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
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.