Query Metrics
7
Database Queries
7
Different statements
919.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
267.00 ms (29.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 742022 744151 765678 736361 740836 748366 761670 764189 769532 722820 722834 722852 775681 779589 780547 782584 787457 797053 799872 800878 802655 804502 810666 811047 462260 402404 433697 461963 229566 408694 383747 426156 442999 436510 507550 508938 557707 562423 587070 743610 614942 784307 401749 471398 518323 518909 525377 490513 562001 118164 394738 264454 389142 396958 403074 401522 818484 824090 813548 814922 817039 817086 824735 814776 818661 823533 825884 827648 826030 477976 467909 476422 494662 539086 533550 468947 544575 572331 646023 667021 676491 683308 699599 704072 710460 718344 719923 660711 678807 696071 696231 714756 721438 661007 665600 667015 668614 674216 684594 689595 697252 581760 614484 625246 635250 603817 620880 597044 600063 608352 610374 621413 642271 609551 641879 643362 776265 784571 784661 788225 ] |
||||||||||||||||||||||||||||||
|
219.61 ms (23.90%) |
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 118164 229566 264454 383747 389142 394738 396958 401522 401749 402404 403074 408694 426156 433697 436510 442999 461963 462260 467909 468947 471398 476422 477976 490513 494662 507550 508938 518323 518909 525377 533550 539086 544575 557707 562001 562423 572331 581760 587070 597044 600063 603817 608352 609551 610374 614484 614942 620880 621413 625246 635250 641879 642271 643362 646023 660711 661007 665600 667015 667021 668614 674216 676491 678807 683308 684594 689595 696071 696231 697252 699599 704072 710460 714756 718344 719923 721438 722820 722834 722852 736361 740836 742022 743610 744151 748366 761670 764189 765678 769532 775681 776265 779589 780547 782584 784307 784571 784661 787457 788225 797053 799872 800878 802655 804502 810666 811047 813548 814776 814922 817039 817086 818484 818661 823533 824090 824735 825884 826030 827648 ] |
||||||||||||||||||||||||||||||
|
215.62 ms (23.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red pussy"
]
|
||||||||||||||||||||||||||||||
|
210.44 ms (22.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red pussy"
]
|
||||||||||||||||||||||||||||||
|
2.61 ms (0.28%) |
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 118164 229566 264454 383747 389142 394738 396958 401522 401749 402404 403074 408694 426156 433697 436510 442999 461963 462260 467909 468947 471398 476422 477976 490513 494662 507550 508938 518323 518909 525377 533550 539086 544575 557707 562001 562423 572331 581760 587070 597044 600063 603817 608352 609551 610374 614484 614942 620880 621413 625246 635250 641879 642271 643362 646023 660711 661007 665600 667015 667021 668614 674216 676491 678807 683308 684594 689595 696071 696231 697252 699599 704072 710460 714756 718344 719923 721438 722820 722834 722852 736361 740836 742022 743610 744151 748366 761670 764189 765678 769532 775681 776265 779589 780547 782584 784307 784571 784661 787457 788225 797053 799872 800878 802655 804502 810666 811047 813548 814776 814922 817039 817086 818484 818661 823533 824090 824735 825884 826030 827648 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red pussy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.17%) |
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.