SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001962s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018415s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754312 LIMIT 5 [ RunTime:0.005711s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754312 ORDER BY `minOrder` ASC [ RunTime:0.022182s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754312 ORDER BY `unit` DESC [ RunTime:0.005961s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754312 LIMIT 2 [ RunTime:0.024569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754312 ORDER BY `minOrder` ASC [ RunTime:0.008986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18739756 LIMIT 5 [ RunTime:0.002167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18739756 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18739756 ORDER BY `unit` DESC [ RunTime:0.017558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18739756 LIMIT 2 [ RunTime:0.010025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18739756 ORDER BY `minOrder` ASC [ RunTime:0.009274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410928 LIMIT 5 [ RunTime:0.014112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410928 ORDER BY `minOrder` ASC [ RunTime:0.030669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16410928 ORDER BY `unit` DESC [ RunTime:0.015246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16410928 LIMIT 2 [ RunTime:0.021000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410928 ORDER BY `minOrder` ASC [ RunTime:0.034923s ]
select * from pdf where partno='8729 0095000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.035904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410823 LIMIT 5 [ RunTime:0.032106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410823 ORDER BY `minOrder` ASC [ RunTime:0.006845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16410823 ORDER BY `unit` DESC [ RunTime:0.023195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16410823 LIMIT 2 [ RunTime:0.043867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410823 ORDER BY `minOrder` ASC [ RunTime:0.045130s ]
select * from pdf where partno='8729 009500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.054399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385190 LIMIT 5 [ RunTime:0.037988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385190 ORDER BY `minOrder` ASC [ RunTime:0.178349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385190 ORDER BY `unit` DESC [ RunTime:0.051214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385190 LIMIT 2 [ RunTime:0.051436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385190 ORDER BY `minOrder` ASC [ RunTime:0.051639s ]
select * from pdf where partno='8729 009U1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.051741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385072 LIMIT 5 [ RunTime:0.051846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385072 ORDER BY `minOrder` ASC [ RunTime:0.041775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14385072 ORDER BY `unit` DESC [ RunTime:0.040579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14385072 LIMIT 2 [ RunTime:0.055149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14385072 ORDER BY `minOrder` ASC [ RunTime:0.028544s ]
select * from pdf where partno='8729 009U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.039653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512437 LIMIT 5 [ RunTime:0.050880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512437 ORDER BY `minOrder` ASC [ RunTime:0.011816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13512437 ORDER BY `unit` DESC [ RunTime:0.027933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13512437 LIMIT 2 [ RunTime:0.015296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13512437 ORDER BY `minOrder` ASC [ RunTime:0.014383s ]
select * from pdf where partno='8729 0091000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.007096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12545234 LIMIT 5 [ RunTime:0.004494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12545234 ORDER BY `minOrder` ASC [ RunTime:0.005596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12545234 ORDER BY `unit` DESC [ RunTime:0.013261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12545234 LIMIT 2 [ RunTime:0.022265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12545234 ORDER BY `minOrder` ASC [ RunTime:0.018450s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016375s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53755544 LIMIT 5 [ RunTime:0.031977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53755544 ORDER BY `minOrder` ASC [ RunTime:0.014416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53755544 ORDER BY `unit` DESC [ RunTime:0.016415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53755544 LIMIT 2 [ RunTime:0.015737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53755544 ORDER BY `minOrder` ASC [ RunTime:0.020565s ]
select * from pdf where partno='8729' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.029030s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.020006s ]
SELECT `id` FROM `stock` WHERE `id` <> 53755544 AND `partno` = '8729' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.021645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12545234 [ RunTime:0.005839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51683999 LIMIT 5 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683999 ORDER BY `minOrder` ASC [ RunTime:0.006293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51683999 ORDER BY `unit` DESC [ RunTime:0.003343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51683999 LIMIT 2 [ RunTime:0.002524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683999 ORDER BY `minOrder` ASC [ RunTime:0.020998s ]
select * from pdf where partno='8729' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.005511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.008156s ]
SELECT `id` FROM `stock` WHERE `id` <> 51683999 AND `partno` = '8729' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.005567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49588105 LIMIT 5 [ RunTime:0.013380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49588105 ORDER BY `minOrder` ASC [ RunTime:0.007258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49588105 ORDER BY `unit` DESC [ RunTime:0.006316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49588105 LIMIT 2 [ RunTime:0.041130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49588105 ORDER BY `minOrder` ASC [ RunTime:0.010573s ]
select * from pdf where partno='8729' and brandshort='ABBATRON' limit 1 [ RunTime:0.014598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.005890s ]
SELECT `id` FROM `stock` WHERE `id` <> 49588105 AND `partno` = '8729' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%abbatron%' ) [ RunTime:0.020987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781222 [ RunTime:0.022702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49218519 LIMIT 5 [ RunTime:0.021145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49218519 ORDER BY `minOrder` ASC [ RunTime:0.020666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49218519 ORDER BY `unit` DESC [ RunTime:0.019663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49218519 LIMIT 2 [ RunTime:0.005443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49218519 ORDER BY `minOrder` ASC [ RunTime:0.008939s ]
select * from pdf where partno='8729 0095000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 0095000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.014754s ]
SELECT `id` FROM `stock` WHERE `id` <> 49218519 AND `partno` = '8729 0095000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.018085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410928 [ RunTime:0.007236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49218248 LIMIT 5 [ RunTime:0.015784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49218248 ORDER BY `minOrder` ASC [ RunTime:0.015282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49218248 ORDER BY `unit` DESC [ RunTime:0.015273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49218248 LIMIT 2 [ RunTime:0.009514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49218248 ORDER BY `minOrder` ASC [ RunTime:0.007487s ]
select * from pdf where partno='8729 0091000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.008301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 0091000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.007316s ]
SELECT `id` FROM `stock` WHERE `id` <> 49218248 AND `partno` = '8729 0091000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.012266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512437 [ RunTime:0.004820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49218247 LIMIT 5 [ RunTime:0.006508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49218247 ORDER BY `minOrder` ASC [ RunTime:0.011096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49218247 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49218247 LIMIT 2 [ RunTime:0.019423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49218247 ORDER BY `minOrder` ASC [ RunTime:0.006694s ]
select * from pdf where partno='8729 009U1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.025846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 009U1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.007673s ]
SELECT `id` FROM `stock` WHERE `id` <> 49218247 AND `partno` = '8729 009U1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.009799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385190 [ RunTime:0.006230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49217588 LIMIT 5 [ RunTime:0.012813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49217588 ORDER BY `minOrder` ASC [ RunTime:0.011855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49217588 ORDER BY `unit` DESC [ RunTime:0.014951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49217588 LIMIT 2 [ RunTime:0.015789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49217588 ORDER BY `minOrder` ASC [ RunTime:0.008270s ]
select * from pdf where partno='8729 009500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 009500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.021041s ]
SELECT `id` FROM `stock` WHERE `id` <> 49217588 AND `partno` = '8729 009500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.007683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410823 [ RunTime:0.025197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49217587 LIMIT 5 [ RunTime:0.011234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49217587 ORDER BY `minOrder` ASC [ RunTime:0.013866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49217587 ORDER BY `unit` DESC [ RunTime:0.007151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49217587 LIMIT 2 [ RunTime:0.019500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49217587 ORDER BY `minOrder` ASC [ RunTime:0.032351s ]
select * from pdf where partno='8729 009U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.009961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 009U500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.022041s ]
SELECT `id` FROM `stock` WHERE `id` <> 49217587 AND `partno` = '8729 009U500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.015457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385072 [ RunTime:0.016336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44022997 LIMIT 5 [ RunTime:0.014159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44022997 ORDER BY `minOrder` ASC [ RunTime:0.006857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44022997 ORDER BY `unit` DESC [ RunTime:0.006683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44022997 LIMIT 2 [ RunTime:0.013803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44022997 ORDER BY `minOrder` ASC [ RunTime:0.022761s ]
select * from pdf where partno='872985-9' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.011034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '872985-9' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.013575s ]
SELECT `id` FROM `stock` WHERE `id` <> 44022997 AND `partno` = '872985-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.017954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18739756 [ RunTime:0.025026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36781222 LIMIT 5 [ RunTime:0.014258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781222 ORDER BY `minOrder` ASC [ RunTime:0.012508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36781222 ORDER BY `unit` DESC [ RunTime:0.008875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36781222 LIMIT 2 [ RunTime:0.014331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36781222 ORDER BY `minOrder` ASC [ RunTime:0.029663s ]
select * from pdf where partno='8729' and brandshort='ABBATRON' limit 1 [ RunTime:0.010211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.003760s ]
SELECT `id` FROM `stock` WHERE `id` <> 36781222 AND `partno` = '8729' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%abbatron%' ) [ RunTime:0.021806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49588105 [ RunTime:0.016291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36422226 LIMIT 5 [ RunTime:0.022157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36422226 ORDER BY `minOrder` ASC [ RunTime:0.016911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36422226 ORDER BY `unit` DESC [ RunTime:0.004176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36422226 LIMIT 2 [ RunTime:0.009063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36422226 ORDER BY `minOrder` ASC [ RunTime:0.015486s ]
select * from pdf where partno='8729 0095000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 0095000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.003321s ]
SELECT `id` FROM `stock` WHERE `id` <> 36422226 AND `partno` = '8729 0095000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.002744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410928 [ RunTime:0.008873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36421966 LIMIT 5 [ RunTime:0.004026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36421966 ORDER BY `minOrder` ASC [ RunTime:0.006206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36421966 ORDER BY `unit` DESC [ RunTime:0.011876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36421966 LIMIT 2 [ RunTime:0.019283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36421966 ORDER BY `minOrder` ASC [ RunTime:0.008752s ]
select * from pdf where partno='8729 0091000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.006470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 0091000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.010446s ]
SELECT `id` FROM `stock` WHERE `id` <> 36421966 AND `partno` = '8729 0091000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.019785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13512437 [ RunTime:0.000264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36421965 LIMIT 5 [ RunTime:0.001233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36421965 ORDER BY `minOrder` ASC [ RunTime:0.008378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36421965 ORDER BY `unit` DESC [ RunTime:0.016172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36421965 LIMIT 2 [ RunTime:0.017169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36421965 ORDER BY `minOrder` ASC [ RunTime:0.028445s ]
select * from pdf where partno='8729 009U1000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.015176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 009U1000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.010694s ]
SELECT `id` FROM `stock` WHERE `id` <> 36421965 AND `partno` = '8729 009U1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.006564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385190 [ RunTime:0.007741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36421346 LIMIT 5 [ RunTime:0.019661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36421346 ORDER BY `minOrder` ASC [ RunTime:0.010734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36421346 ORDER BY `unit` DESC [ RunTime:0.012452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36421346 LIMIT 2 [ RunTime:0.014843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36421346 ORDER BY `minOrder` ASC [ RunTime:0.006697s ]
select * from pdf where partno='8729 009500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 009500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.003892s ]
SELECT `id` FROM `stock` WHERE `id` <> 36421346 AND `partno` = '8729 009500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.005119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410823 [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36421345 LIMIT 5 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36421345 ORDER BY `minOrder` ASC [ RunTime:0.009534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36421345 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36421345 LIMIT 2 [ RunTime:0.008328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36421345 ORDER BY `minOrder` ASC [ RunTime:0.002834s ]
select * from pdf where partno='8729 009U500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.003553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8729 009U500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000356s ]
SELECT `id` FROM `stock` WHERE `id` <> 36421345 AND `partno` = '8729 009U500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.000743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14385072 [ RunTime:0.000273s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002013s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000907s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003630s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003399s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000857s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001014s ]
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 '8729%' OR `brand` LIKE '8729%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000909s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8729%' OR `brand` LIKE '8729%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000879s ]