Query Metrics
7
Database Queries
7
Different statements
394.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
361.77 ms (91.64%) |
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 406592 429561 452061 452136 452256 454733 460673 464025 464445 464464 465198 466733 468718 468835 469616 470290 471183 471824 472734 473204 474147 474663 475241 475245 475828 478049 482555 482987 484519 484684 484688 484694 486198 486399 486540 486594 486706 486887 487072 489343 489692 491871 491963 491978 492128 492269 492323 492472 493121 494345 494797 495198 496100 498039 499787 501248 502995 505814 507916 508737 510042 511023 513076 513113 513137 514294 515122 515262 515347 515692 515715 516462 517068 517386 518170 518751 519034 519632 521262 522016 523081 524560 524952 524969 524986 527000 527232 528084 530726 531431 531468 531943 532849 533014 533373 533541 533957 533965 534168 535017 535460 536538 537114 540071 540511 541651 543771 550571 557164 557166 559692 588283 593182 609843 630766 647932 649179 651634 663465 690124 ] |
||||||||||||||||||||||||||||||
|
21.95 ms (5.56%) |
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 557166 559692 663465 588283 630766 475245 454733 464464 452256 464025 465198 524560 527232 533965 486887 494797 513113 517068 486399 510042 518170 499787 508737 515347 521262 522016 593182 543771 474147 487072 517386 466733 482555 478049 492269 532849 507916 519034 531431 495198 533373 533541 519632 530726 537114 469616 486540 651634 471183 452061 472734 406592 468718 516462 518751 534168 484684 491871 494345 496100 505814 535460 541651 486198 501248 515715 452136 484688 484694 429561 513076 528084 515692 531468 535017 540071 557164 649179 690124 609843 475241 524969 482987 489343 492323 493121 527000 486706 523081 470290 515122 464445 492472 524952 484519 533957 468835 471824 489692 533014 502995 536538 531943 491978 550571 647932 475828 473204 491963 492128 511023 513137 524986 486594 498039 514294 515262 460673 540511 474663 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (0.90%) |
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 406592 429561 452061 452136 452256 454733 460673 464025 464445 464464 465198 466733 468718 468835 469616 470290 471183 471824 472734 473204 474147 474663 475241 475245 475828 478049 482555 482987 484519 484684 484688 484694 486198 486399 486540 486594 486706 486887 487072 489343 489692 491871 491963 491978 492128 492269 492323 492472 493121 494345 494797 495198 496100 498039 499787 501248 502995 505814 507916 508737 510042 511023 513076 513113 513137 514294 515122 515262 515347 515692 515715 516462 517068 517386 518170 518751 519034 519632 521262 522016 523081 524560 524952 524969 524986 527000 527232 528084 530726 531431 531468 531943 532849 533014 533373 533541 533957 533965 534168 535017 535460 536538 537114 540071 540511 541651 543771 550571 557164 557166 559692 588283 593182 609843 630766 647932 649179 651634 663465 690124 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature красивая"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature красивая"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.44%) |
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.