Query Metrics
7
Database Queries
7
Different statements
148.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.09 ms (82.08%) |
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 382518 398740 404346 406377 411926 413458 413870 415205 417258 417704 417722 417724 417738 418149 418441 419431 419535 419554 419565 419566 419567 419572 419917 420311 420549 422649 422987 423398 423461 423791 423797 423843 423987 424248 424486 424798 426658 426810 426812 438889 440956 442631 443599 452584 454108 459342 459383 459409 463108 463839 463969 466755 467062 467707 469967 470660 472025 474085 474103 474802 475825 476307 477399 477414 477949 479688 479858 480099 484120 484956 485482 485737 485744 485825 486266 486494 487927 488459 490592 492396 494123 494684 494687 494981 494990 496237 498512 499900 499914 502110 509403 510610 515142 516137 519386 519972 521568 522948 523377 524745 525513 526018 526576 527253 528884 528891 529205 543821 544476 546259 566310 571789 578146 592793 600488 615709 628681 663381 693078 794832 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (11.35%) |
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 484956 382518 417704 422987 413458 418441 419566 419565 474103 459409 476307 488459 510610 529205 494687 499900 516137 519386 528891 546259 544476 663381 592793 615709 600488 423797 424486 474085 419431 467707 423791 470660 420549 423398 467062 521568 498512 496237 398740 438889 442631 418149 419572 419567 463969 469967 485744 463108 479688 487927 486266 494981 519972 524745 566310 423843 419554 472025 477399 423987 474802 426812 454108 417722 417724 459342 475825 523377 502110 484120 526018 485482 404346 443599 477949 480099 485737 479858 494684 494990 526576 477414 571789 578146 452584 463839 420311 490592 522948 543821 413870 515142 693078 528884 794832 509403 628681 415205 424248 494123 426658 525513 499914 406377 417258 419917 486494 485825 492396 527253 417738 426810 440956 459383 466755 419535 411926 422649 423461 424798 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.00%) |
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 382518 398740 404346 406377 411926 413458 413870 415205 417258 417704 417722 417724 417738 418149 418441 419431 419535 419554 419565 419566 419567 419572 419917 420311 420549 422649 422987 423398 423461 423791 423797 423843 423987 424248 424486 424798 426658 426810 426812 438889 440956 442631 443599 452584 454108 459342 459383 459409 463108 463839 463969 466755 467062 467707 469967 470660 472025 474085 474103 474802 475825 476307 477399 477414 477949 479688 479858 480099 484120 484956 485482 485737 485744 485825 486266 486494 487927 488459 490592 492396 494123 494684 494687 494981 494990 496237 498512 499900 499914 502110 509403 510610 515142 516137 519386 519972 521568 522948 523377 524745 525513 526018 526576 527253 528884 528891 529205 543821 544476 546259 566310 571789 578146 592793 600488 615709 628681 663381 693078 794832 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ugly sex"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ugly секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ugly секс"
]
|
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.