Query Metrics
7
Database Queries
7
Different statements
227.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.20 ms (86.70%) |
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 107104 145502 392785 397269 397639 398242 403294 403363 404693 404778 406592 407187 408207 408213 409168 410745 411608 412081 413524 413584 414160 414198 415388 418068 418925 430476 430484 432052 435502 440620 443646 443653 447614 449871 450645 450846 466716 473020 476908 484954 486301 489120 492268 494447 505810 507928 515135 517240 518766 520801 523159 523914 526188 526267 530494 531776 532039 532339 534280 538996 539424 543810 550093 556582 562886 567863 572004 580647 580765 584540 586472 591599 612335 620070 620282 622919 673981 677963 680740 684335 688332 689634 700707 709260 710722 713853 714011 716277 726498 726515 726698 727016 731014 737147 740129 740824 742970 750852 759906 795836 796236 796423 798051 799988 807548 807742 807823 808065 808538 810902 813920 814323 814746 815263 816011 816561 817893 824345 824347 824466 ] |
||||||||||||||||||||||||||||||
|
18.69 ms (8.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 408213 397639 430484 450645 397269 404778 505810 612335 476908 412081 418068 817893 107104 409168 408207 407187 816011 824345 450846 532339 538996 556582 684335 673981 680740 716277 710722 713853 714011 622919 795836 796236 807548 808065 798051 799988 807823 808538 726698 796423 731014 737147 740129 740824 726515 727016 759906 750852 726498 742970 700707 807742 392785 432052 404693 414160 414198 440620 814746 484954 447614 523159 507928 526267 534280 526188 530494 539424 492268 543810 550093 572004 584540 567863 677963 689634 688332 562886 591599 620070 586472 620282 415388 489120 515135 709260 406592 403363 411608 430476 418925 443653 531776 473020 580765 580647 810902 145502 413524 435502 449871 466716 413584 403294 443646 517240 520801 486301 518766 532039 398242 410745 813920 824347 824466 814323 815263 816561 494447 523914 ] |
||||||||||||||||||||||||||||||
|
4.40 ms (1.94%) |
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 107104 145502 392785 397269 397639 398242 403294 403363 404693 404778 406592 407187 408207 408213 409168 410745 411608 412081 413524 413584 414160 414198 415388 418068 418925 430476 430484 432052 435502 440620 443646 443653 447614 449871 450645 450846 466716 473020 476908 484954 486301 489120 492268 494447 505810 507928 515135 517240 518766 520801 523159 523914 526188 526267 530494 531776 532039 532339 534280 538996 539424 543810 550093 556582 562886 567863 572004 580647 580765 584540 586472 591599 612335 620070 620282 622919 673981 677963 680740 684335 688332 689634 700707 709260 710722 713853 714011 716277 726498 726515 726698 727016 731014 737147 740129 740824 742970 750852 759906 795836 796236 796423 798051 799988 807548 807742 807823 808065 808538 810902 813920 814323 814746 815263 816011 816561 817893 824345 824347 824466 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young латинская"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young латинская"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young latina"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.