SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002395s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015284s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654987 LIMIT 5 [ RunTime:0.018045s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654987 ORDER BY `minOrder` ASC [ RunTime:0.005929s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19654987 ORDER BY `unit` DESC [ RunTime:0.003138s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19654987 LIMIT 2 [ RunTime:0.001602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654987 ORDER BY `minOrder` ASC [ RunTime:0.004800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656614 LIMIT 5 [ RunTime:0.016023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656614 ORDER BY `minOrder` ASC [ RunTime:0.006848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656614 ORDER BY `unit` DESC [ RunTime:0.021284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656614 LIMIT 2 [ RunTime:0.013222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656614 ORDER BY `minOrder` ASC [ RunTime:0.008941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11444858 LIMIT 5 [ RunTime:0.011333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444858 ORDER BY `minOrder` ASC [ RunTime:0.010772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11444858 ORDER BY `unit` DESC [ RunTime:0.010544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11444858 LIMIT 2 [ RunTime:0.012658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444858 ORDER BY `minOrder` ASC [ RunTime:0.005546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12559723 LIMIT 5 [ RunTime:0.009481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12559723 ORDER BY `minOrder` ASC [ RunTime:0.026528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12559723 ORDER BY `unit` DESC [ RunTime:0.007802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12559723 LIMIT 2 [ RunTime:0.039518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12559723 ORDER BY `minOrder` ASC [ RunTime:0.007414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11444911 LIMIT 5 [ RunTime:0.029180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444911 ORDER BY `minOrder` ASC [ RunTime:0.011854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11444911 ORDER BY `unit` DESC [ RunTime:0.016473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11444911 LIMIT 2 [ RunTime:0.004915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444911 ORDER BY `minOrder` ASC [ RunTime:0.007204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650723 LIMIT 5 [ RunTime:0.030072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650723 ORDER BY `minOrder` ASC [ RunTime:0.003844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650723 ORDER BY `unit` DESC [ RunTime:0.013807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650723 LIMIT 2 [ RunTime:0.002686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650723 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649156 LIMIT 5 [ RunTime:0.001417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649156 ORDER BY `minOrder` ASC [ RunTime:0.008841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649156 ORDER BY `unit` DESC [ RunTime:0.003900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649156 LIMIT 2 [ RunTime:0.008629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649156 ORDER BY `minOrder` ASC [ RunTime:0.005742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647121 LIMIT 5 [ RunTime:0.009477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647121 ORDER BY `minOrder` ASC [ RunTime:0.010130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647121 ORDER BY `unit` DESC [ RunTime:0.009344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647121 LIMIT 2 [ RunTime:0.024089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647121 ORDER BY `minOrder` ASC [ RunTime:0.003816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644680 LIMIT 5 [ RunTime:0.005434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644680 ORDER BY `minOrder` ASC [ RunTime:0.025826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19644680 ORDER BY `unit` DESC [ RunTime:0.005314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19644680 LIMIT 2 [ RunTime:0.010386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644680 ORDER BY `minOrder` ASC [ RunTime:0.003492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376654 LIMIT 5 [ RunTime:0.010311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376654 ORDER BY `minOrder` ASC [ RunTime:0.008767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14376654 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14376654 LIMIT 2 [ RunTime:0.002471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14376654 ORDER BY `minOrder` ASC [ RunTime:0.002962s ]
select * from pdf where partno='19126 010250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543719 LIMIT 5 [ RunTime:0.011094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543719 ORDER BY `minOrder` ASC [ RunTime:0.005088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543719 ORDER BY `unit` DESC [ RunTime:0.001568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543719 LIMIT 2 [ RunTime:0.001457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543719 ORDER BY `minOrder` ASC [ RunTime:0.002282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13310856 LIMIT 5 [ RunTime:0.014536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13310856 ORDER BY `minOrder` ASC [ RunTime:0.005166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13310856 ORDER BY `unit` DESC [ RunTime:0.003558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13310856 LIMIT 2 [ RunTime:0.002491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13310856 ORDER BY `minOrder` ASC [ RunTime:0.005980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12559460 LIMIT 5 [ RunTime:0.007865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12559460 ORDER BY `minOrder` ASC [ RunTime:0.007553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12559460 ORDER BY `unit` DESC [ RunTime:0.000810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12559460 LIMIT 2 [ RunTime:0.004651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12559460 ORDER BY `minOrder` ASC [ RunTime:0.001860s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275414 LIMIT 5 [ RunTime:0.003721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275414 ORDER BY `minOrder` ASC [ RunTime:0.001427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275414 ORDER BY `unit` DESC [ RunTime:0.006589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275414 LIMIT 2 [ RunTime:0.004759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275414 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
select * from pdf where partno='1912634' and brandshort='phoenix contact' limit 1 [ RunTime:0.006698s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912634' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.004983s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53657068 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53657068 ORDER BY `minOrder` ASC [ RunTime:0.000888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53657068 ORDER BY `unit` DESC [ RunTime:0.001266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53657068 LIMIT 2 [ RunTime:0.006426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53657068 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='1912621' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912621' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53832023 LIMIT 5 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53832023 ORDER BY `minOrder` ASC [ RunTime:0.001093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53832023 ORDER BY `unit` DESC [ RunTime:0.002442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53832023 LIMIT 2 [ RunTime:0.010886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53832023 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='1912692' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912692' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53663529 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663529 ORDER BY `minOrder` ASC [ RunTime:0.003283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53663529 ORDER BY `unit` DESC [ RunTime:0.004690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53663529 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663529 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='1912647' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912647' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53663674 LIMIT 5 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663674 ORDER BY `minOrder` ASC [ RunTime:0.003616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53663674 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53663674 LIMIT 2 [ RunTime:0.004507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663674 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='1912650' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912650' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53663787 LIMIT 5 [ RunTime:0.005024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663787 ORDER BY `minOrder` ASC [ RunTime:0.005855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53663787 ORDER BY `unit` DESC [ RunTime:0.000530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53663787 LIMIT 2 [ RunTime:0.002365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663787 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='1912663' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912663' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53665471 LIMIT 5 [ RunTime:0.003235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665471 ORDER BY `minOrder` ASC [ RunTime:0.008265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53665471 ORDER BY `unit` DESC [ RunTime:0.001846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53665471 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665471 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
select * from pdf where partno='1912689' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912689' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53668996 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53668996 ORDER BY `minOrder` ASC [ RunTime:0.004006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53668996 ORDER BY `unit` DESC [ RunTime:0.000237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53668996 LIMIT 2 [ RunTime:0.001467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53668996 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
select * from pdf where partno='1912634' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912634' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53729775 LIMIT 5 [ RunTime:0.001407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53729775 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53729775 ORDER BY `unit` DESC [ RunTime:0.000372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53729775 LIMIT 2 [ RunTime:0.001980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53729775 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='1912618' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912618' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53728210 LIMIT 5 [ RunTime:0.002839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728210 ORDER BY `minOrder` ASC [ RunTime:0.001586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53728210 ORDER BY `unit` DESC [ RunTime:0.001509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53728210 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728210 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
select * from pdf where partno='1912605' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912605' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53718971 LIMIT 5 [ RunTime:0.010006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53718971 ORDER BY `minOrder` ASC [ RunTime:0.002832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53718971 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53718971 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53718971 ORDER BY `minOrder` ASC [ RunTime:0.000239s ]
select * from pdf where partno='1912676' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912676' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348999 LIMIT 5 [ RunTime:0.003952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348999 ORDER BY `minOrder` ASC [ RunTime:0.003135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348999 ORDER BY `unit` DESC [ RunTime:0.009107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348999 LIMIT 2 [ RunTime:0.005742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348999 ORDER BY `minOrder` ASC [ RunTime:0.003131s ]
select * from pdf where partno='1912690000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912690000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008890s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348999 AND `partno` = '1912690000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540869 [ RunTime:0.005690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348954 LIMIT 5 [ RunTime:0.001238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348954 ORDER BY `minOrder` ASC [ RunTime:0.012975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348954 ORDER BY `unit` DESC [ RunTime:0.009553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348954 LIMIT 2 [ RunTime:0.009215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348954 ORDER BY `minOrder` ASC [ RunTime:0.003211s ]
select * from pdf where partno='1912680000' and brandshort='Weidmüller' limit 1 [ RunTime:0.017581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912680000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007582s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348954 AND `partno` = '1912680000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540819 [ RunTime:0.004738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348880 LIMIT 5 [ RunTime:0.011769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348880 ORDER BY `minOrder` ASC [ RunTime:0.007787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348880 ORDER BY `unit` DESC [ RunTime:0.004393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348880 LIMIT 2 [ RunTime:0.002036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348880 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='1912670000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912670000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001581s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348880 AND `partno` = '1912670000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540746 [ RunTime:0.005598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348832 LIMIT 5 [ RunTime:0.004141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348832 ORDER BY `minOrder` ASC [ RunTime:0.002778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348832 ORDER BY `unit` DESC [ RunTime:0.005046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348832 LIMIT 2 [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348832 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='1912660000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912660000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001684s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348832 AND `partno` = '1912660000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540699 [ RunTime:0.000721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348796 LIMIT 5 [ RunTime:0.001982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348796 ORDER BY `minOrder` ASC [ RunTime:0.001640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348796 ORDER BY `unit` DESC [ RunTime:0.015288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348796 LIMIT 2 [ RunTime:0.020882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348796 ORDER BY `minOrder` ASC [ RunTime:0.008404s ]
select * from pdf where partno='1912610000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912610000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002828s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348796 AND `partno` = '1912610000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540662 [ RunTime:0.003338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348763 LIMIT 5 [ RunTime:0.002231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348763 ORDER BY `minOrder` ASC [ RunTime:0.008288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348763 ORDER BY `unit` DESC [ RunTime:0.000921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348763 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348763 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
select * from pdf where partno='1912640000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912640000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006078s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348763 AND `partno` = '1912640000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540632 [ RunTime:0.006946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348756 LIMIT 5 [ RunTime:0.006356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348756 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348756 ORDER BY `unit` DESC [ RunTime:0.001873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348756 LIMIT 2 [ RunTime:0.006115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348756 ORDER BY `minOrder` ASC [ RunTime:0.000965s ]
select * from pdf where partno='1912600000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912600000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001156s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348756 AND `partno` = '1912600000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.014396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540625 [ RunTime:0.004806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49347892 LIMIT 5 [ RunTime:0.001240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49347892 ORDER BY `minOrder` ASC [ RunTime:0.014827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49347892 ORDER BY `unit` DESC [ RunTime:0.014640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49347892 LIMIT 2 [ RunTime:0.003156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49347892 ORDER BY `minOrder` ASC [ RunTime:0.003511s ]
select * from pdf where partno='1912650000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912650000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005492s ]
SELECT `id` FROM `stock` WHERE `id` <> 49347892 AND `partno` = '1912650000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36539732 [ RunTime:0.000993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49333866 LIMIT 5 [ RunTime:0.003198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49333866 ORDER BY `minOrder` ASC [ RunTime:0.006140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49333866 ORDER BY `unit` DESC [ RunTime:0.002242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49333866 LIMIT 2 [ RunTime:0.004920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49333866 ORDER BY `minOrder` ASC [ RunTime:0.004628s ]
select * from pdf where partno='19126.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.010498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19126.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.003947s ]
SELECT `id` FROM `stock` WHERE `id` <> 49333866 AND `partno` = '19126.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.004458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543719 [ RunTime:0.001338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49191266 LIMIT 5 [ RunTime:0.013311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49191266 ORDER BY `minOrder` ASC [ RunTime:0.004852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49191266 ORDER BY `unit` DESC [ RunTime:0.007022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49191266 LIMIT 2 [ RunTime:0.006154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49191266 ORDER BY `minOrder` ASC [ RunTime:0.010518s ]
select * from pdf where partno='19126 010250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19126 010250' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000398s ]
SELECT `id` FROM `stock` WHERE `id` <> 49191266 AND `partno` = '19126 010250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.003031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14376654 [ RunTime:0.002885s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001677s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010266s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003620s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008857s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005858s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011924s ]
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 '19126%' OR `brand` LIKE '19126%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004241s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19126%' OR `brand` LIKE '19126%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009579s ]