Query Metrics
7
Database Queries
7
Different statements
171.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.05 ms (84.18%) |
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 122425 383742 397128 403357 405367 405913 406954 407156 411182 419912 420106 420202 422500 422504 422595 422712 422953 422960 422997 423022 423199 423235 423412 428129 428451 431871 433229 433279 434759 435449 435629 443550 443600 446099 446258 446263 446648 447797 452513 453009 456005 456622 456634 456730 458518 458911 459316 463741 463748 464893 469542 471822 473763 476154 477404 478955 482824 485576 486620 486759 487864 491456 492805 494402 497467 499037 500565 500570 508485 509979 510622 511270 511271 511425 511489 512207 512680 513798 515891 518011 519769 520640 521177 521249 523540 525178 525208 527011 528777 529182 529854 530663 531156 532015 532249 532252 534776 534985 539299 539903 539938 540608 542294 542585 542587 542692 555950 558359 565481 583595 593405 641492 652125 709919 713642 720943 732219 748674 765559 799721 ] |
||||||||||||||||||||||||||||||
|
17.86 ms (10.44%) |
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 435629 456634 492805 534776 529182 469542 542294 799721 423022 423412 433279 511271 405367 422953 473763 512207 641492 397128 456622 446648 422960 515891 422997 478955 510622 531156 532015 532252 555950 542587 446258 122425 456005 500570 593405 720943 423199 447797 443600 497467 433229 459316 477404 422595 486759 527011 434759 521177 539299 709919 458911 463748 411182 443550 519769 530663 540608 534985 518011 456730 485576 565481 508485 407156 419912 511425 500565 583595 732219 512680 511489 652125 431871 521249 765559 748674 383742 403357 405913 422504 509979 476154 471822 523540 542692 486620 420202 446099 464893 453009 487864 525178 499037 463741 494402 528777 422712 422500 529854 539938 491456 446263 435449 539903 542585 713642 428451 482824 458518 423235 406954 420106 428129 511270 558359 513798 525208 520640 532249 452513 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.87%) |
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 122425 383742 397128 403357 405367 405913 406954 407156 411182 419912 420106 420202 422500 422504 422595 422712 422953 422960 422997 423022 423199 423235 423412 428129 428451 431871 433229 433279 434759 435449 435629 443550 443600 446099 446258 446263 446648 447797 452513 453009 456005 456622 456634 456730 458518 458911 459316 463741 463748 464893 469542 471822 473763 476154 477404 478955 482824 485576 486620 486759 487864 491456 492805 494402 497467 499037 500565 500570 508485 509979 510622 511270 511271 511425 511489 512207 512680 513798 515891 518011 519769 520640 521177 521249 523540 525178 525208 527011 528777 529182 529854 530663 531156 532015 532249 532252 534776 534985 539299 539903 539938 540608 542294 542585 542587 542692 555950 558359 565481 583595 593405 641492 652125 709919 713642 720943 732219 748674 765559 799721 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian fuck white"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк секс white"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк секс white"
]
|
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.