Query Metrics
7
Database Queries
7
Different statements
164.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.47 ms (83.44%) |
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 188338 188369 358481 383418 387742 390303 390761 391944 396104 407570 408164 423836 424414 424491 425993 432696 433066 434342 434350 437999 447740 449713 450344 462799 464125 464248 466831 468708 472594 475277 477597 485457 487368 491837 493493 494438 495145 497703 497879 502043 513436 513571 515994 518308 518571 520979 526009 526077 528380 532812 534317 534990 535456 544524 544829 547860 550363 550366 552817 555992 557522 561416 578701 579345 582277 583713 589551 589673 590839 600317 601604 605548 606425 620126 622064 634774 645273 648820 657543 660419 666196 673138 678734 683139 702040 703051 704584 712940 713885 716409 716858 717862 718870 718890 720711 720726 721187 737870 744665 748475 755429 756383 756509 757350 760940 761590 765721 770183 777017 778091 786537 790389 794371 795163 801322 804498 813235 814431 814606 815057 ] |
||||||||||||||||||||||||||||||
|
16.92 ms (10.27%) |
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 518571 544829 547860 550366 583713 716409 718890 666196 657543 702040 589673 589551 620126 622064 606425 786537 790389 794371 778091 737870 761590 765721 756383 756509 760940 755429 757350 770183 744665 748475 777017 795163 801322 804498 813235 390761 449713 188338 188369 358481 390303 423836 424414 424491 434342 437999 487368 491837 497879 520979 634774 477597 493493 497703 518308 718870 645273 601604 590839 528380 648820 515994 579345 605548 535456 704584 532812 582277 502043 555992 600317 383418 391944 387742 396104 408164 432696 407570 425993 433066 434350 814606 814431 815057 450344 464248 466831 475277 447740 462799 468708 472594 513571 526009 526077 494438 534317 534990 495145 513436 464125 485457 544524 550363 578701 557522 561416 703051 717862 721187 660419 673138 678734 712940 713885 716858 720711 720726 683139 552817 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.79%) |
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 188338 188369 358481 383418 387742 390303 390761 391944 396104 407570 408164 423836 424414 424491 425993 432696 433066 434342 434350 437999 447740 449713 450344 462799 464125 464248 466831 468708 472594 475277 477597 485457 487368 491837 493493 494438 495145 497703 497879 502043 513436 513571 515994 518308 518571 520979 526009 526077 528380 532812 534317 534990 535456 544524 544829 547860 550363 550366 552817 555992 557522 561416 578701 579345 582277 583713 589551 589673 590839 600317 601604 605548 606425 620126 622064 634774 645273 648820 657543 660419 666196 673138 678734 683139 702040 703051 704584 712940 713885 716409 716858 717862 718870 718890 720711 720726 721187 737870 744665 748475 755429 756383 756509 757350 760940 761590 765721 770183 777017 778091 786537 790389 794371 795163 801322 804498 813235 814431 814606 815057 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy milf анал"
]
|
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.