Query Metrics
7
Database Queries
7
Different statements
186.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.16 ms (85.76%) |
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 387539 391756 397186 398973 412159 428039 429567 429708 438560 441609 441770 446022 447025 452940 452963 455530 456007 456298 460913 461814 464214 464659 468353 468367 470835 471179 475127 475752 487416 492176 493223 499587 504664 508996 510879 513811 536441 538703 570972 600265 618468 627358 629205 698224 706560 708161 714630 725556 726175 726235 726258 728687 729272 729285 731095 731274 732809 734308 734328 734471 734970 735917 738718 740878 742534 742562 742748 759950 761196 761469 761593 765060 765634 765652 765789 767973 768328 769132 769388 773268 773424 773686 777953 778424 778643 783372 785196 788985 791216 791561 791594 791860 792946 794364 794366 794385 794759 794773 794896 795276 795297 795680 795956 796156 797284 798731 798787 799718 800398 800431 800439 802948 804555 804559 805231 810084 810407 824066 ] |
||||||||||||||||||||||||||||||
|
18.02 ms (9.65%) |
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 791216 791594 794366 797284 798731 798787 799718 804555 777953 794309 794385 795680 800439 804559 805231 725556 729272 731274 734328 761196 761593 769388 783372 785196 791561 792946 794364 795297 796156 726235 729285 731095 734308 767973 768328 773268 726258 732809 734471 773424 773686 735917 740878 742748 765634 771983 726175 734970 738718 742534 742562 765060 765652 765789 627358 629205 778424 778643 788985 791860 794773 794896 795956 800398 800431 810084 810407 397186 475127 438560 824066 728687 600265 536441 714630 456298 504664 391756 398973 492176 464214 493223 510879 468367 570972 708161 618468 794759 759950 761469 706560 468353 428039 460913 461814 487416 387539 429567 471179 513811 508996 769132 802948 698224 795276 429708 456007 464659 538703 499587 475752 446022 452963 452940 447025 455530 470835 412159 441770 441609 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.39%) |
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 387539 391756 397186 398973 412159 428039 429567 429708 438560 441609 441770 446022 447025 452940 452963 455530 456007 456298 460913 461814 464214 464659 468353 468367 470835 471179 475127 475752 487416 492176 493223 499587 504664 508996 510879 513811 536441 538703 570972 600265 618468 627358 629205 698224 706560 708161 714630 725556 726175 726235 726258 728687 729272 729285 731095 731274 732809 734308 734328 734471 734970 735917 738718 740878 742534 742562 742748 759950 761196 761469 761593 765060 765634 765652 765789 767973 768328 769132 769388 773268 773424 773686 777953 778424 778643 783372 785196 788985 791216 791561 791594 791860 792946 794364 794366 794385 794759 794773 794896 795276 795297 795680 795956 796156 797284 798731 798787 799718 800398 800431 800439 802948 804555 804559 805231 810084 810407 824066 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam mother"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.68%) |
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.