Query Metrics
7
Database Queries
7
Different statements
218.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.29 ms (82.52%) |
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 7871 17037 56639 153402 195329 312730 336687 357839 366011 381855 382712 384790 385704 388560 388813 400460 401886 402566 404009 414688 414759 417080 427755 429150 436636 443463 443508 444964 447813 454016 458603 460088 467664 467669 468864 470372 473550 473919 483779 484116 487699 491540 491573 491669 493445 505716 505718 508247 510572 510658 510689 511743 512283 516980 518412 521857 522814 523750 524146 526477 529292 538191 538379 538891 545711 548590 548651 559554 562217 563206 564461 565958 566750 569846 569853 570256 570270 572523 573054 573777 574608 574614 574851 574860 575138 575147 575156 575770 576276 576410 576731 578386 595432 600154 612083 616745 649536 655724 659552 663931 667566 676507 679127 696168 696316 699161 712827 719237 721225 724003 739708 740623 760925 767278 781014 781685 782155 793568 804194 805021 ] |
||||||||||||||||||||||||||||||
|
24.57 ms (11.25%) |
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 574608 414759 521857 460088 663931 781685 804194 153402 454016 526477 404009 470372 548590 569846 572523 564461 574614 576276 576731 382712 388813 443463 510658 511743 491669 505716 512283 518412 402566 696168 767278 719237 793568 357839 467669 655724 721225 781014 724003 740623 739708 7871 195329 483779 565958 569853 562217 566750 760925 384790 447813 458603 559554 573054 679127 712827 574860 805021 388560 443508 381855 429150 473919 508247 523750 336687 56639 427755 484116 570270 659552 676507 699161 414688 505718 538379 522814 510689 385704 444964 563206 667566 696316 782155 366011 468864 510572 417080 649536 612083 529292 575138 575147 575156 576410 545711 573777 575770 578386 548651 574851 595432 400460 524146 491540 491573 516980 570256 473550 17037 538191 312730 401886 436636 467664 487699 493445 538891 616745 600154 ] |
||||||||||||||||||||||||||||||
|
6.30 ms (2.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy girl kissing"
]
|
||||||||||||||||||||||||||||||
|
2.98 ms (1.36%) |
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 7871 17037 56639 153402 195329 312730 336687 357839 366011 381855 382712 384790 385704 388560 388813 400460 401886 402566 404009 414688 414759 417080 427755 429150 436636 443463 443508 444964 447813 454016 458603 460088 467664 467669 468864 470372 473550 473919 483779 484116 487699 491540 491573 491669 493445 505716 505718 508247 510572 510658 510689 511743 512283 516980 518412 521857 522814 523750 524146 526477 529292 538191 538379 538891 545711 548590 548651 559554 562217 563206 564461 565958 566750 569846 569853 570256 570270 572523 573054 573777 574608 574614 574851 574860 575138 575147 575156 575770 576276 576410 576731 578386 595432 600154 612083 616745 649536 655724 659552 663931 667566 676507 679127 696168 696316 699161 712827 719237 721225 724003 739708 740623 760925 767278 781014 781685 782155 793568 804194 805021 ] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен девушк kissing"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен девушк kissing"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.