Query Metrics
7
Database Queries
7
Different statements
188.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.13 ms (86.06%) |
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 80505 156487 382202 389174 399886 405820 411339 419057 426218 437178 455715 456357 456363 457878 468552 476539 476636 494920 496399 502372 514755 530125 530234 530453 534944 535082 535189 537155 539983 543274 544252 544642 545210 559237 559385 562595 566419 575625 581581 584688 648907 650978 651268 653069 653823 659479 663270 665983 674938 677553 679564 682291 687121 687832 689038 689445 691710 695551 696173 696198 696365 697217 697586 697597 700902 702277 702382 703587 705398 705467 707229 709878 710398 711613 712226 712648 714919 719901 720311 721950 775390 776504 776530 778800 779048 780601 780662 781444 781666 785970 787089 792783 794724 796834 801126 802027 804425 807844 807972 808509 809362 810608 813698 814967 815481 817825 817849 817981 818395 818833 819146 819335 819948 820878 824541 825201 825255 825715 826087 827182 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (9.13%) |
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 775390 776504 776530 778800 779048 780601 780662 781444 781666 785970 787089 792783 794724 796834 801126 802027 804425 807844 807972 808509 809362 810608 399886 156487 405820 437178 456357 584688 80505 382202 389174 426218 411339 419057 815481 818833 820878 825715 826087 817849 818395 819948 825255 827182 824541 813698 814967 817825 817981 819146 819335 825201 468552 476636 456363 457878 455715 476539 530125 530453 535189 539983 494920 534944 537155 502372 514755 530234 496399 535082 544642 575625 543274 559237 566419 581581 544252 545210 559385 562595 648907 651268 659479 663270 665983 674938 677553 689445 691710 695551 696173 696198 696365 697597 702277 702382 711613 719901 721950 650978 653069 653823 679564 682291 687121 687832 689038 697217 697586 700902 703587 705398 705467 707229 709878 710398 712226 712648 714919 720311 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.29%) |
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 80505 156487 382202 389174 399886 405820 411339 419057 426218 437178 455715 456357 456363 457878 468552 476539 476636 494920 496399 502372 514755 530125 530234 530453 534944 535082 535189 537155 539983 543274 544252 544642 545210 559237 559385 562595 566419 575625 581581 584688 648907 650978 651268 653069 653823 659479 663270 665983 674938 677553 679564 682291 687121 687832 689038 689445 691710 695551 696173 696198 696365 697217 697586 697597 700902 702277 702382 703587 705398 705467 707229 709878 710398 711613 712226 712648 714919 719901 720311 721950 775390 776504 776530 778800 779048 780601 780662 781444 781666 785970 787089 792783 794724 796834 801126 802027 804425 807844 807972 808509 809362 810608 813698 814967 815481 817825 817849 817981 818395 818833 819146 819335 819948 820878 824541 825201 825255 825715 826087 827182 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband not"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband"
]
|
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.