Query Metrics
7
Database Queries
7
Different statements
624.47 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.74 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.94 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short pussy"
]
|
||||||||||||||||||||||||||||||
| 3 | 228.72 ms |
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 528367 521782 394566 381875 44998 14599 406070 426298 421524 411742 817070 827033 827723 819237 818661 824459 825396 477976 485487 493023 473096 456877 485716 539326 516082 529372 499457 519142 532156 461151 463202 474398 481963 544506 554446 558310 560954 570225 579553 556625 558987 563428 549219 561761 563454 570967 665287 667851 693254 694322 696322 697013 715196 663353 665508 666426 667639 688322 694464 694537 714007 715420 718560 718561 721424 649527 693026 717646 548418 600631 610689 629420 594942 621717 642012 586445 596349 602049 608352 596950 606923 618913 620159 620256 641879 776415 781706 782618 782737 786468 790976 798067 805201 806362 807881 811407 811503 813115 800767 807489 808000 809195 809470 809765 725606 726880 729873 731103 743197 746135 746173 758295 772991 796243 798087 800732 724605 725211 725368 731087 ] |
||||||||||||||||||||||||||||||
| 4 | 213.15 ms |
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 14599 44998 381875 394566 406070 411742 421524 426298 456877 461151 463202 473096 474398 477976 481963 485487 485716 493023 499457 516082 519142 521782 528367 529372 532156 539326 544506 548418 549219 554446 556625 558310 558987 560954 561761 563428 563454 570225 570967 579553 586445 594942 596349 596950 600631 602049 606923 608352 610689 618913 620159 620256 621717 629420 641879 642012 649527 663353 665287 665508 666426 667639 667851 688322 693026 693254 694322 694464 694537 696322 697013 714007 715196 715420 717646 718560 718561 721424 724605 725211 725368 725606 726880 729873 731087 731103 743197 746135 746173 758295 772991 776415 781706 782618 782737 786468 790976 796243 798067 798087 800732 800767 805201 806362 807489 807881 808000 809195 809470 809765 811407 811503 813115 817070 818661 819237 824459 825396 827033 827723 ] |
||||||||||||||||||||||||||||||
| 5 | 175.35 ms |
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 14599 44998 381875 394566 406070 411742 421524 426298 456877 461151 463202 473096 474398 477976 481963 485487 485716 493023 499457 516082 519142 521782 528367 529372 532156 539326 544506 548418 549219 554446 556625 558310 558987 560954 561761 563428 563454 570225 570967 579553 586445 594942 596349 596950 600631 602049 606923 608352 610689 618913 620159 620256 621717 629420 641879 642012 649527 663353 665287 665508 666426 667639 667851 688322 693026 693254 694322 694464 694537 696322 697013 714007 715196 715420 717646 718560 718561 721424 724605 725211 725368 725606 726880 729873 731087 731103 743197 746135 746173 758295 772991 776415 781706 782618 782737 786468 790976 796243 798067 798087 800732 800767 805201 806362 807489 807881 808000 809195 809470 809765 811407 811503 813115 817070 818661 819237 824459 825396 827033 827723 ] |
||||||||||||||||||||||||||||||
| 6 | 1.82 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short pussy"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.74 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short 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.