Query Metrics
7
Database Queries
7
Different statements
185.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.53 ms (89.14%) |
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 412474 415496 420101 425773 457406 461437 465158 465651 469522 470317 471860 473044 473999 482968 484799 486306 487895 490605 492679 493255 494521 495660 504546 508818 513304 514152 518443 523970 524627 526583 529079 534087 536128 537821 540338 543686 545521 550001 551112 554290 556063 560422 561682 564039 564597 564795 565173 565279 566033 566071 572304 574989 575711 576088 586017 590413 592162 594173 594929 597165 598045 600128 605190 607136 608423 609311 612198 612206 622389 624653 631132 634161 640537 642362 646212 647844 661936 669130 671073 672881 674361 680142 692418 702762 704212 705600 709207 709675 709832 711342 712728 718965 719002 720715 724185 728283 731895 731975 737357 740454 743075 745434 747609 748317 751770 752694 754221 755430 756239 756672 757310 757556 760019 774111 775051 777564 777808 782725 786728 ] |
||||||||||||||||||||||||||||||
|
11.24 ms (6.05%) |
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 680142 704212 680196 743075 751770 415496 564039 590413 471860 473044 513304 529079 493255 492679 508818 556063 560422 566071 572304 470317 420101 540338 487895 597165 756239 756672 624653 518443 482968 534087 484799 564795 661936 718965 719002 672881 674361 692418 712728 551112 592162 605190 608423 586017 622389 782725 760019 731895 731975 752694 774111 737357 745434 754221 724185 609311 720715 490605 576088 550001 564597 594929 594173 473999 425773 465158 469522 514152 537821 526583 523970 536128 671073 709832 598045 607136 642362 747609 728283 757310 640537 543686 574989 702762 711342 646212 669130 612198 612206 786728 748317 757556 755430 740454 631132 705600 709207 709675 775051 777564 777808 495660 647844 600128 634161 575711 561682 565173 565279 566033 545521 554290 457406 465651 412474 461437 486306 504546 524627 494521 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.46%) |
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 412474 415496 420101 425773 457406 461437 465158 465651 469522 470317 471860 473044 473999 482968 484799 486306 487895 490605 492679 493255 494521 495660 504546 508818 513304 514152 518443 523970 524627 526583 529079 534087 536128 537821 540338 543686 545521 550001 551112 554290 556063 560422 561682 564039 564597 564795 565173 565279 566033 566071 572304 574989 575711 576088 586017 590413 592162 594173 594929 597165 598045 600128 605190 607136 608423 609311 612198 612206 622389 624653 631132 634161 640537 642362 646212 647844 661936 669130 671073 672881 674361 680142 692418 702762 704212 705600 709207 709675 709832 711342 712728 718965 719002 720715 724185 728283 731895 731975 737357 740454 743075 745434 747609 748317 751770 752694 754221 755430 756239 756672 757310 757556 760019 774111 775051 777564 777808 782725 786728 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting beauty girl"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг beauty девушк"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг beauty девушк"
]
|
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.