Query Metrics
7
Database Queries
7
Different statements
175.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.08 ms (84.60%) |
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 410791 422132 427126 429387 433397 438290 438417 444806 453508 455478 456549 456605 456877 459937 473435 474714 477338 479953 479965 486223 488155 493242 494496 496932 497167 503544 506232 509705 511077 511102 511452 511466 517128 517393 519323 520553 521122 521676 524205 525089 525369 530381 530383 530476 530484 530911 531114 531115 531145 531179 531200 531206 531209 531210 531211 531225 531232 531252 532733 532744 532837 533043 533368 536748 537123 537887 537936 542591 543910 544050 550199 552352 565243 569923 575882 581263 583793 585787 590485 593485 595676 596693 599911 600219 600270 600329 606574 616758 616765 616776 632698 634157 637431 637444 639816 641681 648862 666867 676622 696229 702675 703832 703841 704269 715365 729629 731683 734140 761829 765040 780177 782557 794436 794947 797343 798071 798854 800535 805274 824456 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (9.46%) |
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 782557 488155 590485 734140 797343 798854 794436 543910 511077 521676 544050 427126 503544 511466 520553 511102 422132 496932 780177 521122 524205 531200 537936 552352 569923 616776 729629 479953 517128 525369 494496 824456 715365 634157 637444 798071 761829 765040 479965 509705 596693 800535 575882 519323 581263 444806 456549 473435 486223 456605 537887 532744 585787 438290 477338 531179 696229 666867 648862 616765 794947 459937 583793 606574 632698 637431 595676 600329 616758 506232 429387 537123 438417 517393 511452 455478 456877 531145 542591 731683 433397 530911 531210 532733 530484 531209 531211 533043 550199 704269 703832 703841 453508 531206 474714 676622 593485 702675 599911 600270 600219 639816 805274 641681 497167 530381 531252 565243 410791 525089 493242 530383 531225 531232 531115 533368 536748 530476 531114 532837 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (2.14%) |
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 410791 422132 427126 429387 433397 438290 438417 444806 453508 455478 456549 456605 456877 459937 473435 474714 477338 479953 479965 486223 488155 493242 494496 496932 497167 503544 506232 509705 511077 511102 511452 511466 517128 517393 519323 520553 521122 521676 524205 525089 525369 530381 530383 530476 530484 530911 531114 531115 531145 531179 531200 531206 531209 531210 531211 531225 531232 531252 532733 532744 532837 533043 533368 536748 537123 537887 537936 542591 543910 544050 550199 552352 565243 569923 575882 581263 583793 585787 590485 593485 595676 596693 599911 600219 600270 600329 606574 616758 616765 616776 632698 634157 637431 637444 639816 641681 648862 666867 676622 696229 702675 703832 703841 704269 715365 729629 731683 734140 761829 765040 780177 782557 794436 794947 797343 798071 798854 800535 805274 824456 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"balls handjob"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"balls дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"balls дрочк член"
]
|
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.