
Crickets is a new four-level preschool series that integrates all the domains of early learning. The learning cycle is based on the 5 E’s methodology (Engage, Explore, Explain, Elaborate, Evaluate). This instructional model relies on the constructivist approach to learning. Crickets fosters the development of cognitive skills and integrates early literacy skills, phonological awareness, alphabet knowledge, concepts of print, science, mathematics, social studies, arts, physical development, problem solving, knowledge of the world and social and emotional development. It also Includes CLIL lessons appropriate for the age of the students plus promotes the use of ICT (Information and Communication Technology) through interactive activities and videos. This new series also features a resource CD with posters and more engaging extension activities
Our mission is to contribute to excellence in English language teaching worldwide through the publication of high quality materials in teacher-friendly formats and the provision of additional educational services relevant to local needs.
Juan Manuel Blanes 1132, CP: 11200 Montevideo, Uruguay
Teléfono: +59824107342
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ 4ad404491e07541d8511aa495f8560a7
vmcart ⇒ O:8:"stdClass":21:{s:8:"products";a:0:{}s:8:"vendorId";i:1;s:21:"lastVisitedCategoryId";i:0;s:28:"virtuemart_shipmentmethod_id";i:0;s:27:"virtuemart_paymentmethod_id";i:0;s:25:"automaticSelectedShipment";b:0;s:24:"automaticSelectedPayment";b:0;s:12:"order_number";N;s:2:"BT";i:0;s:2:"ST";i:0;s:11:"tosAccepted";N;s:16:"customer_comment";s:0:"";s:10:"couponCode";s:0:"";s:8:"cartData";N;s:5:"lists";N;s:14:"pricesCurrency";N;s:15:"paymentCurrency";N;s:11:"_inCheckOut";b:0;s:14:"_dataValidated";b:0;s:12:"_confirmDone";b:0;s:10:"STsameAsBT";i:0;}
Application 0.000 seconds (+0.000); 0.61 MB (+0.609) - afterLoad
Application 0.051 seconds (+0.051); 3.86 MB (+3.249) - afterInitialise
Application 0.065 seconds (+0.014); 5.16 MB (+1.298) - afterRoute
Application 0.315 seconds (+0.250); 16.64 MB (+11.487) - beforeRenderModule mod_breadcrumbs (Breadcrumbs Products)
Application 0.320 seconds (+0.005); 16.76 MB (+0.118) - afterRenderModule mod_breadcrumbs (Breadcrumbs Products)
Application 0.325 seconds (+0.005); 16.76 MB (-0.002) - beforeRenderModule mod_social_comments_sharing (Joomla Social Comments and Sharing PRO)
Application 0.326 seconds (+0.001); 16.79 MB (+0.030) - afterRenderModule mod_social_comments_sharing (Joomla Social Comments and Sharing PRO)
Application 0.327 seconds (+0.001); 16.66 MB (-0.130) - afterDispatch
Application 0.330 seconds (+0.003); 16.76 MB (+0.098) - beforeRenderModule mod_custom (logos_sellos)
Application 0.338 seconds (+0.008); 17.08 MB (+0.320) - afterRenderModule mod_custom (logos_sellos)
Application 0.338 seconds (+0.000); 17.08 MB (-0.002) - beforeRenderModule mod_custom (FooterContactAs)
Application 0.339 seconds (+0.001); 17.08 MB (+0.004) - afterRenderModule mod_custom (FooterContactAs)
Application 0.339 seconds (+0.000); 17.08 MB (-0.003) - beforeRenderModule mod_custom (About Us)
Application 0.340 seconds (+0.001); 17.08 MB (+0.004) - afterRenderModule mod_custom (About Us)
Application 0.340 seconds (+0.000); 17.08 MB (-0.002) - beforeRenderModule mod_custom (banner-app-crickets)
Application 0.340 seconds (+0.001); 17.08 MB (+0.004) - afterRenderModule mod_custom (banner-app-crickets)
Application 0.340 seconds (+0.000); 17.08 MB (-0.003) - beforeRenderModule mod_custom (microsite crickets)
Application 0.341 seconds (+0.001); 17.09 MB (+0.004) - afterRenderModule mod_custom (microsite crickets)
Application 0.341 seconds (+0.000); 17.08 MB (-0.002) - beforeRenderModule mod_login (Login Form)
Application 0.345 seconds (+0.004); 17.14 MB (+0.057) - afterRenderModule mod_login (Login Form)
Application 0.345 seconds (+0.000); 17.14 MB (-0.004) - beforeRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.363 seconds (+0.018); 17.28 MB (+0.143) - afterRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.363 seconds (+0.000); 17.28 MB (-0.003) - beforeRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.367 seconds (+0.004); 17.29 MB (+0.016) - afterRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.367 seconds (+0.000); 17.29 MB (-0.005) - beforeRenderModule mod_menu (Main Menu)
Application 0.377 seconds (+0.009); 17.43 MB (+0.137) - afterRenderModule mod_menu (Main Menu)
Application 0.377 seconds (+0.000); 17.42 MB (-0.007) - beforeRenderModule mod_custom (Logo-Richmond)
Application 0.377 seconds (+0.001); 17.42 MB (+0.004) - afterRenderModule mod_custom (Logo-Richmond)
Application 0.384 seconds (+0.007); 17.50 MB (+0.078) - afterRender
17.52 MB (18,366,576 Bytes)
SELECT `data`
FROM `qpf89_session`
WHERE `session_id` = '93309982030714ac7d7f8826143d28e5'
SELECT `session_id`
FROM `qpf89_session`
WHERE `session_id` = '93309982030714ac7d7f8826143d28e5'
LIMIT 0, 1
INSERT INTO `qpf89_session`
(`session_id`, `client_id`, `time`)
VALUES
('93309982030714ac7d7f8826143d28e5', 0, '1618911414')
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM qpf89_usergroups AS a
LEFT JOIN qpf89_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `qpf89_viewlevels`
SELECT folder AS type, element AS name, params
FROM qpf89_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qpf89_menu AS m
LEFT JOIN qpf89_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT *
FROM qpf89_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM qpf89_template_styles as s
LEFT JOIN qpf89_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SHOW TABLES LIKE "%virtuemart_configs%"
SELECT `config`
FROM `qpf89_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `qpf89_virtuemart_permgroups`
ORDER BY `group_level`
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "31"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "31"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "31"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "31"
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"
SELECT *
FROM `qpf89_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT `virtuemart_userinfo_id`
FROM `qpf89_virtuemart_userinfos`
WHERE `virtuemart_user_id` = "0"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "31"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2021-04-20 09:36:54" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:36:54" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT `qpf89_virtuemart_manufacturers_en_gb`.* ,`qpf89_virtuemart_manufacturers`.*
FROM `qpf89_virtuemart_manufacturers_en_gb` JOIN qpf89_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE qpf89_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "33"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 31
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "31"
and `virtuemart_category_id`= "24"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "24"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =31
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `qpf89_virtuemart_vendors` AS v
LEFT JOIN `qpf89_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"
SELECT *
FROM `qpf89_virtuemart_currencies`
WHERE `virtuemart_currency_id`="144"
SELECT `price_display`,`custom_price_display`
FROM `qpf89_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =31
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =31
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =31
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT *
FROM `qpf89_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT *
FROM qpf89_virtuemart_calcs
WHERE
`calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2021-04-20 09:36:54" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-04-20 09:36:54" )
OR `for_override` = "1" )
SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =31
SELECT `virtuemart_category_id`
FROM qpf89_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_shoppergroup_id`
FROM qpf89_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_country_id`
FROM qpf89_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_state_id`
FROM qpf89_virtuemart_calc_states
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_manufacturer_id`
FROM qpf89_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="1"
SELECT *
FROM `qpf89_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language="en_gb")
SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_manufacturers_en_gb` as l JOIN `qpf89_virtuemart_manufacturers` AS m using (`virtuemart_manufacturer_id`) JOIN `qpf89_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
WHERE m.`published`=1
AND pm.`virtuemart_product_id` =31
ORDER BY l.`mf_name`
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "176"
SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `qpf89_virtuemart_products` as `p`
JOIN `qpf89_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`)
JOIN `qpf89_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)
WHERE `virtuemart_category_id` = 24
and `slug` < "cricketsan"
AND ( psgr.`virtuemart_shoppergroup_id`= "1" OR psgr.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`= 1
ORDER BY pc.ordering DESC
LIMIT 0,1
SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `qpf89_virtuemart_products` as `p`
JOIN `qpf89_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`)
JOIN `qpf89_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)
WHERE `virtuemart_category_id` = 24
and `slug` > "cricketsan"
AND ( psgr.`virtuemart_shoppergroup_id`= "1" OR psgr.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`= 1
ORDER BY pc.ordering ASC
LIMIT 0,1
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "24"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "24"
ORDER BY `ordering`
SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
WHERE `category_parent_id` = 24
SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `qpf89_virtuemart_categories_en_gb` l
JOIN `qpf89_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 24
AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
ORDER BY category_name ASC
LIMIT 0, 20
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `qpf89_virtuemart_categories_en_gb` l
JOIN `qpf89_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 24
AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
ORDER BY category_name ASC
LIMIT 0, 20
SELECT count(qpf89_virtuemart_products.virtuemart_product_id) AS total
FROM `qpf89_virtuemart_products`, `qpf89_virtuemart_product_categories`
WHERE `qpf89_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `qpf89_virtuemart_product_categories`.`virtuemart_category_id` = 24
AND `qpf89_virtuemart_products`.`virtuemart_product_id` = `qpf89_virtuemart_product_categories`.`virtuemart_product_id`
AND `qpf89_virtuemart_products`.`published` = "1"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 24
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_name`,`virtuemart_category_id`
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=30
SELECT `category_name`,`virtuemart_category_id`
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=24
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 24
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT *
FROM `qpf89_virtuemart_rating_reviews`
WHERE `virtuemart_product_id` = "31"
AND `created_by` = "0"
SELECT SQL_CALC_FOUND_ROWS `u`.*,`pr`.*,`p`.`product_name`,`rv`.`vote`, `u`.`name` AS customer, `pr`.`published`
FROM `qpf89_virtuemart_rating_reviews` AS `pr`
LEFT JOIN `qpf89_users` AS `u`
ON `pr`.`created_by` = `u`.`id`
LEFT JOIN `qpf89_virtuemart_products_en_gb` AS `p`
ON `p`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_rating_votes` AS `rv`
on `rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id`
and `rv`.`created_by`=`u`.`id`
WHERE `p`.`virtuemart_product_id` = "31"
ORDER BY created_on DESC
LIMIT 0, 20
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS `u`.*,`pr`.*,`p`.`product_name`,`rv`.`vote`, `u`.`name` AS customer, `pr`.`published`
FROM `qpf89_virtuemart_rating_reviews` AS `pr`
LEFT JOIN `qpf89_users` AS `u`
ON `pr`.`created_by` = `u`.`id`
LEFT JOIN `qpf89_virtuemart_products_en_gb` AS `p`
ON `p`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_rating_votes` AS `rv`
on `rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id`
and `rv`.`created_by`=`u`.`id`
WHERE `p`.`virtuemart_product_id` = "31"
ORDER BY created_on DESC
LIMIT 0, 20
SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `qpf89_virtuemart_paymentmethods_en_gb` as l JOIN `qpf89_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `qpf89_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `qpf89_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE v.`published` = "1"
AND j.`element` = "klarna"
AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY v.`virtuemart_paymentmethod_id`
ORDER BY v.`ordering`
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qpf89_modules AS m
LEFT JOIN qpf89_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qpf89_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-04-20 09:36:54')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-20 09:36:54')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 284 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=33
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=33
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=37
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=34
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=36
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=35
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 30
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "24"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "25"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "26"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "27"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "33"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "32"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "36"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "37"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "35"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "38"
ORDER BY `ordering`
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 25
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 26
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 27
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 33
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 32
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 36
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 37
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 35
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 38
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 33
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 33
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=33
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 32
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 32
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=32
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 36
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 36
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=36
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 37
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 37
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=37
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 35
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 35
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=35
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 38
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 38
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=38
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
UPDATE `qpf89_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618911414;s:18:\"session.timer.last\";i:1618911414;s:17:\"session.timer.now\";i:1618911414;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:14:\"productdetails\";O:8:\"stdClass\":1:{s:12:\"filter_order\";s:11:\"pc.ordering\";}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4ad404491e07541d8511aa495f8560a7\";}__vm|a:3:{s:6:\"vmcart\";s:545:\"O:8:\"stdClass\":21:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";i:0;}\";s:23:\"vmlastvisitedcategoryid\";i:24;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:31;}}'
, `time` = '1618911414'
WHERE `session_id` = '93309982030714ac7d7f8826143d28e5'
20 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
11 × SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
11 × SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
6 × SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
6 × SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
3 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
2 × SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `qpf89_virtuemart_products` as `p` JOIN `qpf89_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `qpf89_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)
2 × SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
2 × SELECT SQL_CALC_FOUND_ROWS `u`.*,`pr`.*,`p`.`product_name`,`rv`.`vote`, `u`.`name` AS customer, `pr`.`published`
FROM `qpf89_virtuemart_rating_reviews` AS `pr`
LEFT JOIN `qpf89_users` AS `u`
ON `pr`.`created_by` = `u`.`id`
LEFT JOIN `qpf89_virtuemart_products_en_gb` AS `p`
ON `p`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_rating_votes` AS `rv`
on `rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id`
and `rv`.`created_by`=`u`.`id`
2 × SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `qpf89_virtuemart_categories_en_gb` l JOIN `qpf89_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
2 × SELECT *
FROM `qpf89_virtuemart_shoppergroups`
2 × SELECT FOUND_ROWS(
2 × SELECT `category_name`,`virtuemart_category_id`
FROM `qpf89_virtuemart_categories_en_gb`
2 × SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
1 × SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `qpf89_virtuemart_permgroups`
1 × SELECT `config`
FROM `qpf89_virtuemart_configs`
1 × SELECT count(qpf89_virtuemart_products.virtuemart_product_id) AS total
FROM `qpf89_virtuemart_products`, `qpf89_virtuemart_product_categories`
1 × SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
1 × SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
1 × SELECT *
FROM `qpf89_menu`
1 × SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_manufacturers_en_gb` as l JOIN `qpf89_virtuemart_manufacturers` AS m using (`virtuemart_manufacturer_id`) JOIN `qpf89_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
1 × SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
1 × SELECT id, home, template, s.params
FROM qpf89_template_styles as s
LEFT JOIN qpf89_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM qpf89_languages
1 × SELECT id, rules
FROM `qpf89_viewlevels
1 × SELECT b.id
FROM qpf89_usergroups AS a
LEFT JOIN qpf89_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `qpf89_session`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qpf89_modules AS m
LEFT JOIN qpf89_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qpf89_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `qpf89_virtuemart_paymentmethods_en_gb` as l JOIN `qpf89_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `qpf89_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `qpf89_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qpf89_menu AS m
LEFT JOIN qpf89_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM `qpf89_virtuemart_rating_reviews`
1 × SELECT folder AS type, element AS name, params
FROM qpf89_extensions
1 × SELECT `virtuemart_manufacturer_id`
FROM qpf89_virtuemart_calc_manufacturers
1 × SELECT `virtuemart_state_id`
FROM qpf89_virtuemart_calc_states
1 × SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
1 × SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
1 × SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
1 × SELECT `qpf89_virtuemart_manufacturers_en_gb`.* ,`qpf89_virtuemart_manufacturers`.*
FROM `qpf89_virtuemart_manufacturers_en_gb` JOIN qpf89_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
1 × SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
1 × SELECT `virtuemart_userinfo_id`
FROM `qpf89_virtuemart_userinfos`
1 × SELECT *
FROM `qpf89_virtuemart_product_prices`
1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `qpf89_virtuemart_vendors` AS v
LEFT JOIN `qpf89_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
1 × SELECT *
FROM `qpf89_virtuemart_currencies`
1 × SELECT `virtuemart_category_id`
FROM qpf89_virtuemart_calc_categories
1 × SELECT `virtuemart_shoppergroup_id`
FROM qpf89_virtuemart_calc_shoppergroups
1 × SELECT `virtuemart_country_id`
FROM qpf89_virtuemart_calc_countries
1 × SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb` JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
1 × SELECT *
FROM qpf89_virtuemart_calcs
1 × SELECT `price_display`,`custom_price_display`
FROM `qpf89_virtuemart_shoppergroups` AS `sg`
1 × SELECT `data`
FROM `qpf89_session`
1 × SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_vmuser_shoppergroups`
1 × UPDATE `qpf89_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618911414;s:18:\"session.timer.last\";i:1618911414;s:17:\"session.timer.now\";i:1618911414;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:14:\"productdetails\";O:8:\"stdClass\":1:{s:12:\"filter_order\";s:11:\"pc.ordering\";}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4ad404491e07541d8511aa495f8560a7\";}__vm|a:3:{s:6:\"vmcart\";s:545:\"O:8:\"stdClass\":21:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";i:0;}\";s:23:\"vmlastvisitedcategoryid\";i:24;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:31;}}' , `time` = '1618911414'
1 × SHOW TABLES LIKE "%virtuemart_configs%
1 × INSERT INTO `qpf89_session` (`session_id`, `client_id`, `time`)
VALUES ('93309982030714ac7d7f8826143d28e5', 0, '1618911414'