- Posts: 44
- Thank you received: 0
Debug shows same queries over and over? Is this a error?
13 years 10 months ago #12714
by gswahhab
Debug shows same queries over and over? Is this a error? was created by gswahhab
I am getting very slow performance out of flexicontent and i am trying to debug flexi to see if there is any errors. Looking at the queries which i posted below many times the same query is getting posted over and over.
Why is this? Is this an error maybe some bad code somewhere? Or is this normal?
Thanks,
Gabe
Why is this? Is this an error maybe some bad code somewhere? Or is this normal?
Thanks,
Gabe
Code:
Profile Information
Application afterLoad: 0.000 seconds, 0.24 MB
Application afterInitialise: 0.116 seconds, 6.63 MB
Application afterRoute: 0.166 seconds, 9.43 MB
Application afterDispatch: 5.217 seconds, 16.57 MB
Application afterRender: 5.628 seconds, 24.57 MB
Memory Usage
26225688
205 queries logged
1.
SELECT *
FROM uscs_session
WHERE session_id = '45d6315850a15101a32fac409914e62d'
2.
DELETE
FROM uscs_session
WHERE ( time < '1293919039' )
3.
SELECT *
FROM uscs_session
WHERE session_id = '45d6315850a15101a32fac409914e62d'
4.
UPDATE `uscs_session`
SET `time`='1293922639',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='8mcvm9NKVhG6Sm-_bPGegMqoZKtPCicDtyQbuvmbBD3FzO5y6Sd4JGT8E_033ftPYGFxTvvFLBfd-JTe1Ekh5UtWPsOze9r9I4JzB-FdzmsZZsKXpYKYZjHnHOHOLRKL9BH3XaYQHDoM29Bi8obPorpw-CWhy_g5B554FAlYUn7yUf9olrEnQ72T9ehM6TCgIHXBkUv0MtpjFf8mcplN8PagJW2LEhUcW0RnKao-yr43xC8qpouzaCmLgPnwVgz6xh_H-w-ZYog3EeyeD6yBCJmsswqdUTFqeY6rY-u7zeOyuXYkJEmSQ_C2dd8KyvKzXxnGrUmLQUYBtMDm2OSEXTxKM-azpp57qLqPpr_E6tBJROsx_7sLks8OaC4DIYFX5Py3oj2qk-rbw3fboYurboXuYR31uReZtGtkPfD8voWhFWZZLdZlSnaho9rhhrCQr5xZoNwEahhdGvaVYzzt38_RhRoJZCNFdWhWlGQVeiRcH4KkYf-dHcwXUK8IwU194-IKlV-IL_-Ystn9RX1NYzCaziBpKuumahA-WwL0zIooMaONDmdjLj4mqUekSTUMaDPJMJ1Gy45eiBYF-3OlzWYpI1e1YRPmaIWk9TXLrNPbIym99ZKooQCVr1T7GDDBa95rUA7ThssvqBbrYrBpfteDjFgqho6lUz3tFFnGeTbRdYkdW9rUbRfXOqX-uDObcFaXIIOrbz81608EJ-rW7gY7lDZEboGzl0Kpr1L58zBP9N-A4AIU5xCARLoLT5j8XCK8dLTmxB5xMyavCc3wlcs3L2mzLxFJeMLY3UHvye0cpDhzSoKxhuci7EquQoNu95DBu7I1VlZF88vcPYyXnRIDSPg8JuU_AIRkps_o00LfpC9neZ1-P2a7dlLPYu6GnVv5X9nzodblU2wIayDwfwCdtZlHtKuCFrYX_Q5OgYkcPe5JKVTi618XGQCdxF9Eg40Jzdw6dw9U8CRL_8iEkY_k9mULX9A6XxWXcwh1355bWSKodNdm3J08c5xsYig_tpxsopWDiHHlBlLS8yb9f2FbkbWrq-0k4w7vtABNV0KF--8w9EiSOfvgM3WhrBh9HjJyLyIRaawlAw5GtFxws63lKYvl33uiocJzRTOfJZ3auyMkZREGI4OXM-o8UhxHIn8cL8Gl1LYmOylxoqYDAbCgWLDrOOLOvQMeHt99kvSf5gX07zn69ehkpmAQVrrSVht_rt3BZZyivxKOyfY3WrYB5ZdA5GpISm21b3Iv0wfdQzNEqgfHvL2BlSV9YHAzE7ygVTZv3D4LygjVuOVOUalpLRzO6EzAKSh-8DxiQMjNsE6J6pGrGPUr0cUoMdwLQxT0WVrgxFWq_PWrlrZnr8yFyxWt1vV1qyOscBVB_QfrGvACpnDciCNZA5vlUnLMTwud5Dx4GWrvAjQhGekLkGMVlETK1kDjxeJkgvhyAfTxaXW9xlaqc7oY9DV5CYB6J6EBmiowfwjAxJwgp84gkthPbdr8lFV7mtUDBlXWkU27--raa8HEgu9O6w_qvToA7Ju3-gnGWKd1X0iOOvQiv-NUnBAscy_e_AX1QW1GSIFIuC21WaDHCgESE-I65HMzzzhFobKnqHqvLIalXy-PrRvjK2tkAuiLVstEeLOXz5kzkkm2j1SH6IgZfidDX31Ex2dzRvFqBtc-T3m5ZsKboyf0g47M4al4U6k4gal2Swy5htg8qB1MvDV8M8PNzz5S'
WHERE session_id='45d6315850a15101a32fac409914e62d'
5.
SELECT *
FROM uscs_components
WHERE parent = 0
6.
SELECT folder AS type, element AS name, params
FROM uscs_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
7.
SELECT id, parent_id, value, name, lft, rgt
FROM uscs_core_acl_aro_groups
WHERE id=23
8.
SELECT `ip`
FROM `uscs_admintools_ipblock`
9.
SELECT `source`
FROM `uscs_admintools_redirects`
WHERE (`dest` = '' OR `dest` = '')
AND `published` = 1
ORDER BY `ordering` DESC
LIMIT 0,1
10.
SELECT m.*, c.`option` AS component
FROM uscs_menu AS m
LEFT JOIN uscs_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
11.
SELECT newurl
FROM uscs_sh404sef_aliases
WHERE alias = ''
12.
SELECT m.*, c.`option` AS component
FROM uscs_menu AS m
LEFT JOIN uscs_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
13.
SELECT access
FROM uscs_menu
WHERE id = 1
14.
SELECT template
FROM uscs_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
15.
SELECT params
FROM uscs_categories
WHERE id = 191
16.
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
FROM uscs_categories AS c
WHERE c.id = 191
AND c.published = 1
17.
SELECT params
FROM uscs_categories
WHERE id = 191
18.
SELECT access
FROM uscs_categories
WHERE id = 191
19.
SELECT c.*, CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug
FROM uscs_categories AS c
LEFT JOIN uscs_flexiaccess_acl AS gi
ON c.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE c.published = 1
AND c.parent_id = 191
ORDER BY ordering ASC
20.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (102)
21.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 102
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
22.
SELECT params
FROM uscs_categories
WHERE id = 102
23.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
24.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('102','224','192','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
25.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('102','224','192','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
26.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (224)
27.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 224
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
28.
SELECT params
FROM uscs_categories
WHERE id = 224
29.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
30.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('224','102','192','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
31.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('224','102','192','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
32.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (192)
33.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 192
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
34.
SELECT params
FROM uscs_categories
WHERE id = 192
35.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
36.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('192','102','224','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
37.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('192','102','224','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
38.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (233)
39.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 233
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
40.
SELECT params
FROM uscs_categories
WHERE id = 233
41.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
42.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('233','102','224','192','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
43.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('233','102','224','192','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
44.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (228)
45.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 228
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
46.
SELECT params
FROM uscs_categories
WHERE id = 228
47.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
48.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('228','102','224','192','233','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
49.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('228','102','224','192','233','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
50.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (229)
51.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 229
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
52.
SELECT params
FROM uscs_categories
WHERE id = 229
53.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
54.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('229','102','224','192','233','228','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
55.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('229','102','224','192','233','228','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
56.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (230)
57.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 230
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
58.
SELECT params
FROM uscs_categories
WHERE id = 230
59.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
60.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('230','102','224','192','233','228','229','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
61.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('230','102','224','192','233','228','229','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
62.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (232)
63.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 232
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
64.
SELECT params
FROM uscs_categories
WHERE id = 232
65.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
66.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('232','102','224','192','233','228','229','230','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
67.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('232','102','224','192','233','228','229','230','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
68.
SELECT DISTINCT itemid
FROM uscs_flexicontent_cats_item_relations AS rel
LEFT JOIN uscs_content AS i
ON rel.itemid = i.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_categories AS cc
ON cc.id = rel.catid
LEFT JOIN uscs_flexiaccess_acl AS gc
ON cc.id = gc.axo
AND gc.aco = "read"
AND gc.axosection = "category"
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE cc.published = 1
AND i.state IN (1, -5)
AND rel.catid IN (257)
69.
SELECT DISTINCTROW sc.*, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', sc.id, sc.alias) ELSE sc.id END AS slug
FROM uscs_categories AS sc
LEFT JOIN uscs_flexiaccess_acl AS gi
ON sc.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "category"
WHERE sc.published = 1
AND sc.parent_id = 257
AND (gi.aro IN ( 0 ) OR sc.access <= 0)
ORDER BY ordering ASC
70.
SELECT params
FROM uscs_categories
WHERE id = 257
71.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
72.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('257','102','224','192','233','228','229','230','232')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
73.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('257','102','224','192','233','228','229','230','232')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
74.
SELECT params
FROM uscs_categories
WHERE id = 191
75.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
76.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('191','102','224','192','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
77.
SELECT DISTINCT i.*, ie.*, u.name AS author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ie.item_id = i.id
LEFT JOIN uscs_flexicontent_types AS ty
ON ie.type_id = ty.id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id = i.catid
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
LEFT JOIN uscs_flexiaccess_acl AS gi
ON i.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "item"
WHERE rel.catid IN ('191','102','224','192','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2011-01-01 22:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2011-01-01 22:57' )
AND i.sectionid = 19
ORDER BY i.created DESC, i.title
LIMIT 0, 10
78.
SELECT params
FROM uscs_categories
WHERE id = 191
79.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
WHERE fi.access <= 0
AND fi.published = 1
AND fi.isfilter = 1
ORDER BY fi.ordering, fi.name
80.
SELECT LOWER(SUBSTRING(i.title
FROM 1 FOR 1)) AS alpha
FROM uscs_content AS i
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON i.id = ie.item_id
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id
LEFT JOIN uscs_categories AS c
ON c.id IN ('191','102','224','192','233','228','229','230','232','257')
WHERE rel.catid IN ('191','102','224','192','233','228','229','230','232','257')
AND i.state IN (1, -5)
AND i.sectionid = 19
GROUP BY alpha
ORDER BY alpha ASC
81.
SELECT DISTINCT t.name, i.itemid, CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END AS slug
FROM uscs_flexicontent_tags AS t
LEFT JOIN uscs_flexicontent_tags_item_relations AS i
ON i.tid = t.id
WHERE i.itemid IN (7878,7877,7876,7872,7871,7868,7865,7864,7856,7855)
AND t.published = 1
ORDER BY i.itemid, t.name
82.
SELECT DISTINCT c.id, c.title, rel.itemid, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug
FROM uscs_categories AS c
LEFT JOIN uscs_flexicontent_cats_item_relations AS rel
ON rel.catid = c.id
WHERE rel.itemid IN (7878,7877,7876,7872,7871,7868,7865,7864,7856,7855)
83.
SELECT itemid, COUNT(id) AS favs
FROM uscs_flexicontent_favourites
WHERE itemid IN (7878,7877,7876,7872,7871,7868,7865,7864,7856,7855)
GROUP BY itemid
84.
SELECT itemid, COUNT(id) AS fav
FROM uscs_flexicontent_favourites
WHERE itemid IN (7878,7877,7876,7872,7871,7868,7865,7864,7856,7855)
AND userid = 0
GROUP BY itemid
85.
SELECT i.id, u.name, u.username, u.email
FROM uscs_content AS i
LEFT JOIN uscs_users AS u
ON u.id = i.modified_by
WHERE i.id IN (7878,7877,7876,7872,7871,7868,7865,7864,7856,7855)
86.
SELECT i.id, u.name, i.created_by_alias AS alias, u.username, u.email
FROM uscs_content AS i
LEFT JOIN uscs_users AS u
ON u.id = i.created_by
WHERE i.id IN (7878,7877,7876,7872,7871,7868,7865,7864,7856,7855)
87.
SELECT ie.item_id, t.name
FROM uscs_flexicontent_items_ext AS ie
LEFT JOIN uscs_flexicontent_types AS t
ON t.id = ie.type_id
WHERE ie.item_id IN (7878,7877,7876,7872,7871,7868,7865,7864,7856,7855)
88.
SELECT *
FROM uscs_content_rating
WHERE content_id IN (7878,7877,7876,7872,7871,7868,7865,7864,7856,7855)
89.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7878
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
90.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7878
ORDER BY field_id, valueorder
91.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
92.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 382
93.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 383
94.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 384
95.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 385
96.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 386
97.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 387
98.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 388
99.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 389
100.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 390
101.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 391
102.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 392
103.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 393
104.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 394
105.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 396
106.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 398
107.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 397
108.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 399
109.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 400
110.
SELECT filename, altname, ext
FROM uscs_flexicontent_files
WHERE id = 401
Please Log in or Create an account to join the conversation.
13 years 10 months ago #12715
by gswahhab
Replied by gswahhab on topic Debug shows same queries over and over? Is this a error?
part 2 of the code
Code:
111.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7877
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
112.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7877
ORDER BY field_id, valueorder
113.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
114.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7876
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
115.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7876
ORDER BY field_id, valueorder
116.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
117.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7872
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
118.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7872
ORDER BY field_id, valueorder
119.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
120.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7871
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
121.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7871
ORDER BY field_id, valueorder
122.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
123.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7868
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
124.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7868
ORDER BY field_id, valueorder
125.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
126.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7865
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
127.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7865
ORDER BY field_id, valueorder
128.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
129.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7864
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
130.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7864
ORDER BY field_id, valueorder
131.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
132.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7856
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
133.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7856
ORDER BY field_id, valueorder
134.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
135.
SELECT fi.*
FROM uscs_flexicontent_fields AS fi
LEFT JOIN uscs_flexicontent_fields_type_relations AS ftrel
ON ftrel.field_id = fi.id
LEFT JOIN uscs_flexicontent_items_ext AS ie
ON ftrel.type_id = ie.type_id
LEFT JOIN uscs_flexiaccess_acl AS gi
ON fi.id = gi.axo
AND gi.aco = "read"
AND gi.axosection = "field"
WHERE ie.item_id = 7855
AND fi.published = 1
AND (gi.aro IN ( 0 ) OR fi.access <= 0)
GROUP BY fi.id
ORDER BY ftrel.ordering, fi.ordering, fi.name
136.
SELECT field_id, value
FROM uscs_flexicontent_fields_item_relations
WHERE item_id = 7855
ORDER BY field_id, valueorder
137.
SELECT id AS value, filename AS text
FROM uscs_flexicontent_files
WHERE ext = 'mp3'
AND secure = 0
ORDER BY filename ASC
138.
SELECT *
FROM uscs_flexicontent_templates
WHERE template = 'blog'
AND layout = 'category'
139.
SELECT parent_id
FROM uscs_categories
WHERE id = 191
AND section = 19
140.
SELECT parent_id
FROM uscs_categories
WHERE id = 191
AND section = 19
141.
SELECT parent_id
FROM uscs_categories
WHERE id = 0
AND section = 19
142.
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS categoryslug
FROM uscs_categories
WHERE id =191
AND section = 19
AND published = 1
143.
SELECT oldurl, dateadd
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_flexicontent&Itemid=1&cid=191&format=feed&lang=en&type=rss&view=category'
144.
SELECT id, title, alias
FROM uscs_categories
WHERE id = 191
145.
SELECT oldurl
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_flexicontent&Itemid=1&cid=191&lang=en&view=category'
146.
SELECT oldurl, dateadd
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_flexicontent&Itemid=1&cid=191&format=feed&lang=en&type=atom&view=category'
147.
SELECT id, title, alias
FROM uscs_categories
WHERE id = 191
148.
SELECT oldurl
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_flexicontent&Itemid=1&cid=191&lang=en&view=category'
149.
SELECT g.*
FROM uscs_core_acl_aro_groups AS g
INNER JOIN uscs_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN uscs_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='64'
ORDER BY g.id
150.
SELECT g.*
FROM uscs_core_acl_aro_groups AS g
INNER JOIN uscs_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN uscs_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='4012'
ORDER BY g.id
151.
SELECT g.*
FROM uscs_core_acl_aro_groups AS g
INNER JOIN uscs_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN uscs_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='1844'
ORDER BY g.id
152.
SELECT g.*
FROM uscs_core_acl_aro_groups AS g
INNER JOIN uscs_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN uscs_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='4260'
ORDER BY g.id
153.
SELECT oldurl, dateadd
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_flexicontent&Itemid=1&cid=191&lang=en&pop=1&tmpl=component&view=category'
154.
SELECT id, title, alias
FROM uscs_categories
WHERE id = 191
155.
SELECT oldurl
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_flexicontent&Itemid=1&cid=191&lang=en&view=category'
156.
SELECT oldurl, dateadd
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_mailto&lang=en&link=aHR0cDovL3VzY29tYmF0c3BvcnRzLmNvbS90ZW1wZGV2Lw==&tmpl=component'
157.
SELECT *
FROM uscs_jcomments_settings
158.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7878
AND object_group = 'com_flexicontent'
AND published = 1
159.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7877
AND object_group = 'com_flexicontent'
AND published = 1
160.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7876
AND object_group = 'com_flexicontent'
AND published = 1
161.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7872
AND object_group = 'com_flexicontent'
AND published = 1
162.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7871
AND object_group = 'com_flexicontent'
AND published = 1
163.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7868
AND object_group = 'com_flexicontent'
AND published = 1
164.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7865
AND object_group = 'com_flexicontent'
AND published = 1
165.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7864
AND object_group = 'com_flexicontent'
AND published = 1
166.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7856
AND object_group = 'com_flexicontent'
AND published = 1
167.
SELECT count(*)
FROM uscs_jcomments
WHERE object_id = 7855
AND object_group = 'com_flexicontent'
AND published = 1
168.
SELECT m.*, am.params AS adv_params
FROM uscs_modules AS m
LEFT JOIN uscs_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
ORDER BY m.ordering, m.id
169.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 30384
LIMIT 1
170.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 30383
LIMIT 1
171.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 30380
LIMIT 1
172.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 30381
LIMIT 1
173.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 30379
LIMIT 1
174.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 30382
LIMIT 1
175.
SELECT *
FROM uscs_kunena_config
176.
SELECT c.id, c.pub_access, c.pub_recurse, c.admin_access, c.admin_recurse
FROM uscs_kunena_categories c
WHERE published='1'
177.
SELECT COUNT(DISTINCT t.thread)
FROM uscs_kunena_messages AS t
INNER JOIN uscs_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0)
AND m.catid IN (15,28,29,30,31,32,33,34,35,36)
AND t.hold IN (0)
AND t.moved=0
AND t.catid IN (15,28,29,30,31,32,33,34,35,36)
AND t.time>'1291330644'
178.
SELECT c.id
FROM uscs_categories AS c
LEFT JOIN uscs_categories AS p
ON p.id=c.parent_id
LEFT JOIN uscs_categories AS gp
ON gp.id=p.parent_id
LEFT JOIN uscs_categories AS ggp
ON ggp.id=gp.parent_id
WHERE c.access <= 0
AND c.published = 1
AND c.section = 'com_jevents'
179.
SELECT c.id
FROM uscs_categories AS c
LEFT JOIN uscs_categories AS p
ON p.id=c.parent_id
LEFT JOIN uscs_categories AS gp
ON gp.id=p.parent_id
LEFT JOIN uscs_categories AS ggp
ON ggp.id=gp.parent_id
WHERE c.access <= 0
AND c.published = 1
AND c.section = 'com_jevents'
AND (c.id IN (254) OR p.id IN (254) OR gp.id IN (254) OR ggp.id IN (254))
180.
SELECT DISTINCT rpt.eventid
FROM uscs_jevents_repetition AS rpt
LEFT JOIN uscs_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN uscs_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN uscs_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN uscs_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
LEFT JOIN uscs_jev_files AS jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN uscs_jev_tageventsmap AS tagmap
ON tagmap.ev_id = ev.ev_id
WHERE ev.catid IN(-1,254)
AND rpt.endrepeat >= '2011-01-01 16:57:24'
AND rpt.startrepeat <= '2011-01-31'
AND ((rpt.startrepeat >= '2011-01-01 16:57:24'
AND det.multiday=0) OR det.multiday=1)
AND ev.state=1
AND det.priority IN (1)
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
AND rpt.startrepeat=(SELECT MIN(startrepeat)
FROM uscs_jevents_repetition AS rpt2
WHERE rpt2.eventid=rpt.eventid
AND rpt2.startrepeat >= '2011-01-01 16:57:24'
AND rpt2.endrepeat <= '2011-01-31')
ORDER BY rpt.startrepeat ASC
LIMIT 5
181.
SELECT rpt.eventid
FROM uscs_jevents_repetition AS rpt
LEFT JOIN uscs_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN uscs_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN uscs_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN uscs_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
LEFT JOIN uscs_jev_files AS jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN uscs_jev_tageventsmap AS tagmap
ON tagmap.ev_id = ev.ev_id
WHERE ev.catid IN(-1,254)
AND rpt.endrepeat >= '2010-12-02'
AND rpt.startrepeat <= '2011-01-01 16:57:24'
AND ((rpt.startrepeat >= '2010-12-02'
AND det.multiday=0) OR det.multiday=1)
AND ev.state=1
AND det.priority IN (1)
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
AND rpt.startrepeat=(SELECT MAX(startrepeat)
FROM uscs_jevents_repetition AS rpt2
WHERE rpt2.eventid=rpt.eventid
AND rpt2.startrepeat <= '2011-01-01 16:57:24'
AND rpt2.startrepeat >= '2010-12-02')
GROUP BY rpt.eventid
ORDER BY rpt.startrepeat DESC
LIMIT 5
182.
SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published, ev.created AS created , CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://uscombatsports.com/tempdev/images/stories/jevents/',jevfil1.filename) END AS imageurl1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://uscombatsports.com/tempdev/images/stories/jevents/',jevfil1.filename,'" />') END AS imageimg1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://uscombatsports.com/tempdev/images/stories/jevents/thumbnails/thumb_',jevfil1.filename) END AS imagethumb1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://uscombatsports.com/tempdev/images/stories/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END AS thumbimg1 , CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://uscombatsports.com/tempdev/images/stories/jevents/',jevfil1.filename) END AS imageurl
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://uscombatsports.com/tempdev/images/stories/jevents/',jevfil1.filename,'" />') END AS imageimg
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://uscombatsports.com/tempdev/images/stories/jevents/thumbnails/thumb_',jevfil1.filename) END AS imagethumb
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://uscombatsports.com/tempdev/images/stories/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END AS thumbimg
, YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
, YEAR(rpt.endrepeat ) AS ydn, MONTH(rpt.endrepeat ) AS mdn, DAYOFMONTH(rpt.endrepeat ) AS ddn
, HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
, HOUR(rpt.endrepeat ) AS hdn, MINUTE(rpt.endrepeat ) AS mindn, SECOND(rpt.endrepeat ) AS sdn
FROM uscs_jevents_repetition AS rpt
LEFT JOIN uscs_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN uscs_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN uscs_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN uscs_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
LEFT JOIN uscs_jev_files AS jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN uscs_jev_tageventsmap AS tagmap
ON tagmap.ev_id = ev.ev_id
WHERE ev.catid IN(-1,254)
AND rpt.endrepeat >= '2010-12-02'
AND rpt.startrepeat <= '2011-01-31'
AND ev.state=1
AND det.priority IN (1)
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
AND ev.ev_id IN (0)
GROUP BY rpt.rp_id
183.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 125
184.
SELECT DISTINCT rpt.eventid
FROM uscs_jevents_repetition AS rpt
LEFT JOIN uscs_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN uscs_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN uscs_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN uscs_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
LEFT JOIN uscs_jev_files AS jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN uscs_jev_tageventsmap AS tagmap
ON tagmap.ev_id = ev.ev_id
WHERE ev.catid IN(-1,173,174,176,178,179,254)
AND rpt.endrepeat >= '2011-01-01 16:57:24'
AND rpt.startrepeat <= '2011-03-02'
AND ((rpt.startrepeat >= '2011-01-01 16:57:24'
AND det.multiday=0) OR det.multiday=1)
AND ev.state=1
AND det.priority IN (0)
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
AND rpt.startrepeat=(SELECT MIN(startrepeat)
FROM uscs_jevents_repetition AS rpt2
WHERE rpt2.eventid=rpt.eventid
AND rpt2.startrepeat >= '2011-01-01 16:57:24'
AND rpt2.endrepeat <= '2011-03-02')
ORDER BY rpt.startrepeat ASC
LIMIT 4
185.
SELECT rpt.eventid
FROM uscs_jevents_repetition AS rpt
LEFT JOIN uscs_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN uscs_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN uscs_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN uscs_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
LEFT JOIN uscs_jev_files AS jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN uscs_jev_tageventsmap AS tagmap
ON tagmap.ev_id = ev.ev_id
WHERE ev.catid IN(-1,173,174,176,178,179,254)
AND rpt.endrepeat >= '2010-11-02'
AND rpt.startrepeat <= '2011-01-01 16:57:24'
AND ((rpt.startrepeat >= '2010-11-02'
AND det.multiday=0) OR det.multiday=1)
AND ev.state=1
AND det.priority IN (0)
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
AND rpt.startrepeat=(SELECT MAX(startrepeat)
FROM uscs_jevents_repetition AS rpt2
WHERE rpt2.eventid=rpt.eventid
AND rpt2.startrepeat <= '2011-01-01 16:57:24'
AND rpt2.startrepeat >= '2010-11-02')
GROUP BY rpt.eventid
ORDER BY rpt.startrepeat DESC
LIMIT 4
186.
SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published, ev.created AS created , CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://uscombatsports.com/tempdev/images/stories/jevents/',jevfil1.filename) END AS imageurl1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://uscombatsports.com/tempdev/images/stories/jevents/',jevfil1.filename,'" />') END AS imageimg1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://uscombatsports.com/tempdev/images/stories/jevents/thumbnails/thumb_',jevfil1.filename) END AS imagethumb1
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://uscombatsports.com/tempdev/images/stories/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END AS thumbimg1 , CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://uscombatsports.com/tempdev/images/stories/jevents/',jevfil1.filename) END AS imageurl
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://uscombatsports.com/tempdev/images/stories/jevents/',jevfil1.filename,'" />') END AS imageimg
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('http://uscombatsports.com/tempdev/images/stories/jevents/thumbnails/thumb_',jevfil1.filename) END AS imagethumb
, CASE WHEN (jevfil1.filename='') THEN '' ELSE CONCAT('<img src="http://uscombatsports.com/tempdev/images/stories/jevents/thumbnails/thumb_',jevfil1.filename,'" />') END AS thumbimg
, YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
, YEAR(rpt.endrepeat ) AS ydn, MONTH(rpt.endrepeat ) AS mdn, DAYOFMONTH(rpt.endrepeat ) AS ddn
, HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
, HOUR(rpt.endrepeat ) AS hdn, MINUTE(rpt.endrepeat ) AS mindn, SECOND(rpt.endrepeat ) AS sdn
FROM uscs_jevents_repetition AS rpt
LEFT JOIN uscs_jevents_vevent AS ev
ON rpt.eventid = ev.ev_id
LEFT JOIN uscs_jevents_icsfile AS icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN uscs_jevents_vevdetail AS det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN uscs_jevents_rrule AS rr
ON rr.eventid = rpt.eventid
LEFT JOIN uscs_jev_files AS jevfil1
ON jevfil1.ev_id = ev.ev_id
AND jevfil1.filetype='image'
AND jevfil1.file_num=1
LEFT JOIN uscs_jev_tageventsmap AS tagmap
ON tagmap.ev_id = ev.ev_id
WHERE ev.catid IN(-1,173,174,176,178,179,254)
AND rpt.endrepeat >= '2010-11-02'
AND rpt.startrepeat <= '2011-03-02'
AND ev.state=1
AND det.priority IN (0)
AND ev.access <= 0
AND icsf.state=1
AND icsf.access <= 0
AND ev.ev_id IN (463,865,464,417,874,883,836,881,0)
GROUP BY rpt.rp_id
187.
SELECT *
FROM uscs_jev_customfields
WHERE evdet_id IN (417,463,464,836,865,874,881,883)
ORDER BY evdet_id
188.
SELECT c.*, e.color
FROM uscs_jevents_categories AS e
LEFT JOIN uscs_categories AS c
ON c.id=e.id
189.
SELECT o.*, COUNT(v.id) AS hits,
(SELECT COUNT(id)
FROM `uscs_apoll_votes`
WHERE apoll_id=162) AS votes
FROM `uscs_apoll_options` AS o
LEFT JOIN `uscs_apoll_votes` AS v
ON (o.id = v.option_id
AND v.apoll_id = 162)
WHERE o.apoll_id=162
AND o.text <> ''
GROUP BY o.id
ORDER BY o.ordering
190.
SELECT *
FROM uscs_apoll_polls
WHERE id = '162'
191.
SELECT date
FROM `uscs_apoll_votes`
WHERE apoll_id=162
AND user_id=0
192.
SELECT ip
FROM `uscs_apoll_votes`
WHERE apoll_id=162
AND ip = INET_ATON('65.28.172.15')
193.
SELECT o.id, o.text, o.ordering
FROM `uscs_apoll_options` AS o
WHERE o.apoll_id = 162
AND o.text <> ''
ORDER BY o.ordering
194.
SELECT *
FROM
`uscs_community_featured` AS v
WHERE
type='videos'
ORDER BY RAND()
LIMIT
1
195.
SELECT *
FROM
`uscs_community_videos` AS v
WHERE
id = 31
196.
SELECT slides.*, articles.title AS title, articles.introtext AS introtext, articles.catid AS catid, articles.sectionid AS sectionid, cc.title AS categoryTitle, s.title AS sectionTitle,
CASE WHEN CHAR_LENGTH(articles.alias) THEN CONCAT_WS(":", articles.id, articles.alias) ELSE articles.id END AS slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM uscs_fpss_slides AS slides
LEFT JOIN uscs_fpss_categories AS categories
ON categories.id = slides.catid
LEFT JOIN uscs_content AS articles
ON articles.id = slides.itemlink
LEFT JOIN uscs_categories AS cc
ON cc.id = articles.catid
LEFT JOIN uscs_sections AS s
ON s.id = articles.sectionid
WHERE categories.published=1
AND slides.state=1
AND slides.registers <= 0
AND (slides.publish_up = '0000-00-00 00:00:00' OR slides.publish_up <= '2011-01-01 22:57:24')
AND (slides.publish_down = '0000-00-00 00:00:00' OR slides.publish_down >= '2011-01-01 22:57:24')
AND slides.catid=1
AND (articles.state=1 OR articles.state IS NULL)
AND (articles.publish_up = '0000-00-00 00:00:00' OR articles.publish_up <= '2011-01-01 22:57:24' OR articles.publish_up IS NULL)
AND (articles.publish_down = '0000-00-00 00:00:00' OR articles.publish_down >= '2011-01-01 22:57:24' OR articles.publish_down IS NULL)
AND (cc.published=1 OR cc.published IS NULL)
AND (s.published=1 OR s.published IS NULL)
AND ( (articles.access <= 0
AND cc.access <= 0
AND s.access <= 0) OR (articles.access IS NULL
AND cc.access IS NULL
AND s.access IS NULL) )
ORDER BY ordering
197.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 94
198.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 98
199.
SELECT oldurl, dateadd
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_user&lang=en'
200.
SELECT *
FROM uscs_modules AS m
WHERE m.access <= 0
AND m.client_id = 0
AND ( m.title='118' OR m.id=118 )
AND m.published = 1
ORDER BY ordering
LIMIT 1
201.
SELECT params
FROM uscs_advancedmodules
WHERE moduleid = 118
202.
SELECT id, metadesc, metakey, metatitle, metalang, metarobots
FROM uscs_sh404SEF_meta
WHERE newurl = 'index.php?3de69ea13a27d1ead96ff5d7b47efae3'
203.
SELECT oldurl, dateadd
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_jevents&Itemid=48&day=02&lang=en&month=11&task=icalevent.edit&year=2010'
204.
SELECT oldurl
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_jevents&Itemid=48&lang=en&task=icalevent.edit'
205.
SELECT oldurl, dateadd
FROM uscs_redirection
WHERE newurl = 'index.php?option=com_community&lang=en&task=video&videoid=31&view=videos'
Language Files Loaded
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.com_flexiaccess.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.mod_menu.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_system_modulesanywhere.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.com_flexicontent.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_system_captcha.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.plg_system_debug.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_system_osolcaptcha.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_system_jcemediabox.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.com_jcomments.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_checkbox.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_checkboximage.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_core.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_date.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_email.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_extendedweblink.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_file.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_image.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_linkslist.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_minigallery.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_radio.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_radioimage.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_select.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_selectmultiple.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_text.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_textarea.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_weblink.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_flexicontent_fields_jlikeflexi.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.plg_content_pagebreak.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.tpl_savvypandajoomlatemplate.ini
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_mainmenu.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_kunenalatest.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.com_kunena.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_jevents_latest.ini
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.com_jevents.ini 1
* /home/uscombat/public_html/tempdev/templates/savvypandajoomlatemplate/language/en-GB/en-GB.com_jevents.ini
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_jevents_jevcustomfields.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_jevents_jevfeatured.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_jevents_jevfiles.ini 1
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_jevents_jevusers.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.plg_jevents_jevusers.ini
* /home/uscombat/public_html/tempdev/administrator/language/en-GB/en-GB.plg_jevents_jevtags.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_apoll.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_latestvideos.ini
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_breadcrumbs.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_fpss.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_rokajaxsearch.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_yoo_login.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_easinesslogin.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_settler.ini 1
* /home/uscombat/public_html/tempdev/language/en-GB/en-GB.mod_OpenX.ini
Untranslated Strings Diagnostic
None
Untranslated Strings Designer
None
Please Log in or Create an account to join the conversation.
13 years 10 months ago #12746
by micker
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
Replied by micker on topic Debug shows same queries over and over? Is this a error?
hello
you load a lot of content ?
do you use many template of flexicontent ?
do you have a real link to see it ?
regards
you load a lot of content ?
do you use many template of flexicontent ?
do you have a real link to see it ?
regards
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
Please Log in or Create an account to join the conversation.
13 years 10 months ago #12768
by gswahhab
Replied by gswahhab on topic Debug shows same queries over and over? Is this a error?
its not that much content. only 10 articles.
the page i pulled the debug from is here
uscombatsports.com/tempdev/
the live site is here
uscombatsports.com/
Aida news is turned on, on the live page (its off on the dev site)however it accounts for about 156 queries 6 modules with 5 links each. It has 1 query for each comment, each image and each link so i am most likely going to have to tone it down or drop it in the future. because that is killing my load time.
Flexi though is accounting for 80 - 100 queries to display only 10 articles. i don't know if there is something wrong with our template, something else is going on or if this is normal. I can see that it is loading a lot of dummy queries as well like looking for mp3's when they will never display on the front page or many duplicate queries.
Page load time right now on the live site is 10 seconds with caching(joomla and flexi) and gzip turned on.
If i turn off aida news it is 3 - 5 seconds but this is still excessive.
Hoping a second set of eyes can see any mistakes we may have made.
Here is my template code for category_items.php
Thanks for the help
the page i pulled the debug from is here
uscombatsports.com/tempdev/
the live site is here
uscombatsports.com/
Aida news is turned on, on the live page (its off on the dev site)however it accounts for about 156 queries 6 modules with 5 links each. It has 1 query for each comment, each image and each link so i am most likely going to have to tone it down or drop it in the future. because that is killing my load time.
Flexi though is accounting for 80 - 100 queries to display only 10 articles. i don't know if there is something wrong with our template, something else is going on or if this is normal. I can see that it is loading a lot of dummy queries as well like looking for mp3's when they will never display on the front page or many duplicate queries.
Page load time right now on the live site is 10 seconds with caching(joomla and flexi) and gzip turned on.
If i turn off aida news it is 3 - 5 seconds but this is still excessive.
Hoping a second set of eyes can see any mistakes we may have made.
Here is my template code for category_items.php
Code:
<?php
/**
* @version 1.5 stable $Id: category_items.php 171 2010-03-20 00:44:02Z emmanuel.danan $
* @package Joomla
* @subpackage FLEXIcontent
* @copyright (C) 2009 Emmanuel Danan - www.vistamedia.fr
* @license GNU/GPL v2
*
* FLEXIcontent is a derivative work of the excellent QuickFAQ component
* @copyright (C) 2008 Christoph Lukes
* see www.schlu.net for more information
*
* FLEXIcontent is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*/
defined( '_JEXEC' ) or die( 'Restricted access' );
// first define the template name
$tmpl = $this->tmpl;
?>
<?php if ((($this->params->get('use_filters', 0)) && $this->filters) || ($this->params->get('use_search')) || ($this->params->get('show_alpha', 1))) : ?>
<form action="<?php echo $this->action; ?>" method="post" id="adminForm">
<?php if ((($this->params->get('use_filters', 0)) && $this->filters) || ($this->params->get('use_search'))) : ?>
<div id="fc_filter" class="floattext">
<?php if ($this->params->get('use_search')) : ?>
<div class="fc_fleft">
<input type="text" name="filter" id="filter" value="<?php echo $this->lists['filter'];?>" class="text_area" onchange="document.getElementById('adminForm').submit();" />
<button onclick="document.getElementById('adminForm').submit();"><?php echo JText::_( 'FLEXI_GO' ); ?></button>
<button onclick="document.getElementById('filter').value='';document.getElementById('adminForm').submit();"><?php echo JText::_( 'FLEXI_RESET' ); ?></button>
</div>
<?php endif; ?>
<?php if (($this->params->get('use_filters', 0)) && $this->filters) : ?>
<div class="fc_fright">
<?php
/*
echo '<span class="filter">';
echo 'Saison: ' . $this->filters['field24']->html;
echo '</span>';
*/
foreach ($this->filters as $filt) :
echo '<span class="filter">';
echo $filt->html;
echo '</span>';
endforeach;
?>
</div>
<?php endif; ?>
</div>
<?php endif; ?>
<?php
if ($this->params->get('show_alpha', 1)) :
echo $this->loadTemplate('alpha');
endif;
?>
<input type="hidden" name="option" value="com_flexicontent" />
<input type="hidden" name="filter_order" value="<?php echo $this->lists['filter_order']; ?>" />
<input type="hidden" name="filter_order_Dir" value="" />
<input type="hidden" name="view" value="category" />
<input type="hidden" name="letter" value="" id="alpha_index" />
<input type="hidden" name="task" value="" />
<input type="hidden" name="id" value="<?php echo $this->category->id; ?>" />
</form>
<?php endif; ?>
<?php
$items = $this->items;
$count = count($items);
if ($count) :
?>
<div class="content">
<?php
$leadnum = $this->params->get('lead_num', 2);
$leadnum = ($leadnum >= $count) ? $count : $leadnum;
if ($this->limitstart == 0) :
?>
<ul class="leadingblock">
<?php for ($i=0; $i<$leadnum; $i++) :
?>
<li>
<div class="frontpage_divs" style="overflow: hidden;">
<?php
if ($this->params->get('lead_use_image', 1)) :
if ($this->params->get('lead_image')) :
if (isset($items[$i]->fields[$this->params->get('lead_image')]->value[0])) :
$dir{$i} = $items[$i]->fields[$this->params->get('lead_image')]->parameters->get('dir');
$value{$i} = unserialize($items[$i]->fields[$this->params->get('lead_image')]->value[0]);
$image{$i} = $value{$i}['originalname'];
$scr{$i} = $dir{$i}.($this->params->get('lead_image_size') ? '/'.$this->params->get('lead_image_size').'_' : '/l_').$image{$i};
else :
$scr{$i} = '';
endif;
$src = $scr{$i};
else :
$src = flexicontent_html::extractimagesrc($items[$i]);
endif;
$w = '&w=' . $this->params->get('lead_width', 200);
$h = '&h=' . $this->params->get('lead_height', 200);
$aoe = '&aoe=1';
$q = '&q=95';
$zc = $this->params->get('lead_method') ? '&zc=' . $this->params->get('lead_method') : '';
$conf = $w . $h . $aoe . $q . $zc;
if (!$this->params->get('lead_image_size')) :
$thumb = JURI::base().'components/com_flexicontent/librairies/phpthumb/phpThumb.php?src='.JURI::base(true).'/'.$src.$conf;
else :
$thumb = $src;
endif;
if ($src) : // case source
?>
<!--This is where the image is -->
<div class="flexi_image">
<?php if ($this->params->get('lead_link_image', 1)) : ?>
<a href="<?php echo JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug)); ?>" title="<?php echo JText::_( 'FLEXI_READ_MORE_ABOUT' ) . '::' . $this->escape($items[$i]->title); ?>">
<img src="<?php echo $thumb; ?>" alt="<?php echo $this->escape($items[$i]->title); ?>" />
<?php else : ?>
<img src="<?php echo $thumb; ?>" alt="<?php echo $this->escape($items[$i]->title); ?>" />
<?php endif; ?>
<div class="clear"></div>
</div>
<?php
endif; // case source
endif;
?>
<!-- BOF above-description-line1 block -->
<?php if (isset($items[$i]->positions['above-description-line1'])) : ?>
<div class="lineinfo line1">
<?php foreach ($items[$i]->positions['above-description-line1'] as $field) : ?>
<span class="element">
<?php if ($field->label) : ?>
<span class="label field_<?php echo $field->name; ?>"><?php echo $field->label; ?></span>
<?php endif; ?>
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF above-description-line1 block -->
<!-- BOF above-description-nolabel-line1 block -->
<?php if (isset($items[$i]->positions['above-description-line1-nolabel'])) : ?>
<div class="lineinfo line1">
<?php foreach ($items[$i]->positions['above-description-line1-nolabel'] as $field) : ?>
<span class="element">
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF above-description-nolabel-line1 block -->
<!-- BOF above-description-line2 block -->
<?php if (isset($items[$i]->positions['above-description-line2'])) : ?>
<div class="lineinfo line2">
<?php foreach ($items[$i]->positions['above-description-line2'] as $field) : ?>
<span class="element">
<?php if ($field->label) : ?>
<span class="label field_<?php echo $field->name; ?>"><?php echo $field->label; ?></span>
<?php endif; ?>
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF above-description-line2 block -->
<!-- BOF above-description-nolabel-line2 block -->
<?php if (isset($items[$i]->positions['above-description-line2-nolabel'])) : ?>
<div class="lineinfo line1">
<?php foreach ($items[$i]->positions['above-description-line2-nolabel'] as $field) : ?>
<span class="element">
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF above-description-nolabel-line1 block -->
<div class="descriptive">
<?php if ($this->params->get('show_title', 1)) : ?>
<h2 class="flexi_heading">
<?php if ($this->params->get('link_titles', 0)) : ?>
<a href="<?php echo JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug)); ?>" class="holding_ellipsis auto"><span class="ellipsis_text ellipsis">
<?php
//alex - trimming the flexicontent title so it doesn't extend to three lines... using flexicontent's built in strip and cut function to do it
echo flexicontent_html::striptagsandcut( $this->escape($items[$i]->title), $this->params->get('title_cut_text', 73) );
?>
</span>
<?php
else :
echo $this->escape($items[$i]->title);
endif;
?>
</h2>
<?php endif; ?>
<!--This is the description text-->
<div class="flexi_text">
<p class="flexi_description">
<?php
if ($this->params->get('lead_strip_html', 1)) :
echo flexicontent_html::striptagsandcut( $items[$i]->introtext, $this->params->get('lead_cut_text', 400) );
else :
echo $items[$i]->introtext;
endif;
?>
</p>
</div>
<!--End of description text-->
<!--This is the readmore-->
<?php if ($this->params->get('show_readmore', 1)) : ?>
<div class="readmore">
<a href="<?php echo JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug)); ?>" class="readon">
<?php
if ($items[$i]->params->get('readmore')) :
echo ' ' . $items[$i]->params->get('readmore');
else :
echo ' ' . JText::sprintf('FLEXI_READ_MORE', $items[$i]->title);
endif;
?>
</div>
<?php endif; ?>
<!-- End of readmore -->
<div class="comment">
<?php
if (file_exists(JPATH_SITE.DS.'components'.DS.'com_jcomments'.DS.'jcomments.php')) :
require_once(JPATH_SITE.DS.'components'.DS.'com_jcomments'.DS.'jcomments.php');
$jcomment_count = JComments::getCommentsCount($items[$i]->id, 'com_flexicontent');
if($jcomment_count == '0') :
$comment_link = JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug));
echo "<a class=\"comments_black\" href=\"$comment_link#addcomments\">Add Comment";
endif;
if($jcomment_count > '0') :
$comments_with_counter = JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug));
$comments_bubble = "<img src=\"images/comment_bubble.gif\" />";
echo "<a class=\"comments_black\" href=\"$comments_with_counter#addcomments\"><span class=\"bubble_left\">Comments ($jcomment_count)</span><span class=\"bubble_right\">$comments_bubble</span>";
endif;
endif;
?>
</div>
<!-- BOF under-description-line1 block -->
<?php if (isset($items[$i]->positions['under-description-line1'])) : ?>
<div class="lineinfo line3">
<?php foreach ($items[$i]->positions['under-description-line1'] as $field) : ?>
<span class="element">
<?php if ($field->label) : ?>
<span class="label field_<?php echo $field->name; ?>"><?php echo $field->label; ?></span>
<?php endif; ?>
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF under-description-line1 block -->
<!-- BOF under-description-line1-nolabel block -->
<?php if (isset($items[$i]->positions['under-description-line1-nolabel'])) : ?>
<div class="lineinfo line3">
<?php foreach ($items[$i]->positions['under-description-line1-nolabel'] as $field) : ?>
<span class="element">
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF under-description-line1-nolabel block -->
<!-- BOF under-description-line2 block -->
<?php if (isset($items[$i]->positions['under-description-line2'])) : ?>
<div class="lineinfo line4">
<?php foreach ($items[$i]->positions['under-description-line2'] as $field) : ?>
<span class="element">
<?php if ($field->label) : ?>
<span class="label field_<?php echo $field->name; ?>"><?php echo $field->label; ?></span>
<?php endif; ?>
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF under-description-line2 block -->
<!-- BOF under-description-line2-nolabel block -->
<?php if (isset($items[$i]->positions['under-description-line2-nolabel'])) : ?>
<div class="lineinfo line4">
<?php foreach ($items[$i]->positions['under-description-line2-nolabel'] as $field) : ?>
<span class="element">
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF under-description-line2-nolabel block -->
</div>
</li>
<?php endfor; ?>
</ul>
<?php
endif;
if ($count > $leadnum || $this->limitstart != 0) :
?>
<ul class="introblock <?php echo ($this->params->get('intro_cols', 2) == 1) ? 'one' : 'two'; ?>">
<?php for ($i=($this->limitstart == 0 ? $leadnum : 0 ); $i<$count; $i++) : ?>
<li class="<?php echo (($this->limitstart == 0) ? ($i+$leadnum)%2 : $i%2) ? 'even' : 'odd'; ?>">
<div class="frontpage_second" style="overflow: hidden;">
<?php
if ($this->params->get('intro_use_image', 1)) :
if ($this->params->get('intro_image')) :
if (isset($items[$i]->fields[$this->params->get('intro_image')]->value[0])) :
$dir{$i} = $items[$i]->fields[$this->params->get('intro_image')]->parameters->get('dir');
$value{$i} = unserialize($items[$i]->fields[$this->params->get('intro_image')]->value[0]);
$image{$i} = $value{$i}['originalname'];
$scr{$i} = $dir{$i}.($this->params->get('intro_image_size') ? '/'.$this->params->get('intro_image_size').'_' : '/l_').$image{$i};
else :
$scr{$i} = '';
endif;
$src = $scr{$i};
else :
$src = flexicontent_html::extractimagesrc($items[$i]);
endif;
$w = '&w=' . $this->params->get('intro_width', 200);
$h = '&h=' . $this->params->get('intro_height', 200);
$aoe = '&aoe=1';
$q = '&q=95';
$zc = $this->params->get('intro_method') ? '&zc=' . $this->params->get('intro_method') : '';
$conf = $w . $h . $aoe . $q . $zc;
if (!$this->params->get('intro_image_size')) :
$thumb = JURI::base().'components/com_flexicontent/librairies/phpthumb/phpThumb.php?src='.JURI::base(true).'/'.$src.$conf;
else :
$thumb = $src;
endif;
if ($src) : // case source
?>
<div class="secondary_image">
<?php if ($this->params->get('intro_link_image', 1)) : ?>
<a href="<?php echo JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug)); ?>" title="<?php echo JText::_( 'FLEXI_READ_MORE_ABOUT' ) . '::' . $this->escape($items[$i]->title); ?>">
<img src="<?php echo $thumb; ?>" alt="<?php echo $this->escape($items[$i]->title); ?>" />
<?php else : ?>
<img src="<?php echo $thumb; ?>" alt="<?php echo $this->escape($items[$i]->title); ?>" />
<?php endif; ?>
<div class="clear"></div>
</div>
<?php
endif; // case source
endif;
?>
<div class="secondary_description">
<?php if ($this->params->get('show_title', 1)) : ?>
<h2 class="flexi_secondheading">
<?php if ($this->params->get('link_titles', 0)) : ?>
[url=<?php echo JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug)); ?>" class="second_ellipsis]<span class="ellipsis_text"><?php echo $this->escape($items[$i]->title); ?></span>[/url]
<?php
else :
echo $this->escape($items[$i]->title);
endif;
?>
</h2>
<?php endif; ?>
<div class="secondary_text">
<?php
if ($this->params->get('intro_strip_html', 1)) :
echo flexicontent_html::striptagsandcut( $items[$i]->introtext, $this->params->get('intro_cut_text', 200) );
else :
echo $items[$i]->introtext;
endif;
?>
</div>
<div class="pushdown_second">
<div class="comment">
<?php
if (file_exists(JPATH_SITE.DS.'components'.DS.'com_jcomments'.DS.'jcomments.php')) :
require_once(JPATH_SITE.DS.'components'.DS.'com_jcomments'.DS.'jcomments.php');
$jcomment_count = JComments::getCommentsCount($items[$i]->id, 'com_flexicontent');
if($jcomment_count == '0') :
$comment_link = JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug));
echo "<a class=\"comments_black\" href=\"$comment_link#addcomments\">Add Comment";
endif;
if($jcomment_count > '0') :
$comments_with_counter = JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug));
$comments_bubble = "<img src=\"images/comment_bubble.gif\" />";
echo "<a class=\"comments_black\" href=\"$comments_with_counter#addcomments\"><span class=\"bubble_left\">Comments ($jcomment_count)</span><span class=\"bubble_right\">$comments_bubble</span>";
endif;
endif;
?>
</div>
<!--alex - old comments without the "add comment" text when secondary articles were being used <div class="intro_comments">
<?php
if (file_exists(JPATH_SITE.DS.'components'.DS.'com_jcomments'.DS.'jcomments.php')) :
require_once(JPATH_SITE.DS.'components'.DS.'com_jcomments'.DS.'jcomments.php');
$jcomment_count = JComments::getCommentsCount($items[$i]->id, 'com_flexicontent');
if($jcomment_count == '0') :
$comment_link = JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug));
$comments_bubble_1 = "<img src=\"images/comment_bubble.gif\" />";
echo "<a class=\"comments_black\" href=\"$comment_link#addcomments\"><span class=\"bubble_left\">(0)</span> <span class=\"bubble_right\">$comments_bubble_1</span>";
endif;
if($jcomment_count > '0') :
$comments_with_counter = JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug));
$comments_bubble = "<img src=\"images/comment_bubble.gif\" />";
echo "<a class=\"comments_black\" href=\"$comments_with_counter#addcomments\"><span class=\"bubble_left\">($jcomment_count)</span><span class=\"bubble_right\">$comments_bubble</span>";
endif;
endif;
?>
</div>-->
<?php if ($this->params->get('show_readmore', 1)) : ?>
<div class="readmore">
<a href="<?php echo JRoute::_(FlexicontentHelperRoute::getItemRoute($items[$i]->slug, $this->category->slug)); ?>" class="readon">
<?php
if ($items[$i]->params->get('readmore')) :
echo ' ' . $items[$i]->params->get('readmore');
else :
echo ' ' . JText::sprintf('FLEXI_READ_MORE', $items[$i]->title);
endif;
?>
</div>
<?php endif; ?>
</div>
</div>
<!-- BOF above-description-line1 block -->
<?php if (isset($items[$i]->positions['above-description-line1'])) : ?>
<div class="lineinfo line1">
<?php foreach ($items[$i]->positions['above-description-line1'] as $field) : ?>
<span class="element">
<?php if ($field->label) : ?>
<span class="label field_<?php echo $field->name; ?>"><?php echo $field->label; ?></span>
<?php endif; ?>
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF above-description-line1 block -->
<!-- BOF above-description-nolabel-line1 block -->
<?php if (isset($items[$i]->positions['above-description-line1-nolabel'])) : ?>
<div class="lineinfo line1">
<?php foreach ($items[$i]->positions['above-description-line1-nolabel'] as $field) : ?>
<span class="element">
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF above-description-nolabel-line1 block -->
<!-- BOF above-description-line2 block -->
<?php if (isset($items[$i]->positions['above-description-line2'])) : ?>
<div class="lineinfo line2">
<?php foreach ($items[$i]->positions['above-description-line2'] as $field) : ?>
<span class="element">
<?php if ($field->label) : ?>
<span class="label field_<?php echo $field->name; ?>"><?php echo $field->label; ?></span>
<?php endif; ?>
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF above-description-line2 block -->
<!-- BOF above-description-nolabel-line2 block -->
<?php if (isset($items[$i]->positions['above-description-line2-nolabel'])) : ?>
<div class="lineinfo line1">
<?php foreach ($items[$i]->positions['above-description-line2-nolabel'] as $field) : ?>
<span class="element">
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF above-description-nolabel-line1 block -->
<!-- BOF under-description-line1 block -->
<?php if (isset($items[$i]->positions['under-description-line1'])) : ?>
<div class="lineinfo line3">
<?php foreach ($items[$i]->positions['under-description-line1'] as $field) : ?>
<span class="element">
<?php if ($field->label) : ?>
<span class="label field_<?php echo $field->name; ?>"><?php echo $field->label; ?></span>
<?php endif; ?>
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF under-description-line1 block -->
<!-- BOF under-description-line1-nolabel block -->
<?php if (isset($items[$i]->positions['under-description-line1-nolabel'])) : ?>
<div class="lineinfo line3">
<?php foreach ($items[$i]->positions['under-description-line1-nolabel'] as $field) : ?>
<span class="element">
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF under-description-line1-nolabel block -->
<!-- BOF under-description-line2 block -->
<?php if (isset($items[$i]->positions['under-description-line2'])) : ?>
<div class="lineinfo line4">
<?php foreach ($items[$i]->positions['under-description-line2'] as $field) : ?>
<span class="element">
<?php if ($field->label) : ?>
<span class="label field_<?php echo $field->name; ?>"><?php echo $field->label; ?></span>
<?php endif; ?>
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF under-description-line2 block -->
<!-- BOF under-description-line2-nolabel block -->
<?php if (isset($items[$i]->positions['under-description-line2-nolabel'])) : ?>
<div class="lineinfo line4">
<?php foreach ($items[$i]->positions['under-description-line2-nolabel'] as $field) : ?>
<span class="element">
<span class="value field_<?php echo $field->name; ?>"><?php echo $field->display; ?></span>
</span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<!-- EOF under-description-line2-nolabel block -->
</div>
</li>
<?php endfor; ?>
</ul>
<?php endif; ?>
</div>
<?php else : ?>
<div class="noitems"><?php echo JText::_( 'FLEXI_NO_ITEMS_CAT' ); ?></div>
<?php endif; ?>
Thanks for the help
Please Log in or Create an account to join the conversation.
13 years 10 months ago #12770
by micker
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
Replied by micker on topic Debug shows same queries over and over? Is this a error?
for aidanews try 2.0 beta 3 the request are increase ...
for me your site works well
for me your site works well
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
Please Log in or Create an account to join the conversation.
13 years 10 months ago #12774
by gswahhab
Replied by gswahhab on topic Debug shows same queries over and over? Is this a error?
i am testing the beta on the dev site it has helped a little but still to many database queries.
you didn't notice the duplicate queries or the unnecessary queries i was talking about on the
uscombatsports.com/tempdev site?
If you look there are duplicate queries and queries for files like mp3
you didn't notice the duplicate queries or the unnecessary queries i was talking about on the
uscombatsports.com/tempdev site?
If you look there are duplicate queries and queries for files like mp3
Please Log in or Create an account to join the conversation.
Time to create page: 0.468 seconds
