Query Metrics
7
Database Queries
7
Different statements
146.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.94 ms (82.78%) |
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 391221 395233 400181 410518 415265 416255 418646 421181 421207 421238 425340 425401 425545 426152 427187 428933 429004 437610 438684 438916 442691 443973 443990 450025 451826 452493 454032 456268 458935 459378 465186 465307 466471 466772 468703 470344 472751 473807 474914 475704 477625 479191 486134 488929 489819 493493 495401 496066 501203 502191 504418 504492 505547 507310 507312 509324 511505 513193 515897 515901 518232 518636 520464 523100 523329 524248 524533 525448 525454 526147 527218 528380 531480 532779 533333 543814 550195 550608 551223 555847 555885 558572 562953 564010 572295 575189 578451 584504 587311 587329 591748 591783 593835 599339 599966 605420 610928 622229 639710 648814 649578 654338 654352 666540 666883 669281 697170 709896 727434 728194 728956 739749 741294 747955 756247 785731 803309 807419 807687 820775 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (11.16%) |
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 524248 525448 526147 511505 525454 416255 415265 524533 489819 518636 550195 610928 785731 391221 562953 558572 649578 666883 727434 739749 425401 437610 425340 820775 458935 454032 468703 493493 533333 501203 555885 550608 575189 564010 648814 654338 555847 599339 639710 741294 429004 472751 425545 395233 438916 438684 515897 518232 528380 486134 496066 523100 421181 442691 450025 473807 507312 475704 551223 587311 669281 697170 584504 807419 747955 709896 803309 421207 426152 428933 410518 459378 523329 531480 543814 578451 807687 456268 479191 474914 477625 400181 443973 421238 427187 452493 465186 515901 513193 502191 505547 509324 504492 520464 622229 572295 591748 605420 587329 728956 756247 418646 466471 599966 527218 654352 443990 451826 465307 488929 507310 532779 504418 666540 593835 591783 728194 466772 470344 495401 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.79%) |
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 391221 395233 400181 410518 415265 416255 418646 421181 421207 421238 425340 425401 425545 426152 427187 428933 429004 437610 438684 438916 442691 443973 443990 450025 451826 452493 454032 456268 458935 459378 465186 465307 466471 466772 468703 470344 472751 473807 474914 475704 477625 479191 486134 488929 489819 493493 495401 496066 501203 502191 504418 504492 505547 507310 507312 509324 511505 513193 515897 515901 518232 518636 520464 523100 523329 524248 524533 525448 525454 526147 527218 528380 531480 532779 533333 543814 550195 550608 551223 555847 555885 558572 562953 564010 572295 575189 578451 584504 587311 587329 591748 591783 593835 599339 599966 605420 610928 622229 639710 648814 649578 654338 654352 666540 666883 669281 697170 709896 727434 728194 728956 739749 741294 747955 756247 785731 803309 807419 807687 820775 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small pussy creampie"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая pussy creampie"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая pussy creampie"
]
|
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.