Query Metrics
7
Database Queries
7
Different statements
195.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.27 ms (84.99%) |
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 400491 415836 416680 417835 418145 419319 421810 421922 421991 424648 427246 428159 428756 439759 443607 444632 444883 446909 447095 448773 451639 454141 454425 455341 455351 455974 456202 460325 460514 460535 463072 464724 466573 467569 473139 473463 477941 481772 485057 485064 485997 489262 490753 493310 494546 495352 502518 502540 504141 504250 504450 506794 507276 508701 509481 509913 510200 511159 511176 511675 512375 512410 513001 513832 515578 518622 519322 519512 519589 519679 519859 521532 522642 523171 523301 523823 523907 525286 527458 527706 527928 528262 547612 551847 557091 557946 557953 562853 564055 564267 576966 586028 591214 593366 595256 597148 598172 598899 601851 601852 601906 604419 610466 612699 621764 622405 623405 624137 624142 624953 625437 628443 651561 652125 652756 657780 684694 725153 728946 760169 ] |
||||||||||||||||||||||||||||||
|
18.13 ms (9.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 428159 417835 460514 519322 511675 657780 490753 466573 523301 624142 481772 513832 495352 624137 421810 519859 444632 467569 494546 628443 598899 760169 557953 564267 651561 622405 725153 439759 455974 463072 421991 506794 485057 485997 511176 511159 562853 564055 460535 477941 443607 512375 419319 485064 510200 557091 601852 591214 512410 527706 504250 519512 455341 522642 576966 624953 454425 416680 473463 523907 509481 528262 527458 610466 586028 418145 424648 515578 557946 728946 456202 504141 684694 460325 454141 415836 527928 612699 504450 523823 446909 451639 509913 521532 444883 455351 652125 551847 447095 421922 507276 508701 427246 493310 464724 519589 502540 502518 652756 525286 400491 428756 448773 518622 519679 595256 489262 473139 621764 523171 601906 598172 604419 601851 625437 547612 597148 623405 513001 593366 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (1.98%) |
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 400491 415836 416680 417835 418145 419319 421810 421922 421991 424648 427246 428159 428756 439759 443607 444632 444883 446909 447095 448773 451639 454141 454425 455341 455351 455974 456202 460325 460514 460535 463072 464724 466573 467569 473139 473463 477941 481772 485057 485064 485997 489262 490753 493310 494546 495352 502518 502540 504141 504250 504450 506794 507276 508701 509481 509913 510200 511159 511176 511675 512375 512410 513001 513832 515578 518622 519322 519512 519589 519679 519859 521532 522642 523171 523301 523823 523907 525286 527458 527706 527928 528262 547612 551847 557091 557946 557953 562853 564055 564267 576966 586028 591214 593366 595256 597148 598172 598899 601851 601852 601906 604419 610466 612699 621764 622405 623405 624137 624142 624953 625437 628443 651561 652125 652756 657780 684694 725153 728946 760169 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real webcam sex"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real вебкамер секс"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real вебкамер секс"
]
|
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.