Query Metrics
7
Database Queries
7
Different statements
207.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.72 ms (86.67%) |
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 384306 386460 396640 398201 401223 426438 428241 428738 429223 435374 436693 440698 444341 444435 447146 447435 447524 447539 449678 451706 455390 455653 455960 461122 463674 463913 465004 465326 465548 468006 469061 469553 470846 473974 475172 475483 476823 490079 492002 493218 494692 496454 499148 501732 501748 501752 501774 501776 501804 505977 507500 508747 510203 510610 512790 513768 514033 514673 518548 519486 519661 521193 524016 527057 527793 531647 537425 551147 552043 552134 552296 554253 555571 556397 556945 558958 563325 563854 563871 563878 565188 565279 566764 569933 581976 584257 586549 586597 592314 593649 596412 600381 602212 605644 605936 606912 608878 609436 615318 628910 641886 654459 654914 659412 659439 671334 671356 671626 671656 672671 676987 677020 677060 677387 681505 683588 685001 687174 688045 688340 ] |
||||||||||||||||||||||||||||||
|
17.34 ms (8.36%) |
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 606912 654459 501776 552134 436693 455390 510610 641886 563325 428738 609436 470846 671626 507500 386460 428241 396640 508747 451706 429223 398201 531647 426438 401223 671656 384306 447524 468006 490079 672671 455653 501804 527057 566764 615318 440698 687174 596412 476823 501752 537425 671334 465548 683588 455960 465004 555571 565188 671356 586549 501774 584257 565279 592314 602212 444341 449678 677387 510203 461122 493218 519661 605644 496454 514033 608878 659439 473974 505977 435374 681505 447539 527793 654914 676987 475172 563878 551147 518548 563871 501732 659412 628910 463674 552043 519486 447146 492002 524016 558958 688340 593649 501748 513768 556945 685001 499148 581976 447435 569933 514673 563854 444435 677020 600381 605936 465326 552296 469553 554253 494692 512790 521193 586597 475483 556397 677060 688045 463913 469061 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.52%) |
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 384306 386460 396640 398201 401223 426438 428241 428738 429223 435374 436693 440698 444341 444435 447146 447435 447524 447539 449678 451706 455390 455653 455960 461122 463674 463913 465004 465326 465548 468006 469061 469553 470846 473974 475172 475483 476823 490079 492002 493218 494692 496454 499148 501732 501748 501752 501774 501776 501804 505977 507500 508747 510203 510610 512790 513768 514033 514673 518548 519486 519661 521193 524016 527057 527793 531647 537425 551147 552043 552134 552296 554253 555571 556397 556945 558958 563325 563854 563871 563878 565188 565279 566764 569933 581976 584257 586549 586597 592314 593649 596412 600381 602212 605644 605936 606912 608878 609436 615318 628910 641886 654459 654914 659412 659439 671334 671356 671626 671656 672671 676987 677020 677060 677387 681505 683588 685001 687174 688045 688340 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"virgin girl sex"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"virgin девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"virgin девушк секс"
]
|
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.