Query Metrics
7
Database Queries
7
Different statements
153.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.99 ms (81.84%) |
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 415160 415954 419988 421520 429572 443103 453162 453345 462450 463122 463757 463808 465619 468537 469193 470852 474827 475194 477412 478832 479002 491776 491963 492128 492256 492572 492607 493477 496100 496367 497422 508199 508430 508437 508473 510254 511370 511920 512050 512538 514824 519727 519909 520737 522050 522220 522382 522949 523317 523706 524628 525622 528791 529855 530030 530269 530694 530757 530832 531231 532745 532753 532766 532843 533738 533747 533915 536214 536676 536691 537184 537199 538290 538963 540338 540339 541604 544345 544359 545471 545772 545802 546786 548257 548642 548885 549351 549371 550097 550549 555820 555889 557963 562514 566673 566991 566993 568117 571388 572763 574263 577356 581684 590381 603493 605349 610209 622975 623616 631202 649622 653557 654196 735493 740699 745307 750788 750789 750790 773045 ] |
||||||||||||||||||||||||||||||
|
18.32 ms (11.90%) |
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 453162 492572 532753 530757 550097 523706 529855 469193 475194 443103 508473 530269 540338 541604 545772 470852 478832 528791 533738 536214 453345 525622 522050 522220 496367 750789 566993 631202 497422 532843 540339 508199 537199 533747 548642 572763 522949 557963 536691 421520 465619 479002 546786 622975 463808 530030 511370 530832 549371 415954 496100 519909 531231 474827 493477 519727 523317 740699 477412 549351 462450 537184 566991 463122 577356 468537 491776 536676 545802 510254 419988 429572 512538 492128 548885 562514 745307 514824 544345 491963 574263 581684 538290 508430 548257 623616 654196 773045 653557 530694 524628 538963 532745 508437 590381 735493 750790 555820 750788 550549 544359 571388 512050 492256 492607 605349 603493 511920 520737 522382 463757 566673 649622 568117 545471 555889 610209 415160 532766 533915 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (2.04%) |
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 415160 415954 419988 421520 429572 443103 453162 453345 462450 463122 463757 463808 465619 468537 469193 470852 474827 475194 477412 478832 479002 491776 491963 492128 492256 492572 492607 493477 496100 496367 497422 508199 508430 508437 508473 510254 511370 511920 512050 512538 514824 519727 519909 520737 522050 522220 522382 522949 523317 523706 524628 525622 528791 529855 530030 530269 530694 530757 530832 531231 532745 532753 532766 532843 533738 533747 533915 536214 536676 536691 537184 537199 538290 538963 540338 540339 541604 544345 544359 545471 545772 545802 546786 548257 548642 548885 549351 549371 550097 550549 555820 555889 557963 562514 566673 566991 566993 568117 571388 572763 574263 577356 581684 590381 603493 605349 610209 622975 623616 631202 649622 653557 654196 735493 740699 745307 750788 750789 750790 773045 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl slave"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.91%) |
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.