Query Metrics
7
Database Queries
7
Different statements
175.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.54 ms (83.94%) |
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 6941 90718 106162 190925 201859 203528 322014 378401 382726 385589 411341 422684 424494 439465 444629 444732 447908 449102 449105 449114 449126 456051 458855 458892 459592 459603 459711 473206 474141 474854 475040 476045 479948 480376 480474 480476 480479 480481 482145 487779 488697 489902 489906 490187 498051 500311 502299 504328 504405 507360 507370 507532 510533 511930 512438 514818 515268 515272 515275 515285 515294 516831 518321 519620 520925 523088 523635 529465 533969 533991 548556 548558 548581 551026 551031 554217 555750 555793 559037 560407 560424 560947 565186 570152 571375 577178 580365 581136 585023 585747 586484 586506 590556 593338 593518 593543 607137 620126 629278 636471 653287 659361 663887 664688 681088 682073 682588 685589 688645 696969 709900 721006 755952 761788 788325 789529 815816 815826 816520 817669 ] |
||||||||||||||||||||||||||||||
|
17.83 ms (10.14%) |
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 682073 636471 586506 590556 593518 788325 755952 761788 709900 378401 449102 459592 502299 520925 489902 488697 565186 385589 322014 422684 815826 816520 815816 817669 458892 479948 447908 476045 480479 480481 482145 449126 474854 507532 498051 512438 533991 500311 480376 548556 551031 554217 577178 580365 555750 571375 653287 659361 663887 681088 664688 685589 696969 682588 688645 551026 555793 559037 560407 560424 560947 607137 585747 593338 620126 593543 629278 789529 721006 458855 90718 106162 382726 449105 6941 190925 411341 424494 449114 473206 459603 518321 504328 504405 487779 511930 515272 515285 515294 519620 507370 516831 523635 529465 586484 201859 203528 439465 444629 444732 585023 474141 480474 459711 480476 490187 456051 533969 510533 514818 523088 507360 515268 515275 475040 489906 548581 570152 581136 548558 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.59%) |
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 6941 90718 106162 190925 201859 203528 322014 378401 382726 385589 411341 422684 424494 439465 444629 444732 447908 449102 449105 449114 449126 456051 458855 458892 459592 459603 459711 473206 474141 474854 475040 476045 479948 480376 480474 480476 480479 480481 482145 487779 488697 489902 489906 490187 498051 500311 502299 504328 504405 507360 507370 507532 510533 511930 512438 514818 515268 515272 515275 515285 515294 516831 518321 519620 520925 523088 523635 529465 533969 533991 548556 548558 548581 551026 551031 554217 555750 555793 559037 560407 560424 560947 565186 570152 571375 577178 580365 581136 585023 585747 586484 586506 590556 593338 593518 593543 607137 620126 629278 636471 653287 659361 663887 664688 681088 682073 682588 685589 688645 696969 709900 721006 755952 761788 788325 789529 815816 815826 816520 817669 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доктор xxx"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doctor xxx"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доктор xxx"
]
|
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.