Query Metrics
7
Database Queries
7
Different statements
206.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.93 ms (86.85%) |
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 157194 391934 401073 412419 414974 419245 421030 422028 423301 429810 434378 435502 438711 439361 443649 443653 443792 445739 452207 453866 454947 457070 457203 458183 460684 460693 461183 461416 462144 462289 462390 462564 465354 467214 467844 474425 475465 475473 479217 479292 479814 479835 483660 486583 493914 496613 501203 502106 502644 504831 505463 507865 510874 511171 511306 515061 516178 516276 516333 517012 517279 517565 517600 519650 520265 520485 523370 523480 523537 523908 525547 526216 527032 529381 531195 540071 546724 546824 547815 552127 555582 558314 564363 564902 567777 568193 568335 575607 576718 577096 577120 578790 581673 581734 584667 584791 586511 587918 589036 596966 599720 600256 606916 610661 615724 621348 623334 624110 637048 641901 644005 650992 656815 684213 721717 733347 743819 757638 770446 790878 ] |
||||||||||||||||||||||||||||||
|
17.80 ms (8.64%) |
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 419245 423301 438711 457203 452207 462390 467214 479217 475465 496613 510874 515061 517600 529381 507865 502106 511306 501203 517279 517565 526216 461183 564902 576718 546824 555582 558314 552127 575607 578790 584791 684213 656815 547815 586511 596966 599720 587918 637048 770446 733347 757638 790878 414974 439361 462289 467844 391934 401073 460684 462144 462564 479292 412419 516178 516276 527032 493914 525547 504831 505463 520265 483660 589036 465354 475473 486583 540071 650992 610661 458183 523537 577096 621348 422028 523908 443653 453866 454947 457070 460693 474425 516333 519650 523370 523480 511171 517012 531195 520485 461416 567777 581734 581673 546724 564363 568193 568335 577120 584667 721717 644005 600256 606916 615724 624110 743819 623334 641901 157194 435502 443649 445739 434378 429810 421030 479835 443792 479814 502644 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.30%) |
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 157194 391934 401073 412419 414974 419245 421030 422028 423301 429810 434378 435502 438711 439361 443649 443653 443792 445739 452207 453866 454947 457070 457203 458183 460684 460693 461183 461416 462144 462289 462390 462564 465354 467214 467844 474425 475465 475473 479217 479292 479814 479835 483660 486583 493914 496613 501203 502106 502644 504831 505463 507865 510874 511171 511306 515061 516178 516276 516333 517012 517279 517565 517600 519650 520265 520485 523370 523480 523537 523908 525547 526216 527032 529381 531195 540071 546724 546824 547815 552127 555582 558314 564363 564902 567777 568193 568335 575607 576718 577096 577120 578790 581673 581734 584667 584791 586511 587918 589036 596966 599720 600256 606916 610661 615724 621348 623334 624110 637048 641901 644005 650992 656815 684213 721717 733347 743819 757638 770446 790878 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband licking pussy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.14 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband лиза pussy"
]
|
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.