SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002549s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011234s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004070s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019186s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55081703 LIMIT 5 [ RunTime:0.022252s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55081703 ORDER BY `minOrder` ASC [ RunTime:0.015146s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55081703 ORDER BY `unit` DESC [ RunTime:0.006963s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55081703 LIMIT 2 [ RunTime:0.017840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55081703 ORDER BY `minOrder` ASC [ RunTime:0.003889s ]
select * from pdf where partno='JT00A-10-5PB' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.017318s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PB' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.007633s ]
SELECT `id` FROM `stock` WHERE `id` <> 55081703 AND `partno` = 'JT00A-10-5PB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.003613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55081702 LIMIT 5 [ RunTime:0.006440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55081702 ORDER BY `minOrder` ASC [ RunTime:0.049522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55081702 ORDER BY `unit` DESC [ RunTime:0.020665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55081702 LIMIT 2 [ RunTime:0.010918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55081702 ORDER BY `minOrder` ASC [ RunTime:0.021605s ]
select * from pdf where partno='JT00A-10-5P' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.027700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5P' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.039245s ]
SELECT `id` FROM `stock` WHERE `id` <> 55081702 AND `partno` = 'JT00A-10-5P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.119429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48069101 LIMIT 5 [ RunTime:0.065366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48069101 ORDER BY `minOrder` ASC [ RunTime:0.024743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48069101 ORDER BY `unit` DESC [ RunTime:0.026191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48069101 LIMIT 2 [ RunTime:0.063602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48069101 ORDER BY `minOrder` ASC [ RunTime:0.001253s ]
select * from pdf where partno='JT00A-10-5P(340)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.060319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5P(340)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.032612s ]
SELECT `id` FROM `stock` WHERE `id` <> 48069101 AND `partno` = 'JT00A-10-5P(340)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.033750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35262502 [ RunTime:0.078267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48069100 LIMIT 5 [ RunTime:0.038934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48069100 ORDER BY `minOrder` ASC [ RunTime:0.042406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48069100 ORDER BY `unit` DESC [ RunTime:0.023287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48069100 LIMIT 2 [ RunTime:0.008405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48069100 ORDER BY `minOrder` ASC [ RunTime:0.017397s ]
select * from pdf where partno='JT00A-10-5PB(340)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PB(340)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017865s ]
SELECT `id` FROM `stock` WHERE `id` <> 48069100 AND `partno` = 'JT00A-10-5PB(340)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.041381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35262500 [ RunTime:0.030894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48068325 LIMIT 5 [ RunTime:0.048391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068325 ORDER BY `minOrder` ASC [ RunTime:0.060727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48068325 ORDER BY `unit` DESC [ RunTime:0.009994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48068325 LIMIT 2 [ RunTime:0.019706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068325 ORDER BY `minOrder` ASC [ RunTime:0.021264s ]
select * from pdf where partno='JT00A-10-5P(300)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.053252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5P(300)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.047531s ]
SELECT `id` FROM `stock` WHERE `id` <> 48068325 AND `partno` = 'JT00A-10-5P(300)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.044768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35261749 [ RunTime:0.011902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48068324 LIMIT 5 [ RunTime:0.024689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068324 ORDER BY `minOrder` ASC [ RunTime:0.040524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48068324 ORDER BY `unit` DESC [ RunTime:0.013483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48068324 LIMIT 2 [ RunTime:0.014052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068324 ORDER BY `minOrder` ASC [ RunTime:0.008428s ]
select * from pdf where partno='JT00A-10-5PD(301)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PD(301)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.025449s ]
SELECT `id` FROM `stock` WHERE `id` <> 48068324 AND `partno` = 'JT00A-10-5PD(301)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.026613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35261746 [ RunTime:0.017418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48068323 LIMIT 5 [ RunTime:0.032971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068323 ORDER BY `minOrder` ASC [ RunTime:0.027422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48068323 ORDER BY `unit` DESC [ RunTime:0.004540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48068323 LIMIT 2 [ RunTime:0.016509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068323 ORDER BY `minOrder` ASC [ RunTime:0.026063s ]
select * from pdf where partno='JT00A-10-5PD(362)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.006943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PD(362)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.021491s ]
SELECT `id` FROM `stock` WHERE `id` <> 48068323 AND `partno` = 'JT00A-10-5PD(362)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.030463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35261745 [ RunTime:0.021576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48068322 LIMIT 5 [ RunTime:0.045306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068322 ORDER BY `minOrder` ASC [ RunTime:0.022907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48068322 ORDER BY `unit` DESC [ RunTime:0.072167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48068322 LIMIT 2 [ RunTime:0.056362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068322 ORDER BY `minOrder` ASC [ RunTime:0.014836s ]
select * from pdf where partno='JT00A-10-5PA(362)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.021073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PA(362)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.042497s ]
SELECT `id` FROM `stock` WHERE `id` <> 48068322 AND `partno` = 'JT00A-10-5PA(362)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.046715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35261744 [ RunTime:0.029919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48068313 LIMIT 5 [ RunTime:0.026757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068313 ORDER BY `minOrder` ASC [ RunTime:0.021379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48068313 ORDER BY `unit` DESC [ RunTime:0.042588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48068313 LIMIT 2 [ RunTime:0.038932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068313 ORDER BY `minOrder` ASC [ RunTime:0.008394s ]
select * from pdf where partno='JT00A-10-5PC(304)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.048499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PC(304)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.035685s ]
SELECT `id` FROM `stock` WHERE `id` <> 48068313 AND `partno` = 'JT00A-10-5PC(304)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.052469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35261734 [ RunTime:0.049254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48068312 LIMIT 5 [ RunTime:0.042011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068312 ORDER BY `minOrder` ASC [ RunTime:0.067599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48068312 ORDER BY `unit` DESC [ RunTime:0.000740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48068312 LIMIT 2 [ RunTime:0.029448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48068312 ORDER BY `minOrder` ASC [ RunTime:0.021122s ]
select * from pdf where partno='JT00A-10-5PC(300)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.033553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PC(300)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.060125s ]
SELECT `id` FROM `stock` WHERE `id` <> 48068312 AND `partno` = 'JT00A-10-5PC(300)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.052436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35261733 [ RunTime:0.028391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48065523 LIMIT 5 [ RunTime:0.020095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48065523 ORDER BY `minOrder` ASC [ RunTime:0.025727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48065523 ORDER BY `unit` DESC [ RunTime:0.051580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48065523 LIMIT 2 [ RunTime:0.027284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48065523 ORDER BY `minOrder` ASC [ RunTime:0.013788s ]
select * from pdf where partno='JT00A-10-5PC' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.008863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PC' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.045431s ]
SELECT `id` FROM `stock` WHERE `id` <> 48065523 AND `partno` = 'JT00A-10-5PC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.041526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35259034 [ RunTime:0.021303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48065517 LIMIT 5 [ RunTime:0.026692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48065517 ORDER BY `minOrder` ASC [ RunTime:0.027456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48065517 ORDER BY `unit` DESC [ RunTime:0.008382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48065517 LIMIT 2 [ RunTime:0.011040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48065517 ORDER BY `minOrder` ASC [ RunTime:0.007735s ]
select * from pdf where partno='JT00A-10-5PD' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.012256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PD' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.009042s ]
SELECT `id` FROM `stock` WHERE `id` <> 48065517 AND `partno` = 'JT00A-10-5PD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.031852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35211891 [ RunTime:0.020693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48061758 LIMIT 5 [ RunTime:0.028577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061758 ORDER BY `minOrder` ASC [ RunTime:0.037024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48061758 ORDER BY `unit` DESC [ RunTime:0.016905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48061758 LIMIT 2 [ RunTime:0.003290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061758 ORDER BY `minOrder` ASC [ RunTime:0.007142s ]
select * from pdf where partno='JT00A-10-5P(439)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.002230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5P(439)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.019149s ]
SELECT `id` FROM `stock` WHERE `id` <> 48061758 AND `partno` = 'JT00A-10-5P(439)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.012903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35255373 [ RunTime:0.014976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48061757 LIMIT 5 [ RunTime:0.029319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061757 ORDER BY `minOrder` ASC [ RunTime:0.037492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48061757 ORDER BY `unit` DESC [ RunTime:0.023448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48061757 LIMIT 2 [ RunTime:0.007608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061757 ORDER BY `minOrder` ASC [ RunTime:0.018217s ]
select * from pdf where partno='JT00A-10-5P(423)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.007885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5P(423)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.018270s ]
SELECT `id` FROM `stock` WHERE `id` <> 48061757 AND `partno` = 'JT00A-10-5P(423)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.027520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35255372 [ RunTime:0.010345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48061756 LIMIT 5 [ RunTime:0.010784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061756 ORDER BY `minOrder` ASC [ RunTime:0.003205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48061756 ORDER BY `unit` DESC [ RunTime:0.013423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48061756 LIMIT 2 [ RunTime:0.011080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061756 ORDER BY `minOrder` ASC [ RunTime:0.005322s ]
select * from pdf where partno='JT00A-10-5P(106)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.052071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5P(106)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.037372s ]
SELECT `id` FROM `stock` WHERE `id` <> 48061756 AND `partno` = 'JT00A-10-5P(106)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.002650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35255371 [ RunTime:0.039331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48061755 LIMIT 5 [ RunTime:0.019776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061755 ORDER BY `minOrder` ASC [ RunTime:0.041492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48061755 ORDER BY `unit` DESC [ RunTime:0.014480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48061755 LIMIT 2 [ RunTime:0.032627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061755 ORDER BY `minOrder` ASC [ RunTime:0.011380s ]
select * from pdf where partno='JT00A-10-5PD(423)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.033032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PD(423)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.003398s ]
SELECT `id` FROM `stock` WHERE `id` <> 48061755 AND `partno` = 'JT00A-10-5PD(423)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.019504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35255370 [ RunTime:0.046165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48061754 LIMIT 5 [ RunTime:0.022845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061754 ORDER BY `minOrder` ASC [ RunTime:0.009440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48061754 ORDER BY `unit` DESC [ RunTime:0.010225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48061754 LIMIT 2 [ RunTime:0.016075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061754 ORDER BY `minOrder` ASC [ RunTime:0.013465s ]
select * from pdf where partno='JT00A-10-5PB(439)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.051354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PB(439)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.016577s ]
SELECT `id` FROM `stock` WHERE `id` <> 48061754 AND `partno` = 'JT00A-10-5PB(439)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.037725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35255369 [ RunTime:0.024648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48061753 LIMIT 5 [ RunTime:0.037340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061753 ORDER BY `minOrder` ASC [ RunTime:0.029106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48061753 ORDER BY `unit` DESC [ RunTime:0.001370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48061753 LIMIT 2 [ RunTime:0.030649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061753 ORDER BY `minOrder` ASC [ RunTime:0.005623s ]
select * from pdf where partno='JT00A-10-5PD(406)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.029259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PD(406)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.024832s ]
SELECT `id` FROM `stock` WHERE `id` <> 48061753 AND `partno` = 'JT00A-10-5PD(406)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.064193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35255368 [ RunTime:0.040562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48061752 LIMIT 5 [ RunTime:0.019940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061752 ORDER BY `minOrder` ASC [ RunTime:0.010390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48061752 ORDER BY `unit` DESC [ RunTime:0.009204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48061752 LIMIT 2 [ RunTime:0.046484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061752 ORDER BY `minOrder` ASC [ RunTime:0.008045s ]
select * from pdf where partno='JT00A-10-5PD(106)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.040527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PD(106)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.016177s ]
SELECT `id` FROM `stock` WHERE `id` <> 48061752 AND `partno` = 'JT00A-10-5PD(106)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.039580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35255367 [ RunTime:0.023870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48061751 LIMIT 5 [ RunTime:0.041809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061751 ORDER BY `minOrder` ASC [ RunTime:0.023329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48061751 ORDER BY `unit` DESC [ RunTime:0.007929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48061751 LIMIT 2 [ RunTime:0.018682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48061751 ORDER BY `minOrder` ASC [ RunTime:0.009922s ]
select * from pdf where partno='JT00A-10-5PB(406)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.012334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'JT00A-10-5PB(406)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.008855s ]
SELECT `id` FROM `stock` WHERE `id` <> 48061751 AND `partno` = 'JT00A-10-5PB(406)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.033951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35255366 [ RunTime:0.005359s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015912s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008891s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018314s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012172s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024135s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008148s ]
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 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007710s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'JT00A-10-5P%' OR `brand` LIKE 'JT00A-10-5P%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.035814s ]