SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002451s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017679s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16437489 LIMIT 5 [ RunTime:0.017546s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437489 ORDER BY `minOrder` ASC [ RunTime:0.012094s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16437489 ORDER BY `unit` DESC [ RunTime:0.005671s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16437489 LIMIT 2 [ RunTime:0.006524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437489 ORDER BY `minOrder` ASC [ RunTime:0.012153s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.007075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13558545 LIMIT 5 [ RunTime:0.012619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13558545 ORDER BY `minOrder` ASC [ RunTime:0.005094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13558545 ORDER BY `unit` DESC [ RunTime:0.029268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13558545 LIMIT 2 [ RunTime:0.021691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13558545 ORDER BY `minOrder` ASC [ RunTime:0.012614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16440365 LIMIT 5 [ RunTime:0.024193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440365 ORDER BY `minOrder` ASC [ RunTime:0.007434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16440365 ORDER BY `unit` DESC [ RunTime:0.014709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16440365 LIMIT 2 [ RunTime:0.013438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16440365 ORDER BY `minOrder` ASC [ RunTime:0.013918s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.008301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16438417 LIMIT 5 [ RunTime:0.024269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16438417 ORDER BY `minOrder` ASC [ RunTime:0.019943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16438417 ORDER BY `unit` DESC [ RunTime:0.010513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16438417 LIMIT 2 [ RunTime:0.014686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16438417 ORDER BY `minOrder` ASC [ RunTime:0.002930s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.011278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16437935 LIMIT 5 [ RunTime:0.022479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437935 ORDER BY `minOrder` ASC [ RunTime:0.034211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16437935 ORDER BY `unit` DESC [ RunTime:0.017547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16437935 LIMIT 2 [ RunTime:0.010855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437935 ORDER BY `minOrder` ASC [ RunTime:0.015445s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.004993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14429750 LIMIT 5 [ RunTime:0.008564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14429750 ORDER BY `minOrder` ASC [ RunTime:0.002323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14429750 ORDER BY `unit` DESC [ RunTime:0.007322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14429750 LIMIT 2 [ RunTime:0.003170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14429750 ORDER BY `minOrder` ASC [ RunTime:0.006536s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.009709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14429378 LIMIT 5 [ RunTime:0.013151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14429378 ORDER BY `minOrder` ASC [ RunTime:0.011859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14429378 ORDER BY `unit` DESC [ RunTime:0.016231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14429378 LIMIT 2 [ RunTime:0.008926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14429378 ORDER BY `minOrder` ASC [ RunTime:0.006245s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428706 LIMIT 5 [ RunTime:0.011493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428706 ORDER BY `minOrder` ASC [ RunTime:0.005127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428706 ORDER BY `unit` DESC [ RunTime:0.006024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428706 LIMIT 2 [ RunTime:0.021483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428706 ORDER BY `minOrder` ASC [ RunTime:0.005080s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428573 LIMIT 5 [ RunTime:0.003911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428573 ORDER BY `minOrder` ASC [ RunTime:0.006443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428573 ORDER BY `unit` DESC [ RunTime:0.008322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428573 LIMIT 2 [ RunTime:0.011630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428573 ORDER BY `minOrder` ASC [ RunTime:0.014209s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428459 LIMIT 5 [ RunTime:0.011809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428459 ORDER BY `minOrder` ASC [ RunTime:0.014718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428459 ORDER BY `unit` DESC [ RunTime:0.002010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428459 LIMIT 2 [ RunTime:0.005543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428459 ORDER BY `minOrder` ASC [ RunTime:0.000985s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.007069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428431 LIMIT 5 [ RunTime:0.007724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428431 ORDER BY `minOrder` ASC [ RunTime:0.013099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428431 ORDER BY `unit` DESC [ RunTime:0.010052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428431 LIMIT 2 [ RunTime:0.005947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428431 ORDER BY `minOrder` ASC [ RunTime:0.003546s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428430 LIMIT 5 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428430 ORDER BY `minOrder` ASC [ RunTime:0.002581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428430 ORDER BY `unit` DESC [ RunTime:0.003125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428430 LIMIT 2 [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428430 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.005915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13560646 LIMIT 5 [ RunTime:0.000978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13560646 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13560646 ORDER BY `unit` DESC [ RunTime:0.000239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13560646 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13560646 ORDER BY `minOrder` ASC [ RunTime:0.005693s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13559700 LIMIT 5 [ RunTime:0.002232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559700 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13559700 ORDER BY `unit` DESC [ RunTime:0.005493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13559700 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559700 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557540 LIMIT 5 [ RunTime:0.000895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13557540 ORDER BY `minOrder` ASC [ RunTime:0.007669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13557540 ORDER BY `unit` DESC [ RunTime:0.004083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13557540 LIMIT 2 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13557540 ORDER BY `minOrder` ASC [ RunTime:0.002573s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.006843s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133752 LIMIT 5 [ RunTime:0.005858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133752 ORDER BY `minOrder` ASC [ RunTime:0.019086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133752 ORDER BY `unit` DESC [ RunTime:0.021713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133752 LIMIT 2 [ RunTime:0.021553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133752 ORDER BY `minOrder` ASC [ RunTime:0.005825s ]
select * from pdf where partno='v2-6.0-0-sp-sm' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.009024s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'v2-6.0-0-sp-sm' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.007820s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133752 AND `partno` = 'v2-6.0-0-sp-sm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.003329s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36474353 LIMIT 5 [ RunTime:0.007358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36474353 ORDER BY `minOrder` ASC [ RunTime:0.001176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36474353 ORDER BY `unit` DESC [ RunTime:0.003944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36474353 LIMIT 2 [ RunTime:0.001637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36474353 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V2-6.0-0-SP-SM' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000349s ]
SELECT `id` FROM `stock` WHERE `id` <> 36474353 AND `partno` = 'V2-6.0-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.004447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557540 [ RunTime:0.004642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49270877 LIMIT 5 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49270877 ORDER BY `minOrder` ASC [ RunTime:0.005231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49270877 ORDER BY `unit` DESC [ RunTime:0.003173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49270877 LIMIT 2 [ RunTime:0.005527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49270877 ORDER BY `minOrder` ASC [ RunTime:0.004721s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.009872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V2-6.0-0-SP-SM' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.001116s ]
SELECT `id` FROM `stock` WHERE `id` <> 49270877 AND `partno` = 'V2-6.0-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.005722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557540 [ RunTime:0.001301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49270084 LIMIT 5 [ RunTime:0.013875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49270084 ORDER BY `minOrder` ASC [ RunTime:0.009196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49270084 ORDER BY `unit` DESC [ RunTime:0.002269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49270084 LIMIT 2 [ RunTime:0.005502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49270084 ORDER BY `minOrder` ASC [ RunTime:0.003520s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.003009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V2-6.0-0-SP-SM' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000501s ]
SELECT `id` FROM `stock` WHERE `id` <> 49270084 AND `partno` = 'V2-6.0-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.002812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557540 [ RunTime:0.005396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36473535 LIMIT 5 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36473535 ORDER BY `minOrder` ASC [ RunTime:0.007512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36473535 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36473535 LIMIT 2 [ RunTime:0.001588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36473535 ORDER BY `minOrder` ASC [ RunTime:0.001098s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V2-6.0-0-SP-SM' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000421s ]
SELECT `id` FROM `stock` WHERE `id` <> 36473535 AND `partno` = 'V2-6.0-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.001232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557540 [ RunTime:0.005011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49276825 LIMIT 5 [ RunTime:0.001684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49276825 ORDER BY `minOrder` ASC [ RunTime:0.001177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49276825 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49276825 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49276825 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V2-6.0-0-SP-SM' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 49276825 AND `partno` = 'V2-6.0-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36480227 [ RunTime:0.001408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36480227 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36480227 ORDER BY `minOrder` ASC [ RunTime:0.001072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36480227 ORDER BY `unit` DESC [ RunTime:0.003806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36480227 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36480227 ORDER BY `minOrder` ASC [ RunTime:0.001988s ]
select * from pdf where partno='V2-6.0-0-SP-SM' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V2-6.0-0-SP-SM' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000517s ]
SELECT `id` FROM `stock` WHERE `id` <> 36480227 AND `partno` = 'V2-6.0-0-SP-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49276825 [ RunTime:0.001745s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003231s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004778s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002310s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003499s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002637s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013237s ]
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 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011266s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'V2-6.0-0-SP-SM%' OR `brand` LIKE 'V2-6.0-0-SP-SM%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009142s ]