Query Metrics
7
Database Queries
7
Different statements
389.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.51 ms (53.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс красивая русск"
]
|
||||||||||||||||||||||||||||||
|
150.37 ms (38.59%) |
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 16691 382827 384546 389593 391491 398711 402693 402877 404211 405242 417949 417950 417957 418459 418885 423520 425725 433910 435414 435806 444581 444605 447224 447496 447532 449825 455093 457798 458744 461476 461984 462039 462040 462240 462515 462539 462797 463180 464909 466034 466435 469332 469725 470004 470509 476532 481158 481281 481321 482221 482258 486193 489371 491090 491192 491379 496910 497270 498101 501658 502047 503636 505220 505364 507968 508120 516108 524576 540918 546001 547753 552624 552856 557041 560530 561912 562236 563102 565430 566759 567219 567254 567538 573955 575808 586733 587191 590223 595402 597553 597995 599567 605824 629013 652978 654464 660910 670815 676517 679351 688544 703577 721849 722764 722853 728287 733787 751228 762219 762258 775063 777961 778363 779328 783206 785889 789926 790268 804871 825752 ] |
||||||||||||||||||||||||||||||
|
20.82 ms (5.34%) |
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 777961 384546 783206 563102 469332 463180 433910 461984 449825 491379 524576 491192 462539 605824 417949 721849 688544 481281 567219 762258 762219 728287 464909 508120 552856 547753 590223 629013 455093 462040 466435 404211 482258 660910 785889 733787 751228 402693 469725 595402 466034 507968 679351 722764 444605 505220 567538 573955 561912 557041 417957 435806 505364 389593 587191 16691 405242 546001 789926 804871 722853 540918 418459 457798 778363 779328 444581 825752 498101 790268 458744 461476 481158 382827 447224 486193 447532 597553 566759 423520 503636 476532 482221 502047 703577 565430 567254 586733 398711 402877 435414 470004 575808 501658 496910 391491 652978 462240 670815 562236 462039 560530 447496 462797 481321 516108 418885 599567 491090 417950 654464 497270 425725 470509 775063 597995 489371 462515 676517 552624 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (0.89%) |
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 16691 382827 384546 389593 391491 398711 402693 402877 404211 405242 417949 417950 417957 418459 418885 423520 425725 433910 435414 435806 444581 444605 447224 447496 447532 449825 455093 457798 458744 461476 461984 462039 462040 462240 462515 462539 462797 463180 464909 466034 466435 469332 469725 470004 470509 476532 481158 481281 481321 482221 482258 486193 489371 491090 491192 491379 496910 497270 498101 501658 502047 503636 505220 505364 507968 508120 516108 524576 540918 546001 547753 552624 552856 557041 560530 561912 562236 563102 565430 566759 567219 567254 567538 573955 575808 586733 587191 590223 595402 597553 597995 599567 605824 629013 652978 654464 660910 670815 676517 679351 688544 703577 721849 722764 722853 728287 733787 751228 762219 762258 775063 777961 778363 779328 783206 785889 789926 790268 804871 825752 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет красотки русски…"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.