Query Metrics
7
Database Queries
7
Different statements
186.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.70 ms (85.14%) |
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 382154 383390 400151 407320 414200 416123 416241 422243 425545 427094 429360 435213 435502 436542 439650 440664 441022 445728 445733 448280 449752 449761 452593 454633 455064 455876 456291 459656 461375 462362 462854 467721 469200 473729 473790 477853 479003 479685 480644 484279 485591 486366 486574 486957 486986 487346 492455 492711 493266 493809 494672 495544 495901 496553 499657 500976 503488 503754 507697 507812 508487 509993 514997 516793 517305 519795 520229 521412 522235 522475 527017 527270 528386 529710 530762 535057 536819 545848 552348 552411 552632 552849 555798 558562 558828 560520 560852 564056 564162 564493 564825 575503 575755 576286 576370 577670 577889 580672 583448 596411 598190 599002 603110 608261 609604 619917 625181 627699 630552 633853 634505 643013 647330 667975 675000 680953 721393 763587 766274 790213 ] |
||||||||||||||||||||||||||||||
|
17.66 ms (9.47%) |
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 422243 427094 473729 439650 462854 383390 425545 454633 455876 416123 455064 456291 536819 486574 503488 507812 493266 522235 486986 527017 555798 530762 583448 529710 445733 535057 495544 499657 494672 552348 552849 560852 564493 599002 608261 643013 435502 469200 452593 500976 517305 486366 519795 527270 675000 603110 630552 576286 508487 560520 441022 467721 485591 492455 461375 514997 521412 436542 440664 449752 462362 484279 477853 495901 480644 545848 575503 575755 552411 576370 580672 552632 558562 564056 647330 558828 577889 619917 633853 625181 627699 596411 634505 763587 766274 721393 790213 407320 416241 429360 479685 516793 486957 448280 507697 528386 479003 577670 667975 598190 609604 435213 493809 564825 564162 382154 400151 414200 680953 449761 459656 492711 445728 487346 473790 496553 503754 509993 520229 522475 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.59%) |
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 382154 383390 400151 407320 414200 416123 416241 422243 425545 427094 429360 435213 435502 436542 439650 440664 441022 445728 445733 448280 449752 449761 452593 454633 455064 455876 456291 459656 461375 462362 462854 467721 469200 473729 473790 477853 479003 479685 480644 484279 485591 486366 486574 486957 486986 487346 492455 492711 493266 493809 494672 495544 495901 496553 499657 500976 503488 503754 507697 507812 508487 509993 514997 516793 517305 519795 520229 521412 522235 522475 527017 527270 528386 529710 530762 535057 536819 545848 552348 552411 552632 552849 555798 558562 558828 560520 560852 564056 564162 564493 564825 575503 575755 576286 576370 577670 577889 580672 583448 596411 598190 599002 603110 608261 609604 619917 625181 627699 630552 633853 634505 643013 647330 667975 675000 680953 721393 763587 766274 790213 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass licking cum"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп лиза cum"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп лиза cum"
]
|
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.