SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001373s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056438s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18902313 LIMIT 5 [ RunTime:0.068211s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18902313 ORDER BY `minOrder` ASC [ RunTime:0.108195s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18902313 ORDER BY `unit` DESC [ RunTime:0.076271s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18902313 LIMIT 2 [ RunTime:0.023104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18902313 ORDER BY `minOrder` ASC [ RunTime:0.015126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13808623 LIMIT 5 [ RunTime:0.089575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13808623 ORDER BY `minOrder` ASC [ RunTime:0.171843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13808623 ORDER BY `unit` DESC [ RunTime:0.011974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13808623 LIMIT 2 [ RunTime:0.119289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13808623 ORDER BY `minOrder` ASC [ RunTime:0.029375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634067 LIMIT 5 [ RunTime:0.066738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634067 ORDER BY `minOrder` ASC [ RunTime:0.120787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634067 ORDER BY `unit` DESC [ RunTime:0.051071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634067 LIMIT 2 [ RunTime:0.063932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634067 ORDER BY `minOrder` ASC [ RunTime:0.014670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632865 LIMIT 5 [ RunTime:0.049147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632865 ORDER BY `minOrder` ASC [ RunTime:0.035281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19632865 ORDER BY `unit` DESC [ RunTime:0.072526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19632865 LIMIT 2 [ RunTime:0.034595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632865 ORDER BY `minOrder` ASC [ RunTime:0.069703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615927 LIMIT 5 [ RunTime:0.028601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615927 ORDER BY `minOrder` ASC [ RunTime:0.050200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19615927 ORDER BY `unit` DESC [ RunTime:0.084110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19615927 LIMIT 2 [ RunTime:0.030364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615927 ORDER BY `minOrder` ASC [ RunTime:0.019282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615926 LIMIT 5 [ RunTime:0.026618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615926 ORDER BY `minOrder` ASC [ RunTime:0.096619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19615926 ORDER BY `unit` DESC [ RunTime:0.086631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19615926 LIMIT 2 [ RunTime:0.046864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615926 ORDER BY `minOrder` ASC [ RunTime:0.067224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720737 LIMIT 5 [ RunTime:0.084081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720737 ORDER BY `minOrder` ASC [ RunTime:0.084636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720737 ORDER BY `unit` DESC [ RunTime:0.086539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720737 LIMIT 2 [ RunTime:0.126116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720737 ORDER BY `minOrder` ASC [ RunTime:0.048290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720736 LIMIT 5 [ RunTime:0.149444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720736 ORDER BY `minOrder` ASC [ RunTime:0.098206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720736 ORDER BY `unit` DESC [ RunTime:0.061697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720736 LIMIT 2 [ RunTime:0.026814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720736 ORDER BY `minOrder` ASC [ RunTime:0.015019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720735 LIMIT 5 [ RunTime:0.010644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720735 ORDER BY `minOrder` ASC [ RunTime:0.026945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720735 ORDER BY `unit` DESC [ RunTime:0.069853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720735 LIMIT 2 [ RunTime:0.087852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720735 ORDER BY `minOrder` ASC [ RunTime:0.031557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720731 LIMIT 5 [ RunTime:0.043557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720731 ORDER BY `minOrder` ASC [ RunTime:0.064729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720731 ORDER BY `unit` DESC [ RunTime:0.002164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720731 LIMIT 2 [ RunTime:0.035891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720731 ORDER BY `minOrder` ASC [ RunTime:0.003983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720196 LIMIT 5 [ RunTime:0.019808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720196 ORDER BY `minOrder` ASC [ RunTime:0.023576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720196 ORDER BY `unit` DESC [ RunTime:0.069681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720196 LIMIT 2 [ RunTime:0.061469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720196 ORDER BY `minOrder` ASC [ RunTime:0.016543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719682 LIMIT 5 [ RunTime:0.009273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719682 ORDER BY `minOrder` ASC [ RunTime:0.051981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719682 ORDER BY `unit` DESC [ RunTime:0.073221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719682 LIMIT 2 [ RunTime:0.037225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719682 ORDER BY `minOrder` ASC [ RunTime:0.061902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719677 LIMIT 5 [ RunTime:0.089659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719677 ORDER BY `minOrder` ASC [ RunTime:0.114796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719677 ORDER BY `unit` DESC [ RunTime:0.061457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719677 LIMIT 2 [ RunTime:0.088197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719677 ORDER BY `minOrder` ASC [ RunTime:0.130729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18718647 LIMIT 5 [ RunTime:0.159325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18718647 ORDER BY `minOrder` ASC [ RunTime:0.089293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18718647 ORDER BY `unit` DESC [ RunTime:0.085491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18718647 LIMIT 2 [ RunTime:0.167116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18718647 ORDER BY `minOrder` ASC [ RunTime:0.065204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18717341 LIMIT 5 [ RunTime:0.052998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18717341 ORDER BY `minOrder` ASC [ RunTime:0.099077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18717341 ORDER BY `unit` DESC [ RunTime:0.024673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18717341 LIMIT 2 [ RunTime:0.045786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18717341 ORDER BY `minOrder` ASC [ RunTime:0.006494s ]
select * from pdf where partno='18526' and brandshort='Aven Tools' limit 1 [ RunTime:0.012585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997741 LIMIT 5 [ RunTime:0.024095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997741 ORDER BY `minOrder` ASC [ RunTime:0.018543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997741 ORDER BY `unit` DESC [ RunTime:0.018351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997741 LIMIT 2 [ RunTime:0.032589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997741 ORDER BY `minOrder` ASC [ RunTime:0.010759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997740 LIMIT 5 [ RunTime:0.008163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997740 ORDER BY `minOrder` ASC [ RunTime:0.027496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997740 ORDER BY `unit` DESC [ RunTime:0.006736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997740 LIMIT 2 [ RunTime:0.047269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997740 ORDER BY `minOrder` ASC [ RunTime:0.009464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997739 LIMIT 5 [ RunTime:0.010824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997739 ORDER BY `minOrder` ASC [ RunTime:0.020582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997739 ORDER BY `unit` DESC [ RunTime:0.036809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997739 LIMIT 2 [ RunTime:0.024313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997739 ORDER BY `minOrder` ASC [ RunTime:0.060468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210937 LIMIT 5 [ RunTime:0.040001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210937 ORDER BY `minOrder` ASC [ RunTime:0.118149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210937 ORDER BY `unit` DESC [ RunTime:0.128834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210937 LIMIT 2 [ RunTime:0.201607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210937 ORDER BY `minOrder` ASC [ RunTime:0.052170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14700452 LIMIT 5 [ RunTime:0.041273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14700452 ORDER BY `minOrder` ASC [ RunTime:0.173259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14700452 ORDER BY `unit` DESC [ RunTime:0.174188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14700452 LIMIT 2 [ RunTime:0.032090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14700452 ORDER BY `minOrder` ASC [ RunTime:0.089694s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087269s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53666637 LIMIT 5 [ RunTime:0.078746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666637 ORDER BY `minOrder` ASC [ RunTime:0.045699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53666637 ORDER BY `unit` DESC [ RunTime:0.042048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53666637 LIMIT 2 [ RunTime:0.038876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666637 ORDER BY `minOrder` ASC [ RunTime:0.012074s ]
select * from pdf where partno='1852642' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.054166s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852642' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.032390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49682938 LIMIT 5 [ RunTime:0.016222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49682938 ORDER BY `minOrder` ASC [ RunTime:0.030286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49682938 ORDER BY `unit` DESC [ RunTime:0.016422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49682938 LIMIT 2 [ RunTime:0.026289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49682938 ORDER BY `minOrder` ASC [ RunTime:0.027152s ]
select * from pdf where partno='185262-02' and brandshort='NI' limit 1 [ RunTime:0.089417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '185262-02' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.057326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49149772 LIMIT 5 [ RunTime:0.074284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49149772 ORDER BY `minOrder` ASC [ RunTime:0.053081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49149772 ORDER BY `unit` DESC [ RunTime:0.033133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49149772 LIMIT 2 [ RunTime:0.027651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49149772 ORDER BY `minOrder` ASC [ RunTime:0.008153s ]
select * from pdf where partno='185262-01' and brandshort='NI' limit 1 [ RunTime:0.009107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '185262-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.022432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36876133 LIMIT 5 [ RunTime:0.040158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36876133 ORDER BY `minOrder` ASC [ RunTime:0.022873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36876133 ORDER BY `unit` DESC [ RunTime:0.012354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36876133 LIMIT 2 [ RunTime:0.021275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36876133 ORDER BY `minOrder` ASC [ RunTime:0.009876s ]
select * from pdf where partno='185262-02' and brandshort='NI' limit 1 [ RunTime:0.013881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '185262-02' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36353529 LIMIT 5 [ RunTime:0.015929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36353529 ORDER BY `minOrder` ASC [ RunTime:0.044548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36353529 ORDER BY `unit` DESC [ RunTime:0.024330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36353529 LIMIT 2 [ RunTime:0.067319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36353529 ORDER BY `minOrder` ASC [ RunTime:0.026725s ]
select * from pdf where partno='185262-01' and brandshort='NI' limit 1 [ RunTime:0.008042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '185262-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.016371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53704016 LIMIT 5 [ RunTime:0.012494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53704016 ORDER BY `minOrder` ASC [ RunTime:0.024257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53704016 ORDER BY `unit` DESC [ RunTime:0.015752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53704016 LIMIT 2 [ RunTime:0.025744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53704016 ORDER BY `minOrder` ASC [ RunTime:0.026527s ]
select * from pdf where partno='1852670000' and brandshort='Weidmüller' limit 1 [ RunTime:0.022808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852670000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013950s ]
SELECT `id` FROM `stock` WHERE `id` <> 53704016 AND `partno` = '1852670000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.030570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634067 [ RunTime:0.012849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53685571 LIMIT 5 [ RunTime:0.041298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53685571 ORDER BY `minOrder` ASC [ RunTime:0.072922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53685571 ORDER BY `unit` DESC [ RunTime:0.020433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53685571 LIMIT 2 [ RunTime:0.012040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53685571 ORDER BY `minOrder` ASC [ RunTime:0.007354s ]
select * from pdf where partno='1852639' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852639' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.039509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53685017 LIMIT 5 [ RunTime:0.027380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53685017 ORDER BY `minOrder` ASC [ RunTime:0.004614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53685017 ORDER BY `unit` DESC [ RunTime:0.007463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53685017 LIMIT 2 [ RunTime:0.009162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53685017 ORDER BY `minOrder` ASC [ RunTime:0.002268s ]
select * from pdf where partno='1852613' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852613' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51674154 LIMIT 5 [ RunTime:0.021396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674154 ORDER BY `minOrder` ASC [ RunTime:0.021942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51674154 ORDER BY `unit` DESC [ RunTime:0.000956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51674154 LIMIT 2 [ RunTime:0.004468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674154 ORDER BY `minOrder` ASC [ RunTime:0.008582s ]
select * from pdf where partno='1852646-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852646-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.011223s ]
SELECT `id` FROM `stock` WHERE `id` <> 51674154 AND `partno` = '1852646-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.013281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51674144 LIMIT 5 [ RunTime:0.013270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674144 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51674144 ORDER BY `unit` DESC [ RunTime:0.003301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51674144 LIMIT 2 [ RunTime:0.002583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674144 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='1852633-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852633-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002716s ]
SELECT `id` FROM `stock` WHERE `id` <> 51674144 AND `partno` = '1852633-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.000963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670806 LIMIT 5 [ RunTime:0.005409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670806 ORDER BY `minOrder` ASC [ RunTime:0.001708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670806 ORDER BY `unit` DESC [ RunTime:0.000799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670806 LIMIT 2 [ RunTime:0.001347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670806 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
select * from pdf where partno='1852610-6' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.005931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852610-6' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.003165s ]
SELECT `id` FROM `stock` WHERE `id` <> 51670806 AND `partno` = '1852610-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.005310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670805 LIMIT 5 [ RunTime:0.001755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670805 ORDER BY `minOrder` ASC [ RunTime:0.003097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670805 ORDER BY `unit` DESC [ RunTime:0.000736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670805 LIMIT 2 [ RunTime:0.002576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670805 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='1852610-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.002332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852610-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002877s ]
SELECT `id` FROM `stock` WHERE `id` <> 51670805 AND `partno` = '1852610-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.000957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670804 LIMIT 5 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670804 ORDER BY `minOrder` ASC [ RunTime:0.007762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670804 ORDER BY `unit` DESC [ RunTime:0.005550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670804 LIMIT 2 [ RunTime:0.010653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670804 ORDER BY `minOrder` ASC [ RunTime:0.009851s ]
select * from pdf where partno='1852610-2' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.004790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852610-2' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.013405s ]
SELECT `id` FROM `stock` WHERE `id` <> 51670804 AND `partno` = '1852610-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.010349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51670803 LIMIT 5 [ RunTime:0.011656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670803 ORDER BY `minOrder` ASC [ RunTime:0.003851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51670803 ORDER BY `unit` DESC [ RunTime:0.003449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51670803 LIMIT 2 [ RunTime:0.001182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51670803 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='1852610-3' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.009068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852610-3' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.011893s ]
SELECT `id` FROM `stock` WHERE `id` <> 51670803 AND `partno` = '1852610-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.014515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49333635 LIMIT 5 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49333635 ORDER BY `minOrder` ASC [ RunTime:0.004561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49333635 ORDER BY `unit` DESC [ RunTime:0.012357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49333635 LIMIT 2 [ RunTime:0.015478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49333635 ORDER BY `minOrder` ASC [ RunTime:0.000557s ]
select * from pdf where partno='18526.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.001725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '18526.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.008331s ]
SELECT `id` FROM `stock` WHERE `id` <> 49333635 AND `partno` = '18526.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.015113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14413908 [ RunTime:0.027709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49157721 LIMIT 5 [ RunTime:0.004159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49157721 ORDER BY `minOrder` ASC [ RunTime:0.006214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49157721 ORDER BY `unit` DESC [ RunTime:0.012328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49157721 LIMIT 2 [ RunTime:0.000790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49157721 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
select * from pdf where partno='185262-05' and brandshort='NI' limit 1 [ RunTime:0.007769s ]
select foldpath,foldpath2,filename from pdf_file where id=1856379 limit 1 [ RunTime:0.011291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '185262-05' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.005788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44636828 LIMIT 5 [ RunTime:0.008505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44636828 ORDER BY `minOrder` ASC [ RunTime:0.011264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44636828 ORDER BY `unit` DESC [ RunTime:0.002785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44636828 LIMIT 2 [ RunTime:0.007729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44636828 ORDER BY `minOrder` ASC [ RunTime:0.011257s ]
select * from pdf where partno='1852646-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.002467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852646-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.005091s ]
SELECT `id` FROM `stock` WHERE `id` <> 44636828 AND `partno` = '1852646-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.001526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719682 [ RunTime:0.000995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44636816 LIMIT 5 [ RunTime:0.006378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44636816 ORDER BY `minOrder` ASC [ RunTime:0.003330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44636816 ORDER BY `unit` DESC [ RunTime:0.001977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44636816 LIMIT 2 [ RunTime:0.000987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44636816 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='1852633-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852633-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.009202s ]
SELECT `id` FROM `stock` WHERE `id` <> 44636816 AND `partno` = '1852633-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.003625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719677 [ RunTime:0.001505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44633325 LIMIT 5 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44633325 ORDER BY `minOrder` ASC [ RunTime:0.008805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44633325 ORDER BY `unit` DESC [ RunTime:0.014819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44633325 LIMIT 2 [ RunTime:0.006842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44633325 ORDER BY `minOrder` ASC [ RunTime:0.009058s ]
select * from pdf where partno='1852610-6' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.002951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852610-6' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.004466s ]
SELECT `id` FROM `stock` WHERE `id` <> 44633325 AND `partno` = '1852610-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997741 [ RunTime:0.008390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44633324 LIMIT 5 [ RunTime:0.006192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44633324 ORDER BY `minOrder` ASC [ RunTime:0.010142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44633324 ORDER BY `unit` DESC [ RunTime:0.002847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44633324 LIMIT 2 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44633324 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='1852610-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1852610-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.003076s ]
SELECT `id` FROM `stock` WHERE `id` <> 44633324 AND `partno` = '1852610-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.020626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997740 [ RunTime:0.000792s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007610s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003770s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002152s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018712s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013366s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015907s ]
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 '18526%' OR `brand` LIKE '18526%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006189s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18526%' OR `brand` LIKE '18526%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028754s ]