Query Metrics
7
Database Queries
7
Different statements
394.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.65 ms (51.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
163.65 ms (41.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 386746 388423 397782 398019 414736 415505 421459 423571 424247 429937 431685 438023 438040 444874 450637 453463 455870 457167 460555 461827 466725 467628 471975 474412 477493 482074 483260 486684 486736 495082 499694 500412 504682 506613 512012 519546 520134 521079 521333 523134 532131 532821 544517 545329 546791 547705 549644 552818 562970 563100 563895 566065 567683 578348 584338 590961 591114 591778 596770 600283 604570 614419 646755 661944 673357 680619 703097 708152 710419 710544 714450 718279 721931 725472 726604 729039 732781 733484 734084 736010 744764 746103 746838 750922 753737 754004 756057 756070 761399 769834 772516 775009 787764 789192 795978 795992 796852 799073 799188 799979 800759 801860 802651 803412 803724 804383 804781 807523 808808 809782 810266 813439 814565 814646 816993 817397 818608 824222 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (4.16%) |
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 604570 460555 546791 547705 680619 661944 804383 810266 803724 725472 746103 750922 769834 799979 803412 733484 729039 710419 545329 732781 772516 714450 796852 800759 596770 789192 388423 429937 795992 590961 718279 756070 736010 761399 414736 756057 532821 532131 466725 386746 450637 444874 495082 549644 504682 795978 467628 398019 415505 676582 523134 499694 423571 566065 710544 801860 816993 818608 799188 799073 455870 813439 746838 762249 753737 397782 809782 421459 461827 438040 824222 817397 506613 519546 520134 814565 486684 563895 591778 521333 486736 482074 673357 500412 734084 567683 453463 457167 483260 477493 512012 544517 424247 521079 708152 787764 726604 744764 578348 584338 721931 646755 804781 754004 431685 552818 562970 614419 775009 438023 814646 474412 703097 563100 600283 807523 802651 471975 591114 808808 ] |
||||||||||||||||||||||||||||||
|
4.26 ms (1.08%) |
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 386746 388423 397782 398019 414736 415505 421459 423571 424247 429937 431685 438023 438040 444874 450637 453463 455870 457167 460555 461827 466725 467628 471975 474412 477493 482074 483260 486684 486736 495082 499694 500412 504682 506613 512012 519546 520134 521079 521333 523134 532131 532821 544517 545329 546791 547705 549644 552818 562970 563100 563895 566065 567683 578348 584338 590961 591114 591778 596770 600283 604570 614419 646755 661944 673357 680619 703097 708152 710419 710544 714450 718279 721931 725472 726604 729039 732781 733484 734084 736010 744764 746103 746838 750922 753737 754004 756057 756070 761399 769834 772516 775009 787764 789192 795978 795992 796852 799073 799188 799979 800759 801860 802651 803412 803724 804383 804781 807523 808808 809782 810266 813439 814565 814646 816993 817397 818608 824222 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob mother"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.