Query Metrics
7
Database Queries
7
Different statements
153.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.26 ms (78.51%) |
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 398209 405850 407800 415834 417903 420146 422034 426465 427100 427364 431500 437558 439322 440657 446420 448561 449695 453419 455241 456034 457773 457775 462708 462720 466034 466059 466109 466750 468070 469793 471327 474188 479403 481747 482040 482945 483424 484577 485980 489178 489851 491943 492567 493382 494563 495302 495319 496389 498468 500493 501267 502714 502715 504168 505523 505750 505806 506812 506982 507865 509764 511924 513857 515389 517129 517969 518335 518613 518805 519354 519494 520599 521877 522953 523231 523465 524833 526147 527099 527391 527909 527945 528143 528760 529153 541479 545914 550817 554399 554621 555973 556009 556481 567408 568070 568726 576041 581712 584791 586605 587817 596160 597863 605855 622044 650664 653794 724440 730091 748236 756714 770245 784427 793175 796804 796881 802413 807980 812795 815789 ] |
||||||||||||||||||||||||||||||
|
24.04 ms (15.70%) |
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 466034 482040 427100 462708 462720 468070 471327 481747 505750 527391 484577 485980 518613 496389 501267 511924 515389 518335 526147 482945 489178 494563 523465 556009 398209 420146 426465 437558 440657 439322 815789 457773 457775 456034 492567 448561 517129 523231 507865 505806 528760 505523 513857 479403 489851 545914 550817 554621 555973 556481 568070 581712 541479 568726 584791 650664 653794 554399 567408 576041 605855 622044 596160 597863 586605 587817 793175 796881 812795 796804 802413 807980 724440 730091 748236 770245 756714 784427 417903 422034 455241 466109 474188 431500 453419 415834 427364 466750 522953 524833 528143 483424 502714 502715 506812 509764 518805 519354 520599 527945 493382 498468 517969 519494 527099 491943 504168 506982 521877 527909 529153 405850 407800 469793 466059 446420 449695 495319 495302 500493 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.32%) |
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 398209 405850 407800 415834 417903 420146 422034 426465 427100 427364 431500 437558 439322 440657 446420 448561 449695 453419 455241 456034 457773 457775 462708 462720 466034 466059 466109 466750 468070 469793 471327 474188 479403 481747 482040 482945 483424 484577 485980 489178 489851 491943 492567 493382 494563 495302 495319 496389 498468 500493 501267 502714 502715 504168 505523 505750 505806 506812 506982 507865 509764 511924 513857 515389 517129 517969 518335 518613 518805 519354 519494 520599 521877 522953 523231 523465 524833 526147 527099 527391 527909 527945 528143 528760 529153 541479 545914 550817 554399 554621 555973 556009 556481 567408 568070 568726 576041 581712 584791 586605 587817 596160 597863 605855 622044 650664 653794 724440 730091 748236 756714 770245 784427 793175 796804 796881 802413 807980 812795 815789 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy home"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy home"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy home"
]
|
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.