Query Metrics
7
Database Queries
7
Different statements
147.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.60 ms (81.50%) |
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 384501 432227 440736 442897 444329 445699 446418 447495 448034 450556 451307 451799 454355 454358 454363 455100 455105 455106 455107 455108 455114 456686 458045 458739 458742 459593 459655 460678 461428 461506 461516 461520 461526 461537 461540 461545 461549 461552 461566 461597 462056 462144 462805 462811 467161 467624 472334 472347 472351 472353 473591 473919 476213 476501 477121 477779 477828 478529 479220 482129 482697 483594 487025 487026 487069 487080 487086 487089 487090 488725 488831 491199 491652 491665 491667 492040 493359 494843 500497 500524 500926 505436 505438 508827 508872 508876 508881 510618 511703 511730 511738 511743 512239 512280 512293 512297 512321 512323 512335 512337 513891 515334 516161 517574 517587 520032 520500 522590 523127 524697 524706 524724 526135 526496 527623 527807 540530 574877 723050 733361 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (11.35%) |
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 455108 508876 512239 491652 491665 491667 515334 517587 505438 512280 461520 455105 472347 472353 512323 527623 487086 511730 491199 512297 487080 487089 508827 512337 527807 458045 461428 455106 473591 462056 513891 487026 512321 520032 384501 479220 505436 458742 476213 451307 467161 472334 459655 461537 461549 461552 462805 432227 440736 454363 455107 461516 461545 511743 522590 487090 500926 512335 517574 487025 494843 508872 508881 510618 488725 524724 450556 462144 520500 540530 723050 733361 493359 500497 492040 482697 451799 445699 477828 500524 467624 460678 462811 455100 461526 461566 461597 442897 444329 473919 478529 482129 459593 512293 516161 526496 487069 523127 524697 483594 477779 447495 476501 455114 526135 524706 472351 458739 477121 511703 511738 454358 448034 488831 574877 454355 461506 456686 446418 461540 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.81%) |
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 384501 432227 440736 442897 444329 445699 446418 447495 448034 450556 451307 451799 454355 454358 454363 455100 455105 455106 455107 455108 455114 456686 458045 458739 458742 459593 459655 460678 461428 461506 461516 461520 461526 461537 461540 461545 461549 461552 461566 461597 462056 462144 462805 462811 467161 467624 472334 472347 472351 472353 473591 473919 476213 476501 477121 477779 477828 478529 479220 482129 482697 483594 487025 487026 487069 487080 487086 487089 487090 488725 488831 491199 491652 491665 491667 492040 493359 494843 500497 500524 500926 505436 505438 508827 508872 508876 508881 510618 511703 511730 511738 511743 512239 512280 512293 512297 512321 512323 512335 512337 513891 515334 516161 517574 517587 520032 520500 522590 523127 524697 524706 524724 526135 526496 527623 527807 540530 574877 723050 733361 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white girls cuckold"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white девушк куколд"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white девушк куколд"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.12%) |
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.