Query Metrics
7
Database Queries
7
Different statements
202.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.41 ms (85.56%) |
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 7015 389713 390218 390923 391255 391519 391929 422180 424120 424124 429954 444145 449700 462707 464563 467016 470585 471993 474194 476297 479073 479261 479387 481410 481747 482837 483205 484339 485619 490339 490648 493177 496009 497241 502861 504005 505546 506534 508253 516186 517121 525301 534709 536430 541068 543577 544075 544246 544619 546817 546972 547614 547952 552983 557402 563071 564932 565866 566980 568594 575854 576915 581475 582369 582724 588277 590246 597546 600936 601402 609584 613379 614499 616879 618303 622878 627103 663341 671707 672944 674615 678855 697196 709350 709482 725376 728371 728493 729453 731020 732577 733700 739089 740056 751609 755022 759121 759700 761743 762379 764161 764234 765023 766099 767228 767247 779607 780799 783004 786428 788380 788450 792223 804567 804935 806815 807577 808186 809852 ] |
||||||||||||||||||||||||||||||
|
17.99 ms (8.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 504005 508253 483205 544246 544075 557402 663341 674615 709482 616879 609584 618303 792223 806815 731020 761743 783004 804935 808186 728371 732577 759700 767247 764161 766099 740056 762379 764234 709350 779607 780799 786428 788450 809852 471993 464563 391255 391929 481410 496009 497241 490648 482837 546817 582369 581475 588277 424120 389713 462707 467016 479261 479387 474194 424124 449700 481747 516186 485619 490339 502861 536430 390218 391519 470585 444145 479073 552983 565866 796642 390923 506534 493177 429954 534709 7015 422180 476297 484339 505546 525301 517121 541068 544619 563071 568594 582724 546972 547952 543577 564932 566980 575854 672944 671707 678855 697196 547614 576915 590246 613379 622878 597546 601402 600936 614499 627103 788380 804567 807577 729453 733700 767228 765023 728493 755022 759121 725376 751609 739089 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.57%) |
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 7015 389713 390218 390923 391255 391519 391929 422180 424120 424124 429954 444145 449700 462707 464563 467016 470585 471993 474194 476297 479073 479261 479387 481410 481747 482837 483205 484339 485619 490339 490648 493177 496009 497241 502861 504005 505546 506534 508253 516186 517121 525301 534709 536430 541068 543577 544075 544246 544619 546817 546972 547614 547952 552983 557402 563071 564932 565866 566980 568594 575854 576915 581475 582369 582724 588277 590246 597546 600936 601402 609584 613379 614499 616879 618303 622878 627103 663341 671707 672944 674615 678855 697196 709350 709482 725376 728371 728493 729453 731020 732577 733700 739089 740056 751609 755022 759121 759700 761743 762379 764161 764234 765023 766099 767228 767247 779607 780799 783004 786428 788380 788450 792223 804567 804935 806815 807577 808186 809852 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск milf riding"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian milf riding"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск milf riding"
]
|
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.