Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "anal cute girl"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal cute girl' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  650158
  487713
  788525
  506619
  672711
  748530
  762213
  617412
  527975
  576020
  447888
  492067
  485234
  576951
  609873
  417683
  585826
  468010
  420559
  589979
  518206
  628363
  560669
  434353
  508430
  609083
  629673
  577365
  494695
  785267
  506195
  420472
  756840
  515862
  459535
  617023
  431448
  498474
  401414
  519563
  596168
  462372
  670197
  524979
  538963
  537685
  647333
  639009
  515545
  680100
  636869
  501655
  602268
  525686
  461316
  651933
  601922
  453337
  630221
  758540
  751418
  79082
  537672
  537670
  603102
  456518
  635900
  214988
  620100
  505279
  602444
  577896
  458870
  675007
  547615
  600387
  415926
  598795
  649185
  666717
  550618
  604743
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (650158, 487713, 788525, 506619, 672711, 748530, 762213, 617412, 527975, 576020, 447888, 492067, 485234, 576951, 609873, 417683, 585826, 468010, 420559, 589979, 518206, 628363, 560669, 434353, 508430, 609083, 629673, 577365, 494695, 785267, 506195, 420472, 756840, 515862, 459535, 617023, 431448, 498474, 401414, 519563, 596168, 462372, 670197, 524979, 538963, 537685, 647333, 639009, 515545, 680100, 636869, 501655, 602268, 525686, 461316, 651933, 601922, 453337, 630221, 758540, 751418, 79082, 537672, 537670, 603102, 456518, 635900, 214988, 620100, 505279, 602444, 577896, 458870, 675007, 547615, 600387, 415926, 598795, 649185, 666717, 550618, 604743);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  79082
  214988
  401414
  415926
  417683
  420472
  420559
  431448
  434353
  447888
  453337
  456518
  458870
  459535
  461316
  462372
  468010
  485234
  487713
  492067
  494695
  498474
  501655
  505279
  506195
  506619
  508430
  515545
  515862
  518206
  519563
  524979
  525686
  527975
  537670
  537672
  537685
  538963
  547615
  550618
  560669
  576020
  576951
  577365
  577896
  585826
  589979
  596168
  598795
  600387
  601922
  602268
  602444
  603102
  604743
  609083
  609873
  617023
  617412
  620100
  628363
  629673
  630221
  635900
  636869
  639009
  647333
  649185
  650158
  651933
  666717
  670197
  672711
  675007
  680100
  748530
  751418
  756840
  758540
  762213
  785267
  788525
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (79082, 214988, 401414, 415926, 417683, 420472, 420559, 431448, 434353, 447888, 453337, 456518, 458870, 459535, 461316, 462372, 468010, 485234, 487713, 492067, 494695, 498474, 501655, 505279, 506195, 506619, 508430, 515545, 515862, 518206, 519563, 524979, 525686, 527975, 537670, 537672, 537685, 538963, 547615, 550618, 560669, 576020, 576951, 577365, 577896, 585826, 589979, 596168, 598795, 600387, 601922, 602268, 602444, 603102, 604743, 609083, 609873, 617023, 617412, 620100, 628363, 629673, 630221, 635900, 636869, 639009, 647333, 649185, 650158, 651933, 666717, 670197, 672711, 675007, 680100, 748530, 751418, 756840, 758540, 762213, 785267, 788525);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  79082
  214988
  401414
  415926
  417683
  420472
  420559
  431448
  434353
  447888
  453337
  456518
  458870
  459535
  461316
  462372
  468010
  485234
  487713
  492067
  494695
  498474
  501655
  505279
  506195
  506619
  508430
  515545
  515862
  518206
  519563
  524979
  525686
  527975
  537670
  537672
  537685
  538963
  547615
  550618
  560669
  576020
  576951
  577365
  577896
  585826
  589979
  596168
  598795
  600387
  601922
  602268
  602444
  603102
  604743
  609083
  609873
  617023
  617412
  620100
  628363
  629673
  630221
  635900
  636869
  639009
  647333
  649185
  650158
  651933
  666717
  670197
  672711
  675007
  680100
  748530
  751418
  756840
  758540
  762213
  785267
  788525
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (79082, 214988, 401414, 415926, 417683, 420472, 420559, 431448, 434353, 447888, 453337, 456518, 458870, 459535, 461316, 462372, 468010, 485234, 487713, 492067, 494695, 498474, 501655, 505279, 506195, 506619, 508430, 515545, 515862, 518206, 519563, 524979, 525686, 527975, 537670, 537672, 537685, 538963, 547615, 550618, 560669, 576020, 576951, 577365, 577896, 585826, 589979, 596168, 598795, 600387, 601922, 602268, 602444, 603102, 604743, 609083, 609873, 617023, 617412, 620100, 628363, 629673, 630221, 635900, 636869, 639009, 647333, 649185, 650158, 651933, 666717, 670197, 672711, 675007, 680100, 748530, 751418, 756840, 758540, 762213, 785267, 788525);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "анал cute девушк"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал cute девушк';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "анал cute девушк"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал cute девушк';