Query Metrics
7
Database Queries
7
Different statements
173.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.57 ms (82.33%) |
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 389966 390204 390642 391945 409083 412627 419523 419554 419835 422338 424416 425570 428884 434364 434371 435355 436942 439600 443184 443726 443760 443787 443804 443818 443998 444952 445395 452363 454002 454179 454542 458000 458278 460732 460751 462317 465367 465399 466195 466977 466995 467923 469283 470254 470514 470763 470835 471078 471771 471976 472001 473247 474226 474478 474635 475869 477968 477979 477989 479078 479079 481306 482533 484359 484413 484563 486974 490339 490648 491998 493083 493754 494231 494547 496995 497828 504629 506458 509179 509485 515258 518868 519739 520745 529509 543623 547610 549648 549771 553436 555982 587986 590425 596415 596796 621196 622801 630453 632949 651006 667021 700965 721502 722294 724641 725448 725484 740442 742760 752114 752950 760167 800707 800767 807336 810463 818045 819350 823368 824588 ] |
||||||||||||||||||||||||||||||
|
20.67 ms (11.93%) |
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 443726 484359 549771 443787 425570 435355 454002 497828 490339 482533 391945 465399 479079 479078 434371 443184 458000 470835 474478 486974 509179 443998 471771 509485 496995 494547 475869 543623 547610 424416 473247 444952 474226 439600 443818 477968 412627 491998 515258 390642 465367 490648 389966 462317 409083 419554 477989 469283 443760 390204 428884 466995 819350 529509 553436 721502 722294 622801 632949 630453 752114 740442 810463 484563 466195 474635 470763 434364 454179 422338 470514 587986 823368 472001 493754 518868 520745 555982 596796 621196 807336 445395 466977 467923 481306 419835 458278 477979 436942 506458 519739 493083 504629 470254 419523 471976 494231 818045 824588 549648 667021 651006 700965 596415 800767 725448 725484 752950 760167 724641 742760 800707 443804 471078 484413 590425 452363 454542 460732 460751 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.40%) |
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 389966 390204 390642 391945 409083 412627 419523 419554 419835 422338 424416 425570 428884 434364 434371 435355 436942 439600 443184 443726 443760 443787 443804 443818 443998 444952 445395 452363 454002 454179 454542 458000 458278 460732 460751 462317 465367 465399 466195 466977 466995 467923 469283 470254 470514 470763 470835 471078 471771 471976 472001 473247 474226 474478 474635 475869 477968 477979 477989 479078 479079 481306 482533 484359 484413 484563 486974 490339 490648 491998 493083 493754 494231 494547 496995 497828 504629 506458 509179 509485 515258 518868 519739 520745 529509 543623 547610 549648 549771 553436 555982 587986 590425 596415 596796 621196 622801 630453 632949 651006 667021 700965 721502 722294 724641 725448 725484 740442 742760 752114 752950 760167 800707 800767 807336 810463 818045 819350 823368 824588 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"волосатая русская женщина"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая русск женщин"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
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.