SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002986s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050707s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19798773 LIMIT 5 [ RunTime:0.024791s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19798773 ORDER BY `minOrder` ASC [ RunTime:0.016697s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19798773 ORDER BY `unit` DESC [ RunTime:0.023652s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19798773 LIMIT 2 [ RunTime:0.015962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19798773 ORDER BY `minOrder` ASC [ RunTime:0.006056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19795013 LIMIT 5 [ RunTime:0.016263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19795013 ORDER BY `minOrder` ASC [ RunTime:0.006009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19795013 ORDER BY `unit` DESC [ RunTime:0.041432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19795013 LIMIT 2 [ RunTime:0.014618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19795013 ORDER BY `minOrder` ASC [ RunTime:0.040291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19779782 LIMIT 5 [ RunTime:0.029524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19779782 ORDER BY `minOrder` ASC [ RunTime:0.047328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19779782 ORDER BY `unit` DESC [ RunTime:0.033163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19779782 LIMIT 2 [ RunTime:0.026696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19779782 ORDER BY `minOrder` ASC [ RunTime:0.006004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19273395 LIMIT 5 [ RunTime:0.046504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19273395 ORDER BY `minOrder` ASC [ RunTime:0.047881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19273395 ORDER BY `unit` DESC [ RunTime:0.030980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19273395 LIMIT 2 [ RunTime:0.026120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19273395 ORDER BY `minOrder` ASC [ RunTime:0.024818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345395 LIMIT 5 [ RunTime:0.027764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345395 ORDER BY `minOrder` ASC [ RunTime:0.023950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345395 ORDER BY `unit` DESC [ RunTime:0.037153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345395 LIMIT 2 [ RunTime:0.076936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345395 ORDER BY `minOrder` ASC [ RunTime:0.105853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738901 LIMIT 5 [ RunTime:0.044965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738901 ORDER BY `minOrder` ASC [ RunTime:0.012980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12738901 ORDER BY `unit` DESC [ RunTime:0.057906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12738901 LIMIT 2 [ RunTime:0.043460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738901 ORDER BY `minOrder` ASC [ RunTime:0.005344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12729806 LIMIT 5 [ RunTime:0.046732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12729806 ORDER BY `minOrder` ASC [ RunTime:0.042832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12729806 ORDER BY `unit` DESC [ RunTime:0.043454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12729806 LIMIT 2 [ RunTime:0.047405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12729806 ORDER BY `minOrder` ASC [ RunTime:0.018069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11601197 LIMIT 5 [ RunTime:0.074908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11601197 ORDER BY `minOrder` ASC [ RunTime:0.150204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11601197 ORDER BY `unit` DESC [ RunTime:0.049030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11601197 LIMIT 2 [ RunTime:0.233701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11601197 ORDER BY `minOrder` ASC [ RunTime:0.057042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11567678 LIMIT 5 [ RunTime:0.212147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11567678 ORDER BY `minOrder` ASC [ RunTime:0.055070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11567678 ORDER BY `unit` DESC [ RunTime:0.177222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11567678 LIMIT 2 [ RunTime:0.142945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11567678 ORDER BY `minOrder` ASC [ RunTime:0.110027s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.113626s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52825787 LIMIT 5 [ RunTime:0.091090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52825787 ORDER BY `minOrder` ASC [ RunTime:0.105582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52825787 ORDER BY `unit` DESC [ RunTime:0.150264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52825787 LIMIT 2 [ RunTime:0.021760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52825787 ORDER BY `minOrder` ASC [ RunTime:0.061832s ]
select * from pdf where partno='102159-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.075321s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102159-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.052446s ]
SELECT `id` FROM `stock` WHERE `id` <> 52825787 AND `partno` = '102159-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.101509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738901 [ RunTime:0.067918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52817106 LIMIT 5 [ RunTime:0.035549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52817106 ORDER BY `minOrder` ASC [ RunTime:0.151994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52817106 ORDER BY `unit` DESC [ RunTime:0.036974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52817106 LIMIT 2 [ RunTime:0.123994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52817106 ORDER BY `minOrder` ASC [ RunTime:0.048469s ]
select * from pdf where partno='102159-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.058645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102159-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.091168s ]
SELECT `id` FROM `stock` WHERE `id` <> 52817106 AND `partno` = '102159-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.097280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19798773 [ RunTime:0.124866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52810102 LIMIT 5 [ RunTime:0.110282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52810102 ORDER BY `minOrder` ASC [ RunTime:0.105039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52810102 ORDER BY `unit` DESC [ RunTime:0.106263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52810102 LIMIT 2 [ RunTime:0.051645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52810102 ORDER BY `minOrder` ASC [ RunTime:0.035478s ]
select * from pdf where partno='102159-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.033285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102159-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.047960s ]
SELECT `id` FROM `stock` WHERE `id` <> 52810102 AND `partno` = '102159-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.081105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11601197 [ RunTime:0.072691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52809637 LIMIT 5 [ RunTime:0.063050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52809637 ORDER BY `minOrder` ASC [ RunTime:0.168405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52809637 ORDER BY `unit` DESC [ RunTime:0.091448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52809637 LIMIT 2 [ RunTime:0.139624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52809637 ORDER BY `minOrder` ASC [ RunTime:0.043932s ]
select * from pdf where partno='102159-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.023510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102159-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.111907s ]
SELECT `id` FROM `stock` WHERE `id` <> 52809637 AND `partno` = '102159-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.202449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19795013 [ RunTime:0.109093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52787488 LIMIT 5 [ RunTime:0.041599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52787488 ORDER BY `minOrder` ASC [ RunTime:0.144523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52787488 ORDER BY `unit` DESC [ RunTime:0.084054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52787488 LIMIT 2 [ RunTime:0.103848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52787488 ORDER BY `minOrder` ASC [ RunTime:0.078631s ]
select * from pdf where partno='102159-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.042550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '102159-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.120210s ]
SELECT `id` FROM `stock` WHERE `id` <> 52787488 AND `partno` = '102159-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.161645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11567678 [ RunTime:0.173573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43772420 LIMIT 5 [ RunTime:0.186065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43772420 ORDER BY `minOrder` ASC [ RunTime:0.122491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43772420 ORDER BY `unit` DESC [ RunTime:0.076468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43772420 LIMIT 2 [ RunTime:0.203550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43772420 ORDER BY `minOrder` ASC [ RunTime:0.022116s ]
select * from pdf where partno='1021593' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.091720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1021593' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.044704s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.118456s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.123505s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.102163s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.254061s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.172269s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.156304s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.203282s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '102159%' OR `brand` LIKE '102159%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.071391s ]