Query Metrics
7
Database Queries
7
Different statements
153.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.38 ms (82.39%) |
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 290847 385880 398112 401404 408433 410796 411917 424721 452963 454504 455080 456230 457639 460016 460908 464019 464550 464968 465536 465603 467085 467886 469133 469416 471012 472606 472698 473391 473426 473439 473740 474456 475676 476168 476318 476671 480676 483485 486772 490731 491225 491240 493254 499365 499551 504509 508292 513586 513629 513641 513654 514887 516120 517810 519309 519358 519359 519368 520910 521540 523583 528608 529989 530405 531787 532397 532806 533711 534533 534556 534644 535775 535818 536321 536462 536493 538721 539598 542762 544236 544791 545449 547462 547478 547807 549675 554489 555007 555020 555024 555048 555055 555062 555119 556341 556586 561015 570954 573188 573204 593586 599354 601744 605026 605133 605219 609959 615921 630078 633204 664593 694098 725492 760649 803046 816167 822930 824577 824766 ] |
||||||||||||||||||||||||||||||
|
16.78 ms (10.94%) |
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 398112 408433 465536 519309 499365 549675 601744 760649 290847 424721 455080 460016 473426 476168 456230 471012 476671 516120 528608 536462 472698 475676 547478 554489 555020 573204 547807 555055 556341 556586 573188 547462 555007 555024 555119 555048 555062 561015 599354 605133 605219 593586 633204 615921 630078 605026 725492 452963 467886 460908 473740 476318 480676 464550 519358 519368 499551 513629 520910 490731 493254 504509 513641 513654 517810 519359 570954 664593 714349 694098 609959 803046 473391 473439 385880 401404 411917 410796 824766 816167 822930 824577 454504 464968 467085 469133 472606 483485 457639 486772 491225 465603 469416 474456 491240 513586 530405 535775 539598 521540 523583 532806 533711 534644 536493 538721 534556 535818 536321 508292 514887 529989 531787 532397 534533 464019 542762 544236 544791 545449 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.04%) |
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 290847 385880 398112 401404 408433 410796 411917 424721 452963 454504 455080 456230 457639 460016 460908 464019 464550 464968 465536 465603 467085 467886 469133 469416 471012 472606 472698 473391 473426 473439 473740 474456 475676 476168 476318 476671 480676 483485 486772 490731 491225 491240 493254 499365 499551 504509 508292 513586 513629 513641 513654 514887 516120 517810 519309 519358 519359 519368 520910 521540 523583 528608 529989 530405 531787 532397 532806 533711 534533 534556 534644 535775 535818 536321 536462 536493 538721 539598 542762 544236 544791 545449 547462 547478 547807 549675 554489 555007 555020 555024 555048 555055 555062 555119 556341 556586 561015 570954 573188 573204 593586 599354 601744 605026 605133 605219 609959 615921 630078 633204 664593 694098 725492 760649 803046 816167 822930 824577 824766 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло milf mature"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo milf mature"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло milf mature"
]
|
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.