Query Metrics
7
Database Queries
7
Different statements
162.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.58 ms (85.73%) |
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 32678 381424 383373 387177 388653 390810 396048 404172 424353 424756 429016 441818 446343 447304 451275 452422 452429 453709 455009 455403 455554 456311 457664 459881 460484 461666 461677 462613 462620 463147 463242 465027 465288 469269 470123 471142 472085 475839 477364 477796 478005 478490 479531 480328 481008 481073 483490 484295 488294 492230 492674 495598 495685 496504 497681 499629 499963 501520 504240 504428 506973 507113 507420 508184 508188 508217 509209 510060 510229 510230 510500 510773 512636 514094 516697 520699 521834 522296 522299 522491 522947 523735 523783 523935 524098 524395 525349 525926 525939 526451 526684 526770 526852 527305 527368 528460 533275 533956 536430 539155 540548 540717 543223 543275 560858 568930 570297 573624 575507 586121 587959 588378 595357 595836 624986 650867 651373 652219 786465 819899 ] |
||||||||||||||||||||||||||||||
|
14.03 ms (8.62%) |
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 470123 456311 462613 455554 472085 508188 510230 516697 523935 526451 526684 526770 484295 504240 504428 522296 522491 528460 496504 510500 522947 523783 527305 495685 501520 507420 520699 524395 510060 536430 650867 586121 819899 786465 560858 383373 424353 459881 510229 424756 540717 524098 543223 539155 570297 651373 533956 525926 595357 525349 652219 624986 388653 387177 390810 453709 465288 479531 488294 446343 451275 452422 452429 457664 463147 471142 478005 477364 495598 507113 508217 509209 523735 525939 497681 510773 522299 506973 527368 540548 499629 508184 514094 521834 526852 533275 463242 465027 481073 483490 568930 575507 543275 573624 587959 588378 595836 381424 429016 462620 469269 478490 404172 455009 460484 477796 32678 447304 455403 480328 396048 441818 461666 461677 475839 481008 499963 512636 492230 492674 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.74%) |
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 32678 381424 383373 387177 388653 390810 396048 404172 424353 424756 429016 441818 446343 447304 451275 452422 452429 453709 455009 455403 455554 456311 457664 459881 460484 461666 461677 462613 462620 463147 463242 465027 465288 469269 470123 471142 472085 475839 477364 477796 478005 478490 479531 480328 481008 481073 483490 484295 488294 492230 492674 495598 495685 496504 497681 499629 499963 501520 504240 504428 506973 507113 507420 508184 508188 508217 509209 510060 510229 510230 510500 510773 512636 514094 516697 520699 521834 522296 522299 522491 522947 523735 523783 523935 524098 524395 525349 525926 525939 526451 526684 526770 526852 527305 527368 528460 533275 533956 536430 539155 540548 540717 543223 543275 560858 568930 570297 573624 575507 586121 587959 588378 595357 595836 624986 650867 651373 652219 786465 819899 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding big dick"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.