Query Metrics
7
Database Queries
7
Different statements
158.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.57 ms (83.47%) |
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 2208 193874 233395 365901 382937 383241 388570 390427 391579 391967 392672 395914 398931 403315 403317 411187 419521 420585 421603 422354 424462 424481 443772 443785 443815 448708 451457 451485 453100 454265 459748 460599 460912 461989 462714 462720 465358 465371 465958 465970 466025 466067 466120 466133 466145 466180 466195 466244 466318 466380 466778 466942 467026 470190 470272 470514 470615 470765 470956 471073 475903 475911 476628 476987 477955 477975 478546 479025 479133 479522 481915 482323 484469 484589 484611 484657 485595 489207 490307 490877 490881 490897 490901 490902 490913 490919 490921 490929 491442 491969 491991 495465 502712 505017 512433 513260 515838 521201 523031 539460 546716 546767 546951 551602 555074 560380 560396 560474 563063 563217 563444 590503 616940 644688 663254 742272 742329 744184 809782 816997 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (9.98%) |
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 484589 515838 470514 563444 398931 465358 490913 490877 2208 477975 616940 411187 490921 388570 443815 555074 382937 403317 809782 491969 482323 489207 479522 466145 551602 742329 495465 470190 484657 470956 466244 443785 365901 505017 560396 392672 467026 466120 419521 451485 383241 466195 521201 470615 477955 424481 462720 233395 470272 475903 546951 391967 465958 466778 459748 490881 490929 422354 546716 563217 391579 466942 466067 460599 403315 744184 424462 420585 742272 461989 663254 390427 491991 490919 563063 476628 546767 465970 481915 453100 484469 466318 560474 454265 490307 479025 816997 560380 462714 471073 443772 590503 491442 490901 479133 539460 513260 475911 465371 502712 466180 466380 512433 448708 460912 490897 644688 466133 451457 470765 476987 490902 523031 193874 478546 485595 421603 395914 484611 466025 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.94%) |
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 2208 193874 233395 365901 382937 383241 388570 390427 391579 391967 392672 395914 398931 403315 403317 411187 419521 420585 421603 422354 424462 424481 443772 443785 443815 448708 451457 451485 453100 454265 459748 460599 460912 461989 462714 462720 465358 465371 465958 465970 466025 466067 466120 466133 466145 466180 466195 466244 466318 466380 466778 466942 467026 470190 470272 470514 470615 470765 470956 471073 475903 475911 476628 476987 477955 477975 478546 479025 479133 479522 481915 482323 484469 484589 484611 484657 485595 489207 490307 490877 490881 490897 490901 490902 490913 490919 490921 490929 491442 491969 491991 495465 502712 505017 512433 513260 515838 521201 523031 539460 546716 546767 546951 551602 555074 560380 560396 560474 563063 563217 563444 590503 616940 644688 663254 742272 742329 744184 809782 816997 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамка куни русское"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин куннилингус оральн секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.98%) |
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.