Query Metrics
7
Database Queries
7
Different statements
438.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.15 ms (47.87%) |
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 418268 424103 427575 437707 443893 446233 449514 452335 455698 457505 463295 470492 481390 489033 496217 496479 508210 513921 522522 524433 524959 526887 529419 529503 532369 533777 536107 540181 540419 541093 548418 549070 549087 556075 557828 558777 559318 570104 575349 576167 577725 579615 580119 583662 585192 585364 585543 587523 587747 587962 589317 589460 589814 592261 592269 593745 594615 600930 602448 602525 603114 603594 605681 612963 613998 615995 629116 632128 642259 642950 645519 647122 649068 649207 655208 656208 664409 666724 668972 670064 670251 675453 677379 684404 684430 691291 696563 697657 699181 700055 708078 716985 717877 734923 761601 761677 764303 770591 775681 776902 778882 779384 779721 780568 783464 783996 784250 784849 788359 797087 804808 805456 806175 808283 809638 813669 815094 816682 827850 ] |
||||||||||||||||||||||||||||||
|
205.34 ms (46.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
13.65 ms (3.11%) |
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 664409 670064 696563 691291 708078 602525 587523 589814 603114 784849 806175 632128 700055 775681 470492 437707 449514 455698 489033 815094 783996 629116 418268 615995 536107 496479 557828 666724 813669 816682 827850 452335 524433 532369 533777 526887 540181 541093 549070 549087 558777 647122 655208 677379 699181 649207 668972 684430 697657 717877 649068 656208 684404 556075 575349 580119 585364 587747 587962 592261 605681 642259 593745 594615 600930 585192 586568 585543 779384 779721 780568 784250 804808 761601 761677 783464 805456 734923 764303 770591 613998 642950 716985 776902 778882 788359 797087 808283 809638 446233 559318 576167 463295 481390 508210 670251 645519 675453 548418 589460 602448 612963 603594 427575 424103 443893 540419 457505 522522 529419 529503 496217 524959 513921 570104 577725 579615 583662 589317 592269 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (0.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 418268 424103 427575 437707 443893 446233 449514 452335 455698 457505 463295 470492 481390 489033 496217 496479 508210 513921 522522 524433 524959 526887 529419 529503 532369 533777 536107 540181 540419 541093 548418 549070 549087 556075 557828 558777 559318 570104 575349 576167 577725 579615 580119 583662 585192 585364 585543 587523 587747 587962 589317 589460 589814 592261 592269 593745 594615 600930 602448 602525 603114 603594 605681 612963 613998 615995 629116 632128 642259 642950 645519 647122 649068 649207 655208 656208 664409 666724 668972 670064 670251 675453 677379 684404 684430 691291 696563 697657 699181 700055 708078 716985 717877 734923 761601 761677 764303 770591 775681 776902 778882 779384 779721 780568 783464 783996 784250 784849 788359 797087 804808 805456 806175 808283 809638 813669 815094 816682 827850 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов вагин"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov vagina"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.37%) |
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.