Query Metrics
7
Database Queries
7
Different statements
166.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.93 ms (83.27%) |
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 261144 388856 395276 395805 396662 398909 399688 400931 401148 401621 407881 410393 415151 416056 418865 420259 425653 430783 431314 433302 436393 447516 449358 458438 459803 460226 465664 469487 469513 473148 475780 478652 479856 480415 483150 485125 486702 489871 491275 493221 496340 497881 498803 500339 504970 511500 512818 515511 517013 517932 518218 518504 519233 519268 519465 519548 519726 519962 522881 522923 525664 532746 533958 534990 535533 544120 550363 556950 557522 586644 586917 597834 599572 605337 609165 613432 619645 634546 642346 646279 646290 649108 650846 655295 656266 666869 674269 692049 697449 705277 712940 720117 725596 730759 750549 756103 765817 770901 775473 775858 777003 780659 783392 786094 787272 788119 794366 800344 801896 803046 806060 809421 809463 815704 816793 816985 817217 817330 818051 822121 ] |
||||||||||||||||||||||||||||||
|
18.28 ms (10.96%) |
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 646290 692049 599572 786094 496340 815704 818051 817330 822121 794366 655295 803046 532746 535533 515511 519465 534990 511500 550363 557522 646279 649108 666869 705277 712940 656266 619645 605337 642346 806060 775473 775858 809421 750549 783392 788119 809463 770901 756103 765817 613432 777003 787272 395805 401621 410393 469487 407881 420259 479856 396662 400931 401148 415151 430783 261144 418865 425653 431314 459803 465664 480415 519726 500339 518218 489871 512818 525664 504970 522923 817217 697449 730759 720117 433302 493221 517932 483150 816985 816793 800344 801896 725596 780659 609165 519962 650846 517013 634546 447516 458438 485125 469513 498803 544120 674269 556950 597834 586644 586917 388856 436393 399688 460226 395276 398909 449358 473148 478652 416056 475780 518504 519233 533958 486702 519268 522881 491275 497881 519548 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.66%) |
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 261144 388856 395276 395805 396662 398909 399688 400931 401148 401621 407881 410393 415151 416056 418865 420259 425653 430783 431314 433302 436393 447516 449358 458438 459803 460226 465664 469487 469513 473148 475780 478652 479856 480415 483150 485125 486702 489871 491275 493221 496340 497881 498803 500339 504970 511500 512818 515511 517013 517932 518218 518504 519233 519268 519465 519548 519726 519962 522881 522923 525664 532746 533958 534990 535533 544120 550363 556950 557522 586644 586917 597834 599572 605337 609165 613432 619645 634546 642346 646279 646290 649108 650846 655295 656266 666869 674269 692049 697449 705277 712940 720117 725596 730759 750549 756103 765817 770901 775473 775858 777003 780659 783392 786094 787272 788119 794366 800344 801896 803046 806060 809421 809463 815704 816793 816985 817217 817330 818051 822121 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.