Query Metrics
7
Database Queries
7
Different statements
144.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.69 ms (82.63%) |
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 21575 395933 397396 405243 417062 424067 426840 433420 433925 436001 437730 438421 443701 443897 458153 458547 460484 461532 461584 461949 461987 462132 465120 465361 465375 465815 467862 469901 470170 471914 472115 477094 478205 478208 478330 478387 478399 478766 479417 481318 481597 483829 484007 484098 484852 485534 485851 487225 491391 492230 503175 503470 503713 504299 508022 508107 508230 509658 510521 510894 511075 511096 511104 512678 515668 516440 517102 520379 522810 522811 522816 523708 545490 546076 546938 547577 547614 548764 552086 560626 562395 563439 564409 564932 565602 567710 567890 570257 570628 570672 571497 572048 572361 572988 573090 573100 573119 573341 573371 573568 573699 573816 573891 574006 574558 574611 574784 575263 577728 578910 579446 601401 601402 616238 650627 697009 793497 798967 802291 807469 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (10.37%) |
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 563439 564932 567710 567890 570257 570628 570672 572048 572361 573090 573119 573568 573699 574784 575263 579446 697009 650627 545490 546076 546938 547577 547614 548764 552086 560626 562395 564409 565602 571497 572988 573100 573341 573371 573816 573891 574006 574558 574611 577728 578910 601401 601402 616238 793497 802291 798967 807469 395933 424067 438421 443701 465815 478387 478399 481318 481597 397396 433925 437730 460484 461532 461987 465120 467862 477094 21575 405243 426840 443897 458153 462132 469901 470170 478205 478330 478766 417062 458547 461949 465361 465375 471914 472115 479417 433420 436001 461584 478208 503470 503713 508022 508230 510521 511104 517102 520379 522810 522811 522816 523708 483829 484007 484098 484852 485534 485851 487225 491391 492230 503175 504299 508107 509658 510894 511075 511096 512678 515668 516440 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.41%) |
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 21575 395933 397396 405243 417062 424067 426840 433420 433925 436001 437730 438421 443701 443897 458153 458547 460484 461532 461584 461949 461987 462132 465120 465361 465375 465815 467862 469901 470170 471914 472115 477094 478205 478208 478330 478387 478399 478766 479417 481318 481597 483829 484007 484098 484852 485534 485851 487225 491391 492230 503175 503470 503713 504299 508022 508107 508230 509658 510521 510894 511075 511096 511104 512678 515668 516440 517102 520379 522810 522811 522816 523708 545490 546076 546938 547577 547614 548764 552086 560626 562395 563439 564409 564932 565602 567710 567890 570257 570628 570672 571497 572048 572361 572988 573090 573100 573119 573341 573371 573568 573699 573816 573891 574006 574558 574611 574784 575263 577728 578910 579446 601401 601402 616238 650627 697009 793497 798967 802291 807469 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск презерват"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русское презик"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (1.00%) |
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.