Query Metrics
7
Database Queries
7
Different statements
186.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.53 ms (86.46%) |
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 6863 12141 324555 370332 384911 387046 388647 389563 391508 391590 393745 396088 396139 396350 398774 400021 401269 402859 404113 404734 414924 420194 421020 421648 425285 426024 430800 432294 432555 433716 434443 434767 437335 438761 442136 443010 443870 444928 445289 446900 447130 448698 451555 455491 459323 462907 464630 465146 468347 474567 476231 479973 480422 481447 491487 492280 496829 511862 512911 514237 514931 514946 518005 523362 526465 526854 544809 549069 549540 554198 556316 558959 560286 560289 570462 574060 575344 589185 592412 595512 596996 597039 597552 597703 598574 598674 598739 598760 610688 620978 626253 644189 654109 656470 669001 672321 696111 707933 725416 736887 740295 742727 750494 750691 752677 758498 777315 778393 780608 781609 782940 793856 794809 797389 802494 807084 809642 814423 827381 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (7.88%) |
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 442136 459323 465146 514237 575344 549540 597703 777315 781609 740295 750494 398774 414924 384911 401269 432294 558959 570462 589185 782940 750691 370332 400021 480422 476231 523362 556316 656470 707933 447130 420194 455491 391590 402859 492280 549069 696111 597552 610688 620978 794809 736887 797389 404113 514931 560289 389563 421648 481447 526854 560286 644189 425285 433716 592412 598739 434443 802494 388647 491487 598574 827381 793856 773461 396350 479973 511862 514946 554198 669001 598674 595512 626253 752677 778393 780608 404734 432555 434767 444928 396088 426024 391508 438761 518005 387046 443870 814423 448698 462907 574060 596996 725416 396139 464630 468347 526465 512911 6863 421020 474567 597039 742727 809642 654109 443010 393745 324555 430800 451555 672321 758498 12141 544809 807084 598760 437335 445289 446900 496829 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.68%) |
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 6863 12141 324555 370332 384911 387046 388647 389563 391508 391590 393745 396088 396139 396350 398774 400021 401269 402859 404113 404734 414924 420194 421020 421648 425285 426024 430800 432294 432555 433716 434443 434767 437335 438761 442136 443010 443870 444928 445289 446900 447130 448698 451555 455491 459323 462907 464630 465146 468347 474567 476231 479973 480422 481447 491487 492280 496829 511862 512911 514237 514931 514946 518005 523362 526465 526854 544809 549069 549540 554198 556316 558959 560286 560289 570462 574060 575344 589185 592412 595512 596996 597039 597552 597703 598574 598674 598739 598760 610688 620978 626253 644189 654109 656470 669001 672321 696111 707933 725416 736887 740295 742727 750494 750691 752677 758498 777315 778393 780608 781609 782940 793856 794809 797389 802494 807084 809642 814423 827381 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen doggy fuck"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen рак секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen рак секс"
]
|
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.