Query Metrics
7
Database Queries
7
Different statements
165.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.11 ms (84.04%) |
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 383599 409846 419276 429026 437808 439142 439244 440994 441049 443335 446906 452548 452747 452825 460431 463824 467848 469755 472232 473412 474076 474805 476575 478510 479978 484023 486866 487157 487921 488769 495163 499288 502529 503712 504553 504662 505526 505591 507772 508353 510800 511828 514118 515994 516491 517418 517881 518175 518634 519359 519679 521150 526529 526534 527889 528567 528770 528779 532976 533289 533290 539857 541284 543499 545089 551816 555056 556496 559020 561275 562223 563595 566955 569450 573295 574015 586689 589972 592945 593994 594257 594623 600433 602168 602562 604790 608229 609057 617949 624204 624884 634894 641071 666115 669776 680576 701204 702352 703930 714319 716526 718062 736692 740754 753751 756768 756880 765828 769323 773257 775828 776085 778811 784644 784716 798757 807589 807599 809217 811271 ] |
||||||||||||||||||||||||||||||
|
16.59 ms (10.02%) |
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 608229 807589 784644 769323 703930 452747 437808 439142 504553 499288 510800 440994 474805 507772 528779 559020 666115 680576 701204 714319 716526 586689 594257 617949 641071 798757 776085 778811 809217 740754 756880 784716 736692 765828 775828 429026 487157 488769 609057 505591 505526 532976 555056 600433 604790 756768 528567 518634 508353 503712 519359 602562 441049 551816 593994 383599 443335 463824 472232 528770 539857 460431 589972 594623 624884 773257 439244 514118 517881 533289 561275 556496 543499 479978 469755 533290 526529 486866 541284 573295 563595 574015 545089 718062 669776 702352 634894 592945 807599 811271 753751 409846 452548 467848 452825 526534 502529 484023 504662 516491 566955 446906 476575 517418 518175 527889 473412 602168 474076 521150 569450 624204 495163 515994 519679 478510 562223 419276 511828 487921 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.48%) |
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 383599 409846 419276 429026 437808 439142 439244 440994 441049 443335 446906 452548 452747 452825 460431 463824 467848 469755 472232 473412 474076 474805 476575 478510 479978 484023 486866 487157 487921 488769 495163 499288 502529 503712 504553 504662 505526 505591 507772 508353 510800 511828 514118 515994 516491 517418 517881 518175 518634 519359 519679 521150 526529 526534 527889 528567 528770 528779 532976 533289 533290 539857 541284 543499 545089 551816 555056 556496 559020 561275 562223 563595 566955 569450 573295 574015 586689 589972 592945 593994 594257 594623 600433 602168 602562 604790 608229 609057 617949 624204 624884 634894 641071 666115 669776 680576 701204 702352 703930 714319 716526 718062 736692 740754 753751 756768 756880 765828 769323 773257 775828 776085 778811 784644 784716 798757 807589 807599 809217 811271 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fingering vagina"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fingering вагин"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fingering вагин"
]
|
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.