Query Metrics
7
Database Queries
7
Different statements
270.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
244.64 ms (90.43%) |
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 389602 411488 413004 413277 415546 415556 415557 415579 423663 423780 426399 426478 426480 426481 429931 431691 432692 443532 444288 450255 450287 452427 454755 455943 455945 456190 458007 458678 461805 461989 464266 469737 470050 470089 470535 471088 471113 471620 471969 475407 475488 475593 475876 476428 478947 479148 480226 481772 495172 495179 495489 499587 500221 500508 506429 506813 507514 508200 510546 512512 513408 516329 516772 518159 521172 522689 523903 524613 526877 528524 529988 530943 545909 548756 549800 550507 553545 557978 558172 567063 569050 570952 573805 576776 577392 580359 582444 584887 586009 591106 599987 600341 601101 602186 603002 603735 615721 620756 647940 660834 670750 707692 707706 748227 766864 781857 782516 787120 803046 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (5.85%) |
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 591106 787120 766864 781857 456190 470050 479148 426478 411488 423780 452427 454755 471969 475593 475876 495172 506813 522689 557978 548756 444288 415556 495179 389602 426480 423663 432692 426481 450287 458678 469737 500508 499587 510546 528524 470535 569050 576776 580359 567063 670750 549800 570952 600341 615721 620756 603735 803046 413004 471620 478947 431691 471113 475488 461989 450255 526877 508200 518159 495489 475407 481772 512512 513408 530943 480226 545909 558172 582444 647940 707706 602186 748227 429931 458007 470089 413277 461805 415579 415557 443532 455945 500221 529988 707692 660834 553545 586009 782516 524613 550507 521172 455943 516329 516772 471088 426399 476428 415546 523903 464266 577392 507514 603002 584887 599987 506429 601101 573805 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (0.99%) |
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 389602 411488 413004 413277 415546 415556 415557 415579 423663 423780 426399 426478 426480 426481 429931 431691 432692 443532 444288 450255 450287 452427 454755 455943 455945 456190 458007 458678 461805 461989 464266 469737 470050 470089 470535 471088 471113 471620 471969 475407 475488 475593 475876 476428 478947 479148 480226 481772 495172 495179 495489 499587 500221 500508 506429 506813 507514 508200 510546 512512 513408 516329 516772 518159 521172 522689 523903 524613 526877 528524 529988 530943 545909 548756 549800 550507 553545 557978 558172 567063 569050 570952 573805 576776 577392 580359 582444 584887 586009 591106 599987 600341 601101 602186 603002 603735 615721 620756 647940 660834 670750 707692 707706 748227 766864 781857 782516 787120 803046 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cam wife"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cam жен"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cam жен"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.60%) |
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.