Query Metrics
7
Database Queries
7
Different statements
144.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.44 ms (82.73%) |
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 6699 107495 107651 387499 390255 394053 396593 399152 399652 402564 421326 424497 428968 431962 436691 437657 440855 441745 441822 446783 448058 448412 449261 450654 454683 456215 456366 456428 456975 457593 462207 462368 464209 465484 465924 468765 470973 475824 477013 477132 477470 477864 479010 479202 480831 482585 482609 484311 486619 486673 486697 487895 488705 491357 491940 497235 497924 499875 500549 500663 501290 503361 503774 510841 511996 512120 512580 514781 516652 516764 516769 516773 516979 521741 521743 523684 524138 526787 526906 527099 527909 528199 529496 530523 533192 533261 534334 534462 539086 541618 546829 548031 552933 554498 556319 559228 561024 567349 570967 577364 577570 592763 596545 603991 641465 646023 650320 664237 664562 670114 706931 707974 709404 722545 740536 748781 759545 804193 820715 824090 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (10.82%) |
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 436691 424497 824090 448412 497235 510841 528199 530523 539086 482585 546829 552933 577570 554498 556319 567349 570967 646023 664237 670114 707974 709404 592763 596545 804193 759545 394053 457593 470973 402564 387499 446783 500549 511996 526787 491357 512580 399652 456215 501290 516979 475824 559228 561024 462207 464209 465924 479202 421326 468765 503361 491940 486673 488705 527099 514781 521741 523684 527909 534334 107495 428968 440855 441822 820715 482609 456428 456975 465484 450654 462368 486697 456366 503774 499875 512120 533192 533261 497924 524138 534462 521743 477013 477864 487895 548031 541618 664562 722545 650320 706931 748781 740536 641465 479010 107651 399152 437657 448058 477132 480831 529496 500663 484311 516769 516773 516764 526906 431962 477470 577364 603991 516652 449261 486619 454683 6699 390255 396593 441745 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (2.02%) |
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 6699 107495 107651 387499 390255 394053 396593 399152 399652 402564 421326 424497 428968 431962 436691 437657 440855 441745 441822 446783 448058 448412 449261 450654 454683 456215 456366 456428 456975 457593 462207 462368 464209 465484 465924 468765 470973 475824 477013 477132 477470 477864 479010 479202 480831 482585 482609 484311 486619 486673 486697 487895 488705 491357 491940 497235 497924 499875 500549 500663 501290 503361 503774 510841 511996 512120 512580 514781 516652 516764 516769 516773 516979 521741 521743 523684 524138 526787 526906 527099 527909 528199 529496 530523 533192 533261 534334 534462 539086 541618 546829 548031 552933 554498 556319 559228 561024 567349 570967 577364 577570 592763 596545 603991 641465 646023 650320 664237 664562 670114 706931 707974 709404 722545 740536 748781 759545 804193 820715 824090 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доминирован лиза pussy"
]
|
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.