Query Metrics
7
Database Queries
7
Different statements
205.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.61 ms (83.51%) |
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 282430 400728 417564 418879 419092 423782 424186 426144 433397 434808 436235 437239 441297 444926 445784 447202 448647 449677 451139 452182 452575 454336 454355 459318 459485 461654 463651 464586 465762 466748 470167 473784 476935 480523 482124 483510 483517 484477 485549 487716 490250 491171 491666 491930 491936 494014 496795 498643 501227 502173 504321 504875 506732 508864 511216 511243 512736 514411 515818 517924 517941 518095 518343 519133 520344 521329 521901 521919 523435 523934 523964 523967 524103 524913 525577 525839 526609 527656 527770 528055 528161 528653 538193 541057 546483 547617 547889 551250 551582 552574 553678 554173 557242 558704 559722 563652 568064 570104 575470 575784 579617 581468 587258 594088 595868 599234 602847 620597 621982 624162 624999 636428 643488 652219 663172 673510 714447 766872 773474 805286 ] |
||||||||||||||||||||||||||||||
|
22.95 ms (11.17%) |
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 581468 602847 621982 599234 624162 636428 643488 587258 594088 595868 624999 805286 773474 766872 620597 419092 448647 454355 470167 480523 400728 423782 424186 445784 447202 454336 459318 476935 482124 282430 437239 461654 465762 473784 444926 463651 417564 441297 451139 459485 464586 504875 508864 511216 517924 523435 526609 527656 527770 528161 483517 490250 491171 504321 506732 511243 523934 523964 523967 525839 483510 491936 494014 496795 514411 518095 520344 521919 524913 525577 538193 487716 491666 498643 502173 512736 517941 519133 521329 524103 528653 541057 570104 418879 433397 436235 452575 426144 466748 434808 452182 449677 484477 485549 518343 491930 501227 515818 521901 528055 551250 553678 557242 559722 563652 568064 546483 547889 552574 558704 575470 551582 554173 575784 579617 652219 673510 714447 663172 547617 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (1.73%) |
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 282430 400728 417564 418879 419092 423782 424186 426144 433397 434808 436235 437239 441297 444926 445784 447202 448647 449677 451139 452182 452575 454336 454355 459318 459485 461654 463651 464586 465762 466748 470167 473784 476935 480523 482124 483510 483517 484477 485549 487716 490250 491171 491666 491930 491936 494014 496795 498643 501227 502173 504321 504875 506732 508864 511216 511243 512736 514411 515818 517924 517941 518095 518343 519133 520344 521329 521901 521919 523435 523934 523964 523967 524103 524913 525577 525839 526609 527656 527770 528055 528161 528653 538193 541057 546483 547617 547889 551250 551582 552574 553678 554173 557242 558704 559722 563652 568064 570104 575470 575784 579617 581468 587258 594088 595868 599234 602847 620597 621982 624162 624999 636428 643488 652219 663172 673510 714447 766872 773474 805286 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girlfriend russian"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"girlfriend русск"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"girlfriend русск"
]
|
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.