Query Metrics
7
Database Queries
7
Different statements
226.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.55 ms (87.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 6698 16646 28591 46788 163149 208177 210072 260297 285846 382450 383244 387186 393016 398325 399697 400421 416311 420377 430822 431205 438562 441181 442131 446954 447485 451611 453652 458744 461575 473931 475899 478343 481276 484849 491084 491767 501770 503822 507405 507877 510642 511747 512252 518995 521342 521861 521876 522539 527737 528373 530328 538432 538996 545710 552184 552192 552695 554265 559083 560562 560653 562319 567738 567835 570380 570418 570478 570505 570626 571572 571620 571913 572121 572124 572142 572501 572798 572801 572822 573095 573688 573789 574490 574825 574920 575080 575100 575503 575769 576072 576098 576293 576405 580772 584436 614518 628081 659105 665515 669771 670258 676914 692028 701296 713216 722537 724726 726962 730735 735002 740205 741481 741652 743328 747568 769750 775571 805012 807144 823792 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (7.57%) |
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 775571 807144 726962 387186 285846 475899 163149 393016 46788 16646 823792 713216 665515 670258 692028 628081 805012 743328 740205 741481 735002 208177 28591 451611 576098 545710 572798 575100 552695 575080 570505 572142 574490 481276 473931 501770 512252 521342 528373 521861 510642 552184 570380 572822 572801 571620 570478 572121 572501 769750 399697 420377 530328 491084 567835 669771 614518 730735 431205 478343 210072 260297 442131 491767 575503 571572 573688 574825 575769 576072 576293 560562 570418 570626 573789 574920 576405 584436 382450 416311 400421 430822 447485 461575 522539 511747 484849 507405 503822 507877 518995 6698 446954 453652 560653 562319 571913 573095 659105 676914 701296 722537 724726 747568 383244 398325 441181 458744 521876 527737 538432 741652 538996 572124 554265 580772 552192 438562 559083 567738 ] |
||||||||||||||||||||||||||||||
|
4.33 ms (1.91%) |
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 6698 16646 28591 46788 163149 208177 210072 260297 285846 382450 383244 387186 393016 398325 399697 400421 416311 420377 430822 431205 438562 441181 442131 446954 447485 451611 453652 458744 461575 473931 475899 478343 481276 484849 491084 491767 501770 503822 507405 507877 510642 511747 512252 518995 521342 521861 521876 522539 527737 528373 530328 538432 538996 545710 552184 552192 552695 554265 559083 560562 560653 562319 567738 567835 570380 570418 570478 570505 570626 571572 571620 571913 572121 572124 572142 572501 572798 572801 572822 573095 573688 573789 574490 574825 574920 575080 575100 575503 575769 576072 576098 576293 576405 580772 584436 614518 628081 659105 665515 669771 670258 676914 692028 701296 713216 722537 724726 726962 730735 735002 740205 741481 741652 743328 747568 769750 775571 805012 807144 823792 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен девушк kissing"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy girl kissing"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен девушк kissing"
]
|
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.