Query Metrics
7
Database Queries
7
Different statements
157.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.30 ms (83.62%) |
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 285356 384489 384864 386225 386764 388053 389714 395540 397530 398351 403021 404859 406556 409934 416974 418877 420155 420238 420307 430219 430698 431393 441449 443378 443402 445920 449093 453708 457389 457422 457985 459419 460248 462630 462870 464397 469574 471623 474474 486058 486433 492243 498441 499825 501696 506896 512807 513115 517861 520682 523910 528359 531197 532068 543247 550996 554886 557823 559607 559684 560905 562004 563648 565152 566057 574694 576981 578142 581199 583933 584453 591048 594126 600239 600819 601062 604156 604681 606192 607371 607476 608338 636316 642742 647935 663346 666124 667536 668529 673658 673858 705710 712106 712888 714036 714730 725400 725788 726348 748609 755994 781861 784812 788879 789698 793070 794978 799595 803937 805221 805962 806228 807763 814625 814916 815054 815077 820973 824130 828460 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (10.46%) |
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 583933 512807 397530 384864 824130 814625 513115 563648 604156 784812 725400 445920 416974 449093 523910 388053 814916 420307 384489 532068 457422 386764 528359 574694 543247 673858 667536 714036 578142 594126 607476 606192 600239 748609 725788 705710 793070 805221 460248 462630 420238 474474 389714 486058 531197 559607 285356 464397 663346 820973 584453 443402 457985 506896 386225 398351 404859 815054 815077 453708 462870 469574 492243 550996 559684 576981 666124 673658 712106 712888 668529 557823 601062 604681 591048 607371 788879 789698 805962 781861 807763 799595 755994 714730 430219 395540 471623 430698 406556 443378 499825 560905 554886 498441 486433 565152 636316 600819 806228 418877 441449 459419 501696 794978 726348 420155 431393 803937 403021 520682 409934 517861 642742 828460 581199 457389 566057 647935 562004 608338 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.56%) |
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 285356 384489 384864 386225 386764 388053 389714 395540 397530 398351 403021 404859 406556 409934 416974 418877 420155 420238 420307 430219 430698 431393 441449 443378 443402 445920 449093 453708 457389 457422 457985 459419 460248 462630 462870 464397 469574 471623 474474 486058 486433 492243 498441 499825 501696 506896 512807 513115 517861 520682 523910 528359 531197 532068 543247 550996 554886 557823 559607 559684 560905 562004 563648 565152 566057 574694 576981 578142 581199 583933 584453 591048 594126 600239 600819 601062 604156 604681 606192 607371 607476 608338 636316 642742 647935 663346 666124 667536 668529 673658 673858 705710 712106 712888 714036 714730 725400 725788 726348 748609 755994 781861 784812 788879 789698 793070 794978 799595 803937 805221 805962 806228 807763 814625 814916 815054 815077 820973 824130 828460 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"busty milf blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"busty milf минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"busty milf минет оральн секс"
]
|
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.