SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002605s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018808s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14759105 LIMIT 5 [ RunTime:0.033407s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14759105 ORDER BY `minOrder` ASC [ RunTime:0.034449s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14759105 ORDER BY `unit` DESC [ RunTime:0.011800s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14759105 LIMIT 2 [ RunTime:0.024881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14759105 ORDER BY `minOrder` ASC [ RunTime:0.016905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13894401 LIMIT 5 [ RunTime:0.027357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13894401 ORDER BY `minOrder` ASC [ RunTime:0.054250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13894401 ORDER BY `unit` DESC [ RunTime:0.009054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13894401 LIMIT 2 [ RunTime:0.044047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13894401 ORDER BY `minOrder` ASC [ RunTime:0.034220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646262 LIMIT 5 [ RunTime:0.031688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646262 ORDER BY `minOrder` ASC [ RunTime:0.041972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16646262 ORDER BY `unit` DESC [ RunTime:0.018175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16646262 LIMIT 2 [ RunTime:0.025698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646262 ORDER BY `minOrder` ASC [ RunTime:0.022202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646183 LIMIT 5 [ RunTime:0.032821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646183 ORDER BY `minOrder` ASC [ RunTime:0.027566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16646183 ORDER BY `unit` DESC [ RunTime:0.006012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16646183 LIMIT 2 [ RunTime:0.053060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646183 ORDER BY `minOrder` ASC [ RunTime:0.024107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646181 LIMIT 5 [ RunTime:0.036647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646181 ORDER BY `minOrder` ASC [ RunTime:0.042736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16646181 ORDER BY `unit` DESC [ RunTime:0.015033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16646181 LIMIT 2 [ RunTime:0.041562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646181 ORDER BY `minOrder` ASC [ RunTime:0.013506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646161 LIMIT 5 [ RunTime:0.021210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646161 ORDER BY `minOrder` ASC [ RunTime:0.047665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16646161 ORDER BY `unit` DESC [ RunTime:0.019004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16646161 LIMIT 2 [ RunTime:0.016011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646161 ORDER BY `minOrder` ASC [ RunTime:0.007191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646106 LIMIT 5 [ RunTime:0.016216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646106 ORDER BY `minOrder` ASC [ RunTime:0.017790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16646106 ORDER BY `unit` DESC [ RunTime:0.013616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16646106 LIMIT 2 [ RunTime:0.014698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646106 ORDER BY `minOrder` ASC [ RunTime:0.006637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14783713 LIMIT 5 [ RunTime:0.009145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14783713 ORDER BY `minOrder` ASC [ RunTime:0.008303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14783713 ORDER BY `unit` DESC [ RunTime:0.004737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14783713 LIMIT 2 [ RunTime:0.015240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14783713 ORDER BY `minOrder` ASC [ RunTime:0.003087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14783652 LIMIT 5 [ RunTime:0.008035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14783652 ORDER BY `minOrder` ASC [ RunTime:0.008899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14783652 ORDER BY `unit` DESC [ RunTime:0.007297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14783652 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14783652 ORDER BY `minOrder` ASC [ RunTime:0.005238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13889763 LIMIT 5 [ RunTime:0.008481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13889763 ORDER BY `minOrder` ASC [ RunTime:0.002089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13889763 ORDER BY `unit` DESC [ RunTime:0.001288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13889763 LIMIT 2 [ RunTime:0.002992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13889763 ORDER BY `minOrder` ASC [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13889561 LIMIT 5 [ RunTime:0.006510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13889561 ORDER BY `minOrder` ASC [ RunTime:0.010200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13889561 ORDER BY `unit` DESC [ RunTime:0.004603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13889561 LIMIT 2 [ RunTime:0.005226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13889561 ORDER BY `minOrder` ASC [ RunTime:0.003742s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005511s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64294491 LIMIT 5 [ RunTime:0.013752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64294491 ORDER BY `minOrder` ASC [ RunTime:0.022304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64294491 ORDER BY `unit` DESC [ RunTime:0.026468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64294491 LIMIT 2 [ RunTime:0.012750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64294491 ORDER BY `minOrder` ASC [ RunTime:0.003632s ]
select * from pdf where partno='V300C24C150BL' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.002203s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BL' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.014272s ]
SELECT `id` FROM `stock` WHERE `id` <> 64294491 AND `partno` = 'V300C24C150BL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.006190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14759105 [ RunTime:0.005983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64294552 LIMIT 5 [ RunTime:0.005137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64294552 ORDER BY `minOrder` ASC [ RunTime:0.009617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64294552 ORDER BY `unit` DESC [ RunTime:0.001618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64294552 LIMIT 2 [ RunTime:0.003167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64294552 ORDER BY `minOrder` ASC [ RunTime:0.008366s ]
select * from pdf where partno='V300C24C150BG' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.002432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BG' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.003891s ]
SELECT `id` FROM `stock` WHERE `id` <> 64294552 AND `partno` = 'V300C24C150BG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.002420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13894401 [ RunTime:0.004790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365457 LIMIT 5 [ RunTime:0.001513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365457 ORDER BY `minOrder` ASC [ RunTime:0.001209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365457 ORDER BY `unit` DESC [ RunTime:0.003671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365457 LIMIT 2 [ RunTime:0.005565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365457 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='V300C24C150BN3' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.006268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BN3' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.000919s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365457 AND `partno` = 'V300C24C150BN3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13889763 [ RunTime:0.000745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365441 LIMIT 5 [ RunTime:0.002501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365441 ORDER BY `minOrder` ASC [ RunTime:0.005514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365441 ORDER BY `unit` DESC [ RunTime:0.009146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365441 LIMIT 2 [ RunTime:0.003011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365441 ORDER BY `minOrder` ASC [ RunTime:0.004304s ]
select * from pdf where partno='V300C24C150BN' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.007951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BN' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.006269s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365441 AND `partno` = 'V300C24C150BN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.001428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646262 [ RunTime:0.002128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365246 LIMIT 5 [ RunTime:0.005281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365246 ORDER BY `minOrder` ASC [ RunTime:0.001643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365246 ORDER BY `unit` DESC [ RunTime:0.008221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365246 LIMIT 2 [ RunTime:0.004204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365246 ORDER BY `minOrder` ASC [ RunTime:0.005943s ]
select * from pdf where partno='V300C24C150BF3' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.001966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BF3' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.004453s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365246 AND `partno` = 'V300C24C150BF3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.000906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646183 [ RunTime:0.003723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365244 LIMIT 5 [ RunTime:0.003075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365244 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365244 ORDER BY `unit` DESC [ RunTime:0.001489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365244 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365244 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='V300C24C150BS' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.001365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BS' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.000940s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365244 AND `partno` = 'V300C24C150BS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.000848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646181 [ RunTime:0.002402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365204 LIMIT 5 [ RunTime:0.003556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365204 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365204 ORDER BY `unit` DESC [ RunTime:0.000403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365204 LIMIT 2 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365204 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='V300C24C150BF' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.000600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BF' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.002464s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365204 AND `partno` = 'V300C24C150BF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.001512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14783713 [ RunTime:0.000510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365193 LIMIT 5 [ RunTime:0.002777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365193 ORDER BY `minOrder` ASC [ RunTime:0.005940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365193 ORDER BY `unit` DESC [ RunTime:0.015705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365193 LIMIT 2 [ RunTime:0.011343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365193 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='V300C24C150BG3' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.001896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BG3' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.007092s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365193 AND `partno` = 'V300C24C150BG3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646161 [ RunTime:0.010565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365050 LIMIT 5 [ RunTime:0.001028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365050 ORDER BY `minOrder` ASC [ RunTime:0.002214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365050 ORDER BY `unit` DESC [ RunTime:0.007261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365050 LIMIT 2 [ RunTime:0.001401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365050 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='V300C24C150BL2' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.001360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BL2' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.003761s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365050 AND `partno` = 'V300C24C150BL2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.017888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13889561 [ RunTime:0.002660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365048 LIMIT 5 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365048 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365048 ORDER BY `unit` DESC [ RunTime:0.002302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365048 LIMIT 2 [ RunTime:0.003004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365048 ORDER BY `minOrder` ASC [ RunTime:0.001216s ]
select * from pdf where partno='V300C24C150BL3' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.000918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150BL3' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.003980s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365048 AND `partno` = 'V300C24C150BL3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.002581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646106 [ RunTime:0.012424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64365040 LIMIT 5 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365040 ORDER BY `minOrder` ASC [ RunTime:0.002498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64365040 ORDER BY `unit` DESC [ RunTime:0.000767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64365040 LIMIT 2 [ RunTime:0.005398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64365040 ORDER BY `minOrder` ASC [ RunTime:0.003400s ]
select * from pdf where partno='V300C24C150B' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.001005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V300C24C150B' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.000809s ]
SELECT `id` FROM `stock` WHERE `id` <> 64365040 AND `partno` = 'V300C24C150B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14783652 [ RunTime:0.005780s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012572s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004240s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002713s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000865s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006353s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011904s ]
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 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021456s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'V300C24C150B%' OR `brand` LIKE 'V300C24C150B%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021606s ]