Query Metrics
7
Database Queries
7
Different statements
163.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.61 ms (84.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 20617 45856 56810 382568 388022 388113 413076 428155 455065 455949 458823 461039 467085 468352 472606 475875 476408 483910 495508 499359 500885 501322 502063 520524 525424 526887 529977 539597 542938 543784 548425 553684 553849 555171 557815 560164 560166 560304 561595 567603 568651 568652 570954 572568 583564 588978 590313 592227 600876 600954 604883 610013 612311 619570 619655 620327 624751 628591 628609 643074 643335 649815 650272 650447 650608 650797 651998 653341 666046 666398 668784 669448 671896 673329 681230 687616 694098 705471 710248 717069 718448 718733 725129 726671 726936 731361 734639 742274 746052 768208 773971 775835 780149 786440 787525 793243 793395 794421 795110 795354 795503 795702 796294 798611 799409 799646 800672 800759 802230 808225 816025 816060 816887 817934 820188 821172 823746 825560 825771 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (9.15%) |
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 725129 726671 731361 734639 742274 746052 768208 773971 707498 717069 780149 793243 795354 795503 799409 800759 808225 56810 20617 461039 45856 382568 388022 475875 483910 495508 499359 570954 694098 726936 388113 428155 413076 817934 823746 816025 816887 820188 825560 825771 816060 821172 455065 467085 468352 472606 458823 455949 501322 502063 520524 539597 526887 500885 525424 529977 476408 553684 560166 567603 568651 543784 560164 561595 542938 548425 553849 555171 560304 572568 650447 650608 651998 668784 687616 718448 718733 650272 666398 669448 671896 710248 649815 650797 653341 666046 673329 681230 705471 557815 568652 583564 588978 600876 600954 610013 620327 590313 628591 604883 612311 619655 624751 628609 592227 619570 643074 643335 793395 794421 795702 796294 799646 800672 775835 786440 787525 795110 798611 802230 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.54%) |
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 20617 45856 56810 382568 388022 388113 413076 428155 455065 455949 458823 461039 467085 468352 472606 475875 476408 483910 495508 499359 500885 501322 502063 520524 525424 526887 529977 539597 542938 543784 548425 553684 553849 555171 557815 560164 560166 560304 561595 567603 568651 568652 570954 572568 583564 588978 590313 592227 600876 600954 604883 610013 612311 619570 619655 620327 624751 628591 628609 643074 643335 649815 650272 650447 650608 650797 651998 653341 666046 666398 668784 669448 671896 673329 681230 687616 694098 705471 710248 717069 718448 718733 725129 726671 726936 731361 734639 742274 746052 768208 773971 775835 780149 786440 787525 793243 793395 794421 795110 795354 795503 795702 796294 798611 799409 799646 800672 800759 802230 808225 816025 816060 816887 817934 820188 821172 823746 825560 825771 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf sexy"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf sexy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf sexy"
]
|
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.