GET https://devb2b.webticari.net/?rest_route=%2Fwp%2Fv2%2Fusers%2F

Query Metrics

16 Database Queries
14 Different statements
6.81 ms Query time
0 Invalid entities
67 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.96 ms
(14.17%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.sortstatus AS sortstatus_2, c0_.row_count AS row_count_3, c0_.display_type AS display_type_4, p1_.id AS id_5, p1_.code AS code_6, p1_.equivalent_code AS equivalent_code_7, p1_.name AS name_8, p1_.meta_description AS meta_description_9, p1_.meta_title AS meta_title_10, p1_.meta_keywords AS meta_keywords_11, p1_.description AS description_12, p1_.seo AS seo_13, p1_.default_unit AS default_unit_14, p1_.quantity AS quantity_15, p1_.tax_rate AS tax_rate_16, p1_.image AS image_17, p1_.currency AS currency_18, p1_.ozelkod AS ozelkod_19, p1_.ozelkod2 AS ozelkod2_20, p1_.ozelkod3 AS ozelkod3_21, p1_.ozelkod4 AS ozelkod4_22, p1_.ozelkod5 AS ozelkod5_23, p1_.ozelkod6 AS ozelkod6_24, p1_.ozelkod7 AS ozelkod7_25, p1_.ozelkod8 AS ozelkod8_26, p1_.ozelkod9 AS ozelkod9_27, p1_.ozelkod10 AS ozelkod10_28, p2_.id AS id_29, p2_.value AS value_30, p2_.barcode AS barcode_31, p2_.default_price_order AS default_price_order_32, p2_.list_price_order AS list_price_order_33, p2_.multiplier AS multiplier_34, p2_.length AS length_35, p2_.width AS width_36, p2_.height AS height_37, p2_.weight AS weight_38, p3_.id AS id_39, p3_.value AS value_40, p3_.currency AS currency_41, p3_.price_order AS price_order_42, s4_.id AS id_43, s4_.quantity AS quantity_44, s4_.warehouseId AS warehouseId_45, s4_.date AS date_46, s4_.warehouseName AS warehouseName_47, s4_.inventoryId AS inventoryId_48, i5_.id AS id_49, i5_.image AS image_50, i5_.name AS name_51, b6_.id AS id_52, b6_.name AS name_53, b6_.code AS code_54, c7_.id AS id_55, c7_.name AS name_56, c7_.description AS description_57, c7_.meta_title AS meta_title_58, c7_.meta_description AS meta_description_59, c7_.meta_keyword AS meta_keyword_60, c7_.seo AS seo_61, c7_.order AS order_62, c0_.product_id AS product_id_63, p1_.parent_id AS parent_id_64, p1_.model_id AS model_id_65, p1_.brand_id AS brand_id_66, p2_.product_id AS product_id_67, p3_.product_unit_id AS product_unit_id_68, s4_.productId AS productId_69, i5_.product_id AS product_id_70, c7_.parent_id AS parent_id_71 FROM campaign c0_ LEFT JOIN product_to_campaign p8_ ON c0_.id = p8_.campaign_id LEFT JOIN product p1_ ON p1_.id = p8_.product_id LEFT JOIN product_unit p2_ ON p1_.id = p2_.product_id LEFT JOIN product_price p3_ ON p2_.id = p3_.product_unit_id LEFT JOIN stock_inventory s4_ ON p1_.id = s4_.productId LEFT JOIN image i5_ ON p1_.id = i5_.product_id LEFT JOIN brand b6_ ON p1_.brand_id = b6_.id LEFT JOIN product_to_category p9_ ON p1_.id = p9_.product_id LEFT JOIN category c7_ ON c7_.id = p9_.category_id WHERE c0_.product_id IS NULL ORDER BY c0_.sortstatus ASC
Parameters:
[]
0.93 ms
(13.64%)
1
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 LIMIT 1
Parameters:
[]
0.73 ms
(10.70%)
3
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0 WHERE t0.`key` = ? LIMIT 1
Parameters:
[
  "slider_blank"
]
0.63 ms
(9.25%)
1
SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2 FROM setting s0_ WHERE s0_.`key` = ?
Parameters:
[
  "firstPageIsLogin"
]
0.59 ms
(8.65%)
1
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.link AS link_2, s0_.imageURL AS imageURL_3, s0_.status AS status_4, s0_.sortstatus AS sortstatus_5 FROM slider s0_ WHERE s0_.status = ? ORDER BY s0_.sortstatus ASC
Parameters:
[
  1
]
0.51 ms
(7.45%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.meta_title AS meta_title_3, c0_.meta_description AS meta_description_4, c0_.meta_keyword AS meta_keyword_5, c0_.seo AS seo_6, c0_.order AS order_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL ORDER BY c0_.order ASC
Parameters:
[]
0.43 ms
(6.39%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.status AS status_2 FROM page_category p0_ WHERE (SELECT COUNT(*) FROM page p1_ WHERE p1_.page_category_id = p0_.id) > 0 ORDER BY p0_.status ASC
Parameters:
[]
0.39 ms
(5.70%)
1
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.explanation AS explanation_2, b0_.link AS link_3, b0_.imageURL AS imageURL_4, b0_.column_width AS column_width_5, b0_.status AS status_6, b0_.sortstatus AS sortstatus_7, b0_.titleA AS titleA_8, b0_.explanationA AS explanationA_9, b0_.animation AS animation_10 FROM banner b0_ WHERE b0_.status = ? ORDER BY b0_.sortstatus ASC
Parameters:
[
  1
]
0.30 ms
(4.35%)
1
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3 FROM setting t0
Parameters:
[]
0.28 ms
(4.10%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.description AS description_7, t0.logo AS logo_8, t0.whatsapp AS whatsapp_9, t0.social_media AS social_media_10, t0.whatsapp_control AS whatsapp_control_11 FROM store t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.28 ms
(4.08%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ ORDER BY p0_.id DESC
Parameters:
[]
0.27 ms
(3.92%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.seo AS seo_5, p0_.sortStatus AS sortStatus_6, p0_.page_category_id AS page_category_id_7 FROM page p0_ GROUP BY p0_.page_category_id
Parameters:
[]
0.27 ms
(3.90%)
1
SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.var1 AS var1_2, c0_.quantity AS quantity_3, c0_.customer_number AS customer_number_4, c0_.is_discounted AS is_discounted_5, c0_.product_id AS product_id_6, c0_.user_id AS user_id_7, c0_.product_unit_id AS product_unit_id_8 FROM cart c0_ WHERE c0_.session_id = ?
Parameters:
[
  null
]
0.25 ms
(3.69%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.exchangeRate AS exchangeRate_5 FROM currency t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Setting 58
App\Entity\Category 4
App\Entity\Currency 3
App\Entity\Slider 1
App\Entity\Store 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Slider No errors.
App\Entity\Setting No errors.
App\Entity\Campaign No errors.
App\Entity\Banner No errors.
App\Entity\Product No errors.
App\Entity\ProductUnit No errors.
App\Entity\Brand No errors.
App\Entity\Store No errors.
App\Entity\Currency No errors.
App\Entity\Cart No errors.
App\Entity\Page No errors.
App\Entity\PageCategory No errors.
App\Entity\Category No errors.