SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003075s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021303s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669427 LIMIT 5 [ RunTime:0.001784s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669427 ORDER BY `minOrder` ASC [ RunTime:0.006085s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669427 ORDER BY `unit` DESC [ RunTime:0.012248s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669427 LIMIT 2 [ RunTime:0.003953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669427 ORDER BY `minOrder` ASC [ RunTime:0.005614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672728 LIMIT 5 [ RunTime:0.004918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672728 ORDER BY `minOrder` ASC [ RunTime:0.015415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672728 ORDER BY `unit` DESC [ RunTime:0.004180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672728 LIMIT 2 [ RunTime:0.004676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672728 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672702 LIMIT 5 [ RunTime:0.008135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672702 ORDER BY `minOrder` ASC [ RunTime:0.008302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672702 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672702 LIMIT 2 [ RunTime:0.001510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672702 ORDER BY `minOrder` ASC [ RunTime:0.004514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672645 LIMIT 5 [ RunTime:0.005926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672645 ORDER BY `minOrder` ASC [ RunTime:0.002527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672645 ORDER BY `unit` DESC [ RunTime:0.017115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672645 LIMIT 2 [ RunTime:0.001407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672645 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='FOC-LCMMD25CL' and brandshort='L-com' limit 1 [ RunTime:0.005912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672644 LIMIT 5 [ RunTime:0.008979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672644 ORDER BY `minOrder` ASC [ RunTime:0.010214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672644 ORDER BY `unit` DESC [ RunTime:0.014490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672644 LIMIT 2 [ RunTime:0.031098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672644 ORDER BY `minOrder` ASC [ RunTime:0.010365s ]
select * from pdf where partno='FOC-LCMMD16CL' and brandshort='L-com' limit 1 [ RunTime:0.004351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672627 LIMIT 5 [ RunTime:0.007519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672627 ORDER BY `minOrder` ASC [ RunTime:0.006642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672627 ORDER BY `unit` DESC [ RunTime:0.013042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672627 LIMIT 2 [ RunTime:0.002242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672627 ORDER BY `minOrder` ASC [ RunTime:0.016220s ]
select * from pdf where partno='FOC-LCSMS30Z' and brandshort='L-com' limit 1 [ RunTime:0.024287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672624 LIMIT 5 [ RunTime:0.015669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672624 ORDER BY `minOrder` ASC [ RunTime:0.003985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672624 ORDER BY `unit` DESC [ RunTime:0.001639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672624 LIMIT 2 [ RunTime:0.001206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672624 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672591 LIMIT 5 [ RunTime:0.000896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672591 ORDER BY `minOrder` ASC [ RunTime:0.001068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672591 ORDER BY `unit` DESC [ RunTime:0.000763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672591 LIMIT 2 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672591 ORDER BY `minOrder` ASC [ RunTime:0.007546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672562 LIMIT 5 [ RunTime:0.007292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672562 ORDER BY `minOrder` ASC [ RunTime:0.011188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672562 ORDER BY `unit` DESC [ RunTime:0.005327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672562 LIMIT 2 [ RunTime:0.017165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672562 ORDER BY `minOrder` ASC [ RunTime:0.004116s ]
select * from pdf where partno='FOC-LCSM0230-0U0R' and brandshort='L-com' limit 1 [ RunTime:0.001121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672557 LIMIT 5 [ RunTime:0.002307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672557 ORDER BY `minOrder` ASC [ RunTime:0.003435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672557 ORDER BY `unit` DESC [ RunTime:0.005390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672557 LIMIT 2 [ RunTime:0.009080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672557 ORDER BY `minOrder` ASC [ RunTime:0.013806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672554 LIMIT 5 [ RunTime:0.000999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672554 ORDER BY `minOrder` ASC [ RunTime:0.000779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672554 ORDER BY `unit` DESC [ RunTime:0.007213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672554 LIMIT 2 [ RunTime:0.009248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672554 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='FOC-LCSM0220-0LU0' and brandshort='L-com' limit 1 [ RunTime:0.003576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672549 LIMIT 5 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672549 ORDER BY `minOrder` ASC [ RunTime:0.006916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672549 ORDER BY `unit` DESC [ RunTime:0.002120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672549 LIMIT 2 [ RunTime:0.011936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672549 ORDER BY `minOrder` ASC [ RunTime:0.001098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672548 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672548 ORDER BY `minOrder` ASC [ RunTime:0.009390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672548 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672548 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672548 ORDER BY `minOrder` ASC [ RunTime:0.005779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672536 LIMIT 5 [ RunTime:0.001035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672536 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672536 ORDER BY `unit` DESC [ RunTime:0.011062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672536 LIMIT 2 [ RunTime:0.000993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672536 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672523 LIMIT 5 [ RunTime:0.000926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672523 ORDER BY `minOrder` ASC [ RunTime:0.004087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672523 ORDER BY `unit` DESC [ RunTime:0.003145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672523 LIMIT 2 [ RunTime:0.006217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672523 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672516 LIMIT 5 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672516 ORDER BY `minOrder` ASC [ RunTime:0.006332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672516 ORDER BY `unit` DESC [ RunTime:0.000801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672516 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672516 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672515 LIMIT 5 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672515 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672515 ORDER BY `unit` DESC [ RunTime:0.011187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672515 LIMIT 2 [ RunTime:0.002353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672515 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672508 LIMIT 5 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672508 ORDER BY `minOrder` ASC [ RunTime:0.014611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672508 ORDER BY `unit` DESC [ RunTime:0.002257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672508 LIMIT 2 [ RunTime:0.001444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672508 ORDER BY `minOrder` ASC [ RunTime:0.003134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672497 LIMIT 5 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672497 ORDER BY `minOrder` ASC [ RunTime:0.013801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672497 ORDER BY `unit` DESC [ RunTime:0.005376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672497 LIMIT 2 [ RunTime:0.002232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672497 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='FOC-LCMM0220-AQUER' and brandshort='L-com' limit 1 [ RunTime:0.006175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672496 LIMIT 5 [ RunTime:0.020591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672496 ORDER BY `minOrder` ASC [ RunTime:0.014377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672496 ORDER BY `unit` DESC [ RunTime:0.065081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672496 LIMIT 2 [ RunTime:0.050592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672496 ORDER BY `minOrder` ASC [ RunTime:0.055079s ]
select * from pdf where partno='FOC-LCASM0120-GR0U0' and brandshort='L-com' limit 1 [ RunTime:0.012896s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32265233 LIMIT 5 [ RunTime:0.025868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32265233 ORDER BY `minOrder` ASC [ RunTime:0.022252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32265233 ORDER BY `unit` DESC [ RunTime:0.026787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32265233 LIMIT 2 [ RunTime:0.073406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32265233 ORDER BY `minOrder` ASC [ RunTime:0.015872s ]
select * from pdf where partno='foc-lcmm0230-0sue' and brandshort='l-com' limit 1 [ RunTime:0.019728s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'foc-lcmm0230-0sue' OR `brand` LIKE 'l-com%' ) ) LIMIT 1 [ RunTime:0.022246s ]
SELECT `id` FROM `stock` WHERE `id` <> 32265233 AND `partno` = 'foc-lcmm0230-0sue' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.011955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672508 [ RunTime:0.033067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264773 LIMIT 5 [ RunTime:0.004542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264773 ORDER BY `minOrder` ASC [ RunTime:0.011164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264773 ORDER BY `unit` DESC [ RunTime:0.014509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264773 LIMIT 2 [ RunTime:0.010330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264773 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='foc-lcsmd20fb' and brandshort='l-com' limit 1 [ RunTime:0.006902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'foc-lcsmd20fb' OR `brand` LIKE 'l-com%' ) ) LIMIT 1 [ RunTime:0.021209s ]
SELECT `id` FROM `stock` WHERE `id` <> 32264773 AND `partno` = 'foc-lcsmd20fb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.004033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672702 [ RunTime:0.001565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32228201 LIMIT 5 [ RunTime:0.008222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32228201 ORDER BY `minOrder` ASC [ RunTime:0.013077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32228201 ORDER BY `unit` DESC [ RunTime:0.000801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32228201 LIMIT 2 [ RunTime:0.002656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32228201 ORDER BY `minOrder` ASC [ RunTime:0.008483s ]
select * from pdf where partno='foc-lcsmd20fb' and brandshort='l-com' limit 1 [ RunTime:0.000620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'foc-lcsmd20fb' OR `brand` LIKE 'l-com%' ) ) LIMIT 1 [ RunTime:0.000444s ]
SELECT `id` FROM `stock` WHERE `id` <> 32228201 AND `partno` = 'foc-lcsmd20fb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.002365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672702 [ RunTime:0.000454s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118648 LIMIT 5 [ RunTime:0.001381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118648 ORDER BY `minOrder` ASC [ RunTime:0.001057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118648 ORDER BY `unit` DESC [ RunTime:0.001497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118648 LIMIT 2 [ RunTime:0.001263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118648 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='FOC-LCSMD25CL' and brandshort='L-com' limit 1 [ RunTime:0.001011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSMD25CL' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.011920s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118648 AND `partno` = 'FOC-LCSMD25CL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.000731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672728 [ RunTime:0.007326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118633 LIMIT 5 [ RunTime:0.002407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118633 ORDER BY `minOrder` ASC [ RunTime:0.008034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118633 ORDER BY `unit` DESC [ RunTime:0.001957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118633 LIMIT 2 [ RunTime:0.001087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118633 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='FOC-LCSMD20FB' and brandshort='L-com' limit 1 [ RunTime:0.001515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSMD20FB' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.011984s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118633 AND `partno` = 'FOC-LCSMD20FB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.004584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672702 [ RunTime:0.001400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118620 LIMIT 5 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118620 ORDER BY `minOrder` ASC [ RunTime:0.008374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118620 ORDER BY `unit` DESC [ RunTime:0.002914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118620 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118620 ORDER BY `minOrder` ASC [ RunTime:0.001466s ]
select * from pdf where partno='FOC-LCSM0250-0U0R' and brandshort='L-com' limit 1 [ RunTime:0.002603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSM0250-0U0R' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.008925s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118620 AND `partno` = 'FOC-LCSM0250-0U0R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.003658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672624 [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118557 LIMIT 5 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118557 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118557 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118557 LIMIT 2 [ RunTime:0.001111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118557 ORDER BY `minOrder` ASC [ RunTime:0.005679s ]
select * from pdf where partno='FOC-LCMMD25CL' and brandshort='L-com' limit 1 [ RunTime:0.000771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCMMD25CL' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.009169s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118557 AND `partno` = 'FOC-LCMMD25CL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.002702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672645 [ RunTime:0.003104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118556 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118556 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118556 ORDER BY `unit` DESC [ RunTime:0.009969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118556 LIMIT 2 [ RunTime:0.002528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118556 ORDER BY `minOrder` ASC [ RunTime:0.004506s ]
select * from pdf where partno='FOC-LCMMD16CL' and brandshort='L-com' limit 1 [ RunTime:0.003921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCMMD16CL' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.006903s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118556 AND `partno` = 'FOC-LCMMD16CL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.014115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672644 [ RunTime:0.004485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118536 LIMIT 5 [ RunTime:0.001781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118536 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118536 ORDER BY `unit` DESC [ RunTime:0.012493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118536 LIMIT 2 [ RunTime:0.002516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118536 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
select * from pdf where partno='FOC-LCSMS30Z' and brandshort='L-com' limit 1 [ RunTime:0.000460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSMS30Z' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.017261s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118536 AND `partno` = 'FOC-LCSMS30Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.012038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672627 [ RunTime:0.003589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118508 LIMIT 5 [ RunTime:0.009544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118508 ORDER BY `minOrder` ASC [ RunTime:0.018448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118508 ORDER BY `unit` DESC [ RunTime:0.009836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118508 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118508 ORDER BY `minOrder` ASC [ RunTime:0.000981s ]
select * from pdf where partno='FOC-LCSM0220-0LU0' and brandshort='L-com' limit 1 [ RunTime:0.005907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSM0220-0LU0' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.037430s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118508 AND `partno` = 'FOC-LCSM0220-0LU0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.013921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672554 [ RunTime:0.020902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118507 LIMIT 5 [ RunTime:0.017179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118507 ORDER BY `minOrder` ASC [ RunTime:0.006796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118507 ORDER BY `unit` DESC [ RunTime:0.011443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118507 LIMIT 2 [ RunTime:0.003914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118507 ORDER BY `minOrder` ASC [ RunTime:0.000763s ]
select * from pdf where partno='FOC-LCSM0230-0L0E' and brandshort='L-com' limit 1 [ RunTime:0.000961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSM0230-0L0E' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.010163s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118507 AND `partno` = 'FOC-LCSM0230-0L0E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.009960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17314653 [ RunTime:0.002660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118496 LIMIT 5 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118496 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118496 ORDER BY `unit` DESC [ RunTime:0.005797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118496 LIMIT 2 [ RunTime:0.001037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118496 ORDER BY `minOrder` ASC [ RunTime:0.005083s ]
select * from pdf where partno='FOC-LCMMS30' and brandshort='L-com' limit 1 [ RunTime:0.000734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCMMS30' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.018513s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118496 AND `partno` = 'FOC-LCMMS30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.001948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672591 [ RunTime:0.002329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118486 LIMIT 5 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118486 ORDER BY `minOrder` ASC [ RunTime:0.004467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118486 ORDER BY `unit` DESC [ RunTime:0.002409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118486 LIMIT 2 [ RunTime:0.002320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118486 ORDER BY `minOrder` ASC [ RunTime:0.007796s ]
select * from pdf where partno='FOC-LCMM0230-0SUE' and brandshort='L-com' limit 1 [ RunTime:0.001359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCMM0230-0SUE' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.029843s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118486 AND `partno` = 'FOC-LCMM0230-0SUE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.001268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672508 [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118471 LIMIT 5 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118471 ORDER BY `minOrder` ASC [ RunTime:0.002976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118471 ORDER BY `unit` DESC [ RunTime:0.001855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118471 LIMIT 2 [ RunTime:0.004157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118471 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='FOC-LCSM0230-0U0R' and brandshort='L-com' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSM0230-0U0R' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.016851s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118471 AND `partno` = 'FOC-LCSM0230-0U0R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.001380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672562 [ RunTime:0.001010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118467 LIMIT 5 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118467 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118467 ORDER BY `unit` DESC [ RunTime:0.000597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118467 LIMIT 2 [ RunTime:0.002084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118467 ORDER BY `minOrder` ASC [ RunTime:0.008485s ]
select * from pdf where partno='FOC-LCASM0230-0M00' and brandshort='L-com' limit 1 [ RunTime:0.001017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCASM0230-0M00' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.015676s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118467 AND `partno` = 'FOC-LCASM0230-0M00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.012700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149914 [ RunTime:0.004275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118464 LIMIT 5 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118464 ORDER BY `minOrder` ASC [ RunTime:0.004978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118464 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118464 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118464 ORDER BY `minOrder` ASC [ RunTime:0.002126s ]
select * from pdf where partno='FOC-LCUSMS30FB' and brandshort='L-com' limit 1 [ RunTime:0.010734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCUSMS30FB' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.017356s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118464 AND `partno` = 'FOC-LCUSMS30FB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.011295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17314659 [ RunTime:0.031029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118463 LIMIT 5 [ RunTime:0.014877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118463 ORDER BY `minOrder` ASC [ RunTime:0.008852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118463 ORDER BY `unit` DESC [ RunTime:0.006429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118463 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118463 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='FOC-LCSM0230-BLUER' and brandshort='L-com' limit 1 [ RunTime:0.000982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSM0230-BLUER' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.018759s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118463 AND `partno` = 'FOC-LCSM0230-BLUER' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.003895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672557 [ RunTime:0.024318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118461 LIMIT 5 [ RunTime:0.003099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118461 ORDER BY `minOrder` ASC [ RunTime:0.003319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118461 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118461 LIMIT 2 [ RunTime:0.001081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118461 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='FOC-LCASM0220-0L00' and brandshort='L-com' limit 1 [ RunTime:0.001037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCASM0220-0L00' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.025345s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118461 AND `partno` = 'FOC-LCASM0220-0L00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.001059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454964 [ RunTime:0.003273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118456 LIMIT 5 [ RunTime:0.003469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118456 ORDER BY `minOrder` ASC [ RunTime:0.005645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118456 ORDER BY `unit` DESC [ RunTime:0.000959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118456 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118456 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='FOC-LCSM0216-BLUER' and brandshort='L-com' limit 1 [ RunTime:0.001192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSM0216-BLUER' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.013548s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118456 AND `partno` = 'FOC-LCSM0216-BLUER' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.002154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454966 [ RunTime:0.001202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118453 LIMIT 5 [ RunTime:0.005926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118453 ORDER BY `minOrder` ASC [ RunTime:0.010999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118453 ORDER BY `unit` DESC [ RunTime:0.001389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118453 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118453 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='FOC-LCSMS16' and brandshort='L-com' limit 1 [ RunTime:0.008341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSMS16' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.016009s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118453 AND `partno` = 'FOC-LCSMS16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.002343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672548 [ RunTime:0.004992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118431 LIMIT 5 [ RunTime:0.005297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118431 ORDER BY `minOrder` ASC [ RunTime:0.011742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118431 ORDER BY `unit` DESC [ RunTime:0.001245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118431 LIMIT 2 [ RunTime:0.015569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118431 ORDER BY `minOrder` ASC [ RunTime:0.003848s ]
select * from pdf where partno='FOC-LCSM0250-0S00' and brandshort='L-com' limit 1 [ RunTime:0.001014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCSM0250-0S00' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.015561s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118431 AND `partno` = 'FOC-LCSM0250-0S00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.004383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672536 [ RunTime:0.009505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118425 LIMIT 5 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118425 ORDER BY `minOrder` ASC [ RunTime:0.009838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118425 ORDER BY `unit` DESC [ RunTime:0.001768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118425 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118425 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='FOC-LCMMS16' and brandshort='L-com' limit 1 [ RunTime:0.002417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCMMS16' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.028992s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118425 AND `partno` = 'FOC-LCMMS16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.017832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17314648 [ RunTime:0.004772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62118423 LIMIT 5 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118423 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62118423 ORDER BY `unit` DESC [ RunTime:0.003558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62118423 LIMIT 2 [ RunTime:0.005738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62118423 ORDER BY `minOrder` ASC [ RunTime:0.002130s ]
select * from pdf where partno='FOC-LCASM0120-GR0U0' and brandshort='L-com' limit 1 [ RunTime:0.000650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FOC-LCASM0120-GR0U0' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.015401s ]
SELECT `id` FROM `stock` WHERE `id` <> 62118423 AND `partno` = 'FOC-LCASM0120-GR0U0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.007574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672496 [ RunTime:0.000722s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001418s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011328s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005308s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001204s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001809s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001003s ]
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 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001079s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FOC-LC%' OR `brand` LIKE 'FOC-LC%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002191s ]