Query Metrics
7
Database Queries
7
Different statements
614.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
385.00 ms (62.67%) |
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 340567 396313 396879 416034 418449 419067 420761 435064 437749 439750 440914 441654 444579 446055 447166 449322 450315 454688 456707 457675 457688 457886 459377 460813 460853 462183 462703 466808 471521 472285 472494 474656 474813 480837 482714 483433 492115 492721 494670 498857 500692 511196 512694 516252 516730 516778 518217 518218 525123 525363 527203 528425 532254 535986 543606 545454 550320 550479 551212 552980 554262 554552 560180 569495 569583 571741 572975 574763 577608 580449 585098 585447 585723 586274 586486 587030 587162 588076 589743 590967 592785 598536 600667 604406 605687 612467 618514 630558 631604 631641 634211 644114 644268 650882 674662 693967 696109 702364 714925 718384 724181 725036 726446 731939 738496 738518 762569 777161 781400 791194 801464 802239 807506 808621 811124 814883 815252 817875 818072 ] |
||||||||||||||||||||||||||||||
|
207.27 ms (33.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"over sex"
]
|
||||||||||||||||||||||||||||||
|
15.20 ms (2.47%) |
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 471521 444579 447166 518218 818072 585098 472494 457886 532254 500692 516730 525123 696109 714925 718384 650882 693967 550479 551212 600667 585723 598536 631641 791194 726446 418449 439750 457675 396879 492115 492721 498857 512694 396313 817875 456707 454688 466808 462703 527203 462183 574763 577608 550320 569495 674662 554552 571741 580449 587030 588076 586274 592785 604755 605687 630558 802239 811124 781400 762569 738496 612467 777161 474813 516778 525363 634211 543606 807506 474656 511196 545454 585447 587162 589743 590967 814883 815252 459377 528425 516252 552980 572975 586486 644268 801464 724181 419067 420761 437749 483433 441654 482714 446055 460853 449322 472285 535986 702364 631604 618514 738518 340567 460813 450315 494670 560180 569583 554262 644114 725036 731939 604406 808621 457688 480837 435064 518217 416034 440914 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (0.37%) |
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 340567 396313 396879 416034 418449 419067 420761 435064 437749 439750 440914 441654 444579 446055 447166 449322 450315 454688 456707 457675 457688 457886 459377 460813 460853 462183 462703 466808 471521 472285 472494 474656 474813 480837 482714 483433 492115 492721 494670 498857 500692 511196 512694 516252 516730 516778 518217 518218 525123 525363 527203 528425 532254 535986 543606 545454 550320 550479 551212 552980 554262 554552 560180 569495 569583 571741 572975 574763 577608 580449 585098 585447 585723 586274 586486 587030 587162 588076 589743 590967 592785 598536 600667 604406 605687 612467 618514 630558 631604 631641 634211 644114 644268 650882 674662 693967 696109 702364 714925 718384 724181 725036 726446 731939 738496 738518 762569 777161 781400 791194 801464 802239 807506 808621 811124 814883 815252 817875 818072 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"over секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"over секс"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.23%) |
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.