Query Metrics
7
Database Queries
7
Different statements
148.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.26 ms (82.74%) |
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 3973 43271 96347 96393 193666 381838 381924 382003 382862 384373 387542 387899 391202 391922 392820 395228 395258 395564 395719 397361 397830 400128 400151 401820 406282 407180 407194 407444 407783 407884 408000 408424 412299 414313 422353 424841 443903 447808 448368 460451 462324 466069 467758 478252 479092 479149 482317 483375 484568 484672 484739 484750 486255 486445 486516 492689 502249 504176 512347 514589 518553 522605 525691 526219 526693 530140 540957 543950 547952 549233 550209 557192 563449 567959 571154 603692 629796 629818 637718 645241 645879 663428 663466 663946 665379 667486 667643 667899 668174 670514 674681 688674 712823 715563 718836 726427 727917 729214 731784 739547 739687 744597 748247 758299 770124 770133 770143 781447 784442 790962 794803 800342 802651 803656 805122 805403 807722 808873 816259 827416 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (10.63%) |
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 739547 800342 543950 670514 547952 712823 395228 514589 525691 549233 674681 688674 629796 726427 550209 3973 522605 486445 718836 739687 770143 629818 466069 484672 530140 808873 715563 729214 571154 382862 407884 803656 731784 802651 645879 805122 486516 727917 414313 805403 400128 816259 518553 391202 395719 462324 540957 668174 502249 193666 392820 400151 667486 482317 492689 526693 391922 96347 387899 387542 407783 460451 526219 758299 744597 96393 381838 467758 43271 381924 395564 407444 443903 407180 483375 448368 504176 663428 645241 637718 412299 484568 478252 422353 484750 479149 384373 395258 382003 408424 407194 424841 447808 663466 667643 667899 665379 557192 790962 748247 770124 770133 781447 794803 807722 397830 408000 401820 479092 827416 663946 784442 397361 406282 563449 567959 603692 512347 486255 484739 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (2.19%) |
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 3973 43271 96347 96393 193666 381838 381924 382003 382862 384373 387542 387899 391202 391922 392820 395228 395258 395564 395719 397361 397830 400128 400151 401820 406282 407180 407194 407444 407783 407884 408000 408424 412299 414313 422353 424841 443903 447808 448368 460451 462324 466069 467758 478252 479092 479149 482317 483375 484568 484672 484739 484750 486255 486445 486516 492689 502249 504176 512347 514589 518553 522605 525691 526219 526693 530140 540957 543950 547952 549233 550209 557192 563449 567959 571154 603692 629796 629818 637718 645241 645879 663428 663466 663946 665379 667486 667643 667899 668174 670514 674681 688674 712823 715563 718836 726427 727917 729214 731784 739547 739687 744597 748247 758299 770124 770133 770143 781447 784442 790962 794803 800342 802651 803656 805122 805403 807722 808873 816259 827416 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mature threesome"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mature секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mature секс втро"
]
|
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.