SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002665s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008903s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11377592 LIMIT 5 [ RunTime:0.003027s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11377592 ORDER BY `minOrder` ASC [ RunTime:0.001531s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11377592 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11377592 LIMIT 2 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11377592 ORDER BY `minOrder` ASC [ RunTime:0.000205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11377625 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11377625 ORDER BY `minOrder` ASC [ RunTime:0.003294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11377625 ORDER BY `unit` DESC [ RunTime:0.005770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11377625 LIMIT 2 [ RunTime:0.004524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11377625 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469830 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469830 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12469830 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12469830 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469830 ORDER BY `minOrder` ASC [ RunTime:0.000206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469134 LIMIT 5 [ RunTime:0.001361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469134 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12469134 ORDER BY `unit` DESC [ RunTime:0.005494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12469134 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469134 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469083 LIMIT 5 [ RunTime:0.003010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469083 ORDER BY `minOrder` ASC [ RunTime:0.004105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12469083 ORDER BY `unit` DESC [ RunTime:0.005867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12469083 LIMIT 2 [ RunTime:0.010840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469083 ORDER BY `minOrder` ASC [ RunTime:0.008423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469040 LIMIT 5 [ RunTime:0.002795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469040 ORDER BY `minOrder` ASC [ RunTime:0.002881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12469040 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12469040 LIMIT 2 [ RunTime:0.003061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469040 ORDER BY `minOrder` ASC [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469031 LIMIT 5 [ RunTime:0.007084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469031 ORDER BY `minOrder` ASC [ RunTime:0.002755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12469031 ORDER BY `unit` DESC [ RunTime:0.010066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12469031 LIMIT 2 [ RunTime:0.010062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12469031 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468989 LIMIT 5 [ RunTime:0.004948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468989 ORDER BY `minOrder` ASC [ RunTime:0.012441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12468989 ORDER BY `unit` DESC [ RunTime:0.003378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12468989 LIMIT 2 [ RunTime:0.022573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12468989 ORDER BY `minOrder` ASC [ RunTime:0.003877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11379254 LIMIT 5 [ RunTime:0.004593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11379254 ORDER BY `minOrder` ASC [ RunTime:0.015262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11379254 ORDER BY `unit` DESC [ RunTime:0.030786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11379254 LIMIT 2 [ RunTime:0.006026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11379254 ORDER BY `minOrder` ASC [ RunTime:0.012202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11379128 LIMIT 5 [ RunTime:0.014750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11379128 ORDER BY `minOrder` ASC [ RunTime:0.006515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11379128 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11379128 LIMIT 2 [ RunTime:0.002739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11379128 ORDER BY `minOrder` ASC [ RunTime:0.009684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11379046 LIMIT 5 [ RunTime:0.001403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11379046 ORDER BY `minOrder` ASC [ RunTime:0.002182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11379046 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11379046 LIMIT 2 [ RunTime:0.002736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11379046 ORDER BY `minOrder` ASC [ RunTime:0.001520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11379034 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11379034 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11379034 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11379034 LIMIT 2 [ RunTime:0.002259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11379034 ORDER BY `minOrder` ASC [ RunTime:0.001521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378957 LIMIT 5 [ RunTime:0.006127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378957 ORDER BY `minOrder` ASC [ RunTime:0.002233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11378957 ORDER BY `unit` DESC [ RunTime:0.003277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11378957 LIMIT 2 [ RunTime:0.002515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11378957 ORDER BY `minOrder` ASC [ RunTime:0.004482s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005418s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44085021 LIMIT 5 [ RunTime:0.002901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44085021 ORDER BY `minOrder` ASC [ RunTime:0.002323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44085021 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44085021 LIMIT 2 [ RunTime:0.001779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44085021 ORDER BY `minOrder` ASC [ RunTime:0.005872s ]
select * from pdf where partno='HS5F' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.007930s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.006637s ]
SELECT `id` FROM `stock` WHERE `id` <> 44085021 AND `partno` = 'HS5F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.015972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44087655 LIMIT 5 [ RunTime:0.005185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44087655 ORDER BY `minOrder` ASC [ RunTime:0.007064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44087655 ORDER BY `unit` DESC [ RunTime:0.004745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44087655 LIMIT 2 [ RunTime:0.004201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44087655 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='HS5FH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.004301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5FH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.012768s ]
SELECT `id` FROM `stock` WHERE `id` <> 44087655 AND `partno` = 'HS5FH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.004084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51376343 LIMIT 5 [ RunTime:0.006455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51376343 ORDER BY `minOrder` ASC [ RunTime:0.003937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51376343 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51376343 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51376343 ORDER BY `minOrder` ASC [ RunTime:0.001370s ]
select * from pdf where partno='HS5F3AS' and brandshort='SolaHD' limit 1 [ RunTime:0.001992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F3AS' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.009672s ]
SELECT `id` FROM `stock` WHERE `id` <> 51376343 AND `partno` = 'HS5F3AS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.000955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11377592 [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51376345 LIMIT 5 [ RunTime:0.004979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51376345 ORDER BY `minOrder` ASC [ RunTime:0.007055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51376345 ORDER BY `unit` DESC [ RunTime:0.022138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51376345 LIMIT 2 [ RunTime:0.007975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51376345 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='HS5F7.5AS' and brandshort='SolaHD' limit 1 [ RunTime:0.000666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F7.5AS' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.000443s ]
SELECT `id` FROM `stock` WHERE `id` <> 51376345 AND `partno` = 'HS5F7.5AS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.012672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51380940 LIMIT 5 [ RunTime:0.009819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380940 ORDER BY `minOrder` ASC [ RunTime:0.008308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51380940 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51380940 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380940 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
select * from pdf where partno='HS5F25BS' and brandshort='SolaHD' limit 1 [ RunTime:0.000510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F25BS' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.004517s ]
SELECT `id` FROM `stock` WHERE `id` <> 51380940 AND `partno` = 'HS5F25BS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.006166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11379254 [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51380887 LIMIT 5 [ RunTime:0.001852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380887 ORDER BY `minOrder` ASC [ RunTime:0.001826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51380887 ORDER BY `unit` DESC [ RunTime:0.000224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51380887 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380887 ORDER BY `minOrder` ASC [ RunTime:0.004279s ]
select * from pdf where partno='HS5F15BS' and brandshort='SolaHD' limit 1 [ RunTime:0.000292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F15BS' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.000222s ]
SELECT `id` FROM `stock` WHERE `id` <> 51380887 AND `partno` = 'HS5F15BS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.000227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469134 [ RunTime:0.000198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51380749 LIMIT 5 [ RunTime:0.006205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380749 ORDER BY `minOrder` ASC [ RunTime:0.007251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51380749 ORDER BY `unit` DESC [ RunTime:0.002405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51380749 LIMIT 2 [ RunTime:0.005855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380749 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='HS5F10AS12' and brandshort='SolaHD' limit 1 [ RunTime:0.000848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F10AS12' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.000897s ]
SELECT `id` FROM `stock` WHERE `id` <> 51380749 AND `partno` = 'HS5F10AS12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.000517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469083 [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51380686 LIMIT 5 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380686 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51380686 ORDER BY `unit` DESC [ RunTime:0.008539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51380686 LIMIT 2 [ RunTime:0.011928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380686 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='HS5F75ASCU' and brandshort='SolaHD' limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F75ASCU' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.005000s ]
SELECT `id` FROM `stock` WHERE `id` <> 51380686 AND `partno` = 'HS5F75ASCU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.022143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469040 [ RunTime:0.000892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51380665 LIMIT 5 [ RunTime:0.008614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380665 ORDER BY `minOrder` ASC [ RunTime:0.003289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51380665 ORDER BY `unit` DESC [ RunTime:0.004976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51380665 LIMIT 2 [ RunTime:0.008327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380665 ORDER BY `minOrder` ASC [ RunTime:0.010456s ]
select * from pdf where partno='HS5F5AS12' and brandshort='SolaHD' limit 1 [ RunTime:0.005356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F5AS12' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.012869s ]
SELECT `id` FROM `stock` WHERE `id` <> 51380665 AND `partno` = 'HS5F5AS12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.008061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12469031 [ RunTime:0.012222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51380574 LIMIT 5 [ RunTime:0.004935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380574 ORDER BY `minOrder` ASC [ RunTime:0.004419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51380574 ORDER BY `unit` DESC [ RunTime:0.003452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51380574 LIMIT 2 [ RunTime:0.008661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380574 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='HS5FB3AS' and brandshort='SolaHD' limit 1 [ RunTime:0.000593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5FB3AS' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.002248s ]
SELECT `id` FROM `stock` WHERE `id` <> 51380574 AND `partno` = 'HS5FB3AS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.011691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12468989 [ RunTime:0.004004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51380518 LIMIT 5 [ RunTime:0.019837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380518 ORDER BY `minOrder` ASC [ RunTime:0.016041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51380518 ORDER BY `unit` DESC [ RunTime:0.008139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51380518 LIMIT 2 [ RunTime:0.013045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380518 ORDER BY `minOrder` ASC [ RunTime:0.006830s ]
select * from pdf where partno='HS5F3AS12' and brandshort='SolaHD' limit 1 [ RunTime:0.004748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F3AS12' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.010827s ]
SELECT `id` FROM `stock` WHERE `id` <> 51380518 AND `partno` = 'HS5F3AS12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.002428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11379034 [ RunTime:0.003948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51380495 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380495 ORDER BY `minOrder` ASC [ RunTime:0.002844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51380495 ORDER BY `unit` DESC [ RunTime:0.001064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51380495 LIMIT 2 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51380495 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
select * from pdf where partno='HS5F3ASCU' and brandshort='SolaHD' limit 1 [ RunTime:0.000583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F3ASCU' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.003394s ]
SELECT `id` FROM `stock` WHERE `id` <> 51380495 AND `partno` = 'HS5F3ASCU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.003713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11379046 [ RunTime:0.002178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51377448 LIMIT 5 [ RunTime:0.001817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51377448 ORDER BY `minOrder` ASC [ RunTime:0.010712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51377448 ORDER BY `unit` DESC [ RunTime:0.008583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51377448 LIMIT 2 [ RunTime:0.002440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51377448 ORDER BY `minOrder` ASC [ RunTime:0.002841s ]
select * from pdf where partno='HS5F10AS' and brandshort='SolaHD' limit 1 [ RunTime:0.000843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F10AS' OR `brand` LIKE 'SolaHD%' ) ) LIMIT 1 [ RunTime:0.001480s ]
SELECT `id` FROM `stock` WHERE `id` <> 51377448 AND `partno` = 'HS5F10AS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%solahd%' ) [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11377625 [ RunTime:0.002203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44107945 LIMIT 5 [ RunTime:0.013887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44107945 ORDER BY `minOrder` ASC [ RunTime:0.001739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44107945 ORDER BY `unit` DESC [ RunTime:0.002675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44107945 LIMIT 2 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44107945 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
select * from pdf where partno='HS5F V7G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS5F V7G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.006847s ]
SELECT `id` FROM `stock` WHERE `id` <> 44107945 AND `partno` = 'HS5F V7G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000858s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003543s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002577s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003463s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005917s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007275s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000921s ]
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 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002271s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'HS5F%' OR `brand` LIKE 'HS5F%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001591s ]