Query Metrics
7
Database Queries
7
Different statements
187.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.15 ms (84.95%) |
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 381875 417123 423637 426211 442651 443264 444508 449293 449303 449323 450125 452556 453972 454557 456156 457766 473035 474384 479222 489316 496108 499552 500683 500690 504974 508268 516490 516493 516501 521697 522277 526972 538017 556704 557113 559412 585968 593466 598139 603074 604637 608398 614843 621289 621457 624845 627206 628515 628669 636550 636554 643071 660454 663754 680378 680587 689523 699518 702311 703511 705101 708830 718891 723726 725289 726320 727256 728903 728905 729641 730507 731397 736106 738803 738809 738911 739074 739896 740815 744151 751222 751252 756640 757006 757089 757234 757276 757290 758961 760624 760629 761913 772559 773019 775464 783928 784954 785287 792025 793633 793878 793885 795024 800029 801993 802231 804943 805259 805400 807464 809583 810369 812082 812157 823443 823732 823911 824339 824852 827330 ] |
||||||||||||||||||||||||||||||
|
17.38 ms (9.28%) |
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 728905 760624 757290 812082 824339 809583 736106 725289 500683 474384 423637 775464 449303 756640 680378 689523 772559 810369 738809 739896 738803 758961 751222 823443 827330 805400 757006 738911 812157 426211 449323 557113 624845 760629 805259 516501 824852 538017 450125 636554 680587 785287 793633 795024 802231 729641 783928 801993 773019 757089 627206 636550 793878 793885 453972 823732 823911 508268 522277 504974 556704 621457 628515 516493 454557 699518 718891 708830 660454 621289 643071 604637 608398 792025 800029 731397 739074 744151 740815 804943 726320 500690 559412 444508 479222 496108 381875 417123 443264 456156 663754 705101 723726 757276 761913 751252 702311 807464 521697 593466 516490 449293 452556 489316 585968 598139 603074 628669 614843 784954 757234 728903 730507 727256 703511 526972 499552 473035 442651 457766 ] |
||||||||||||||||||||||||||||||
|
4.23 ms (2.26%) |
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 381875 417123 423637 426211 442651 443264 444508 449293 449303 449323 450125 452556 453972 454557 456156 457766 473035 474384 479222 489316 496108 499552 500683 500690 504974 508268 516490 516493 516501 521697 522277 526972 538017 556704 557113 559412 585968 593466 598139 603074 604637 608398 614843 621289 621457 624845 627206 628515 628669 636550 636554 643071 660454 663754 680378 680587 689523 699518 702311 703511 705101 708830 718891 723726 725289 726320 727256 728903 728905 729641 730507 731397 736106 738803 738809 738911 739074 739896 740815 744151 751222 751252 756640 757006 757089 757234 757276 757290 758961 760624 760629 761913 772559 773019 775464 783928 784954 785287 792025 793633 793878 793885 795024 800029 801993 802231 804943 805259 805400 807464 809583 810369 812082 812157 823443 823732 823911 824339 824852 827330 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair pussy compilation"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair pussy подборк"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair pussy подборк"
]
|
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.