SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001374s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040393s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178572 LIMIT 5 [ RunTime:0.028417s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178572 ORDER BY `minOrder` ASC [ RunTime:0.023095s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11178572 ORDER BY `unit` DESC [ RunTime:0.014660s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11178572 LIMIT 2 [ RunTime:0.022598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178572 ORDER BY `minOrder` ASC [ RunTime:0.002581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239723 LIMIT 5 [ RunTime:0.046608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15239723 ORDER BY `minOrder` ASC [ RunTime:0.058126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15239723 ORDER BY `unit` DESC [ RunTime:0.043895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15239723 LIMIT 2 [ RunTime:0.084557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15239723 ORDER BY `minOrder` ASC [ RunTime:0.064656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554689 LIMIT 5 [ RunTime:0.035366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554689 ORDER BY `minOrder` ASC [ RunTime:0.024547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554689 ORDER BY `unit` DESC [ RunTime:0.014094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554689 LIMIT 2 [ RunTime:0.015772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554689 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32240783 LIMIT 5 [ RunTime:0.025808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32240783 ORDER BY `minOrder` ASC [ RunTime:0.016782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32240783 ORDER BY `unit` DESC [ RunTime:0.023382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32240783 LIMIT 2 [ RunTime:0.033142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32240783 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
select * from pdf where partno='20028998-00' and brandshort='te connectivity' limit 1 [ RunTime:0.019815s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028998-00' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.046053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32172900 LIMIT 5 [ RunTime:0.021505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32172900 ORDER BY `minOrder` ASC [ RunTime:0.053173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32172900 ORDER BY `unit` DESC [ RunTime:0.029131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32172900 LIMIT 2 [ RunTime:0.017516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32172900 ORDER BY `minOrder` ASC [ RunTime:0.003299s ]
select * from pdf where partno='20028998-00' and brandshort='te connectivity' limit 1 [ RunTime:0.000808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028998-00' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.008184s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568267 LIMIT 5 [ RunTime:0.009747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568267 ORDER BY `minOrder` ASC [ RunTime:0.019929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568267 ORDER BY `unit` DESC [ RunTime:0.025837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568267 LIMIT 2 [ RunTime:0.013197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568267 ORDER BY `minOrder` ASC [ RunTime:0.011620s ]
select * from pdf where partno='20028' and brandshort='Excel Blades' limit 1 [ RunTime:0.008562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.019933s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568267 AND `partno` = '20028' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.012484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178572 [ RunTime:0.022736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64773420 LIMIT 5 [ RunTime:0.012196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773420 ORDER BY `minOrder` ASC [ RunTime:0.003439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64773420 ORDER BY `unit` DESC [ RunTime:0.018245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64773420 LIMIT 2 [ RunTime:0.016077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773420 ORDER BY `minOrder` ASC [ RunTime:0.005708s ]
select * from pdf where partno='20028998-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.036634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028998-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.005393s ]
SELECT `id` FROM `stock` WHERE `id` <> 64773420 AND `partno` = '20028998-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.030375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64773405 LIMIT 5 [ RunTime:0.009539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773405 ORDER BY `minOrder` ASC [ RunTime:0.027433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64773405 ORDER BY `unit` DESC [ RunTime:0.041791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64773405 LIMIT 2 [ RunTime:0.018132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773405 ORDER BY `minOrder` ASC [ RunTime:0.015302s ]
select * from pdf where partno='20028037-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.010061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028037-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.023675s ]
SELECT `id` FROM `stock` WHERE `id` <> 64773405 AND `partno` = '20028037-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.028510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64773359 LIMIT 5 [ RunTime:0.012616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773359 ORDER BY `minOrder` ASC [ RunTime:0.027633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64773359 ORDER BY `unit` DESC [ RunTime:0.039364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64773359 LIMIT 2 [ RunTime:0.035198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773359 ORDER BY `minOrder` ASC [ RunTime:0.039824s ]
select * from pdf where partno='20028108-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.028860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028108-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.046400s ]
SELECT `id` FROM `stock` WHERE `id` <> 64773359 AND `partno` = '20028108-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.037052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64773358 LIMIT 5 [ RunTime:0.023173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773358 ORDER BY `minOrder` ASC [ RunTime:0.007285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64773358 ORDER BY `unit` DESC [ RunTime:0.081496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64773358 LIMIT 2 [ RunTime:0.013962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773358 ORDER BY `minOrder` ASC [ RunTime:0.028360s ]
select * from pdf where partno='20028107-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.025015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028107-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.050081s ]
SELECT `id` FROM `stock` WHERE `id` <> 64773358 AND `partno` = '20028107-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.045069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64773356 LIMIT 5 [ RunTime:0.051638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773356 ORDER BY `minOrder` ASC [ RunTime:0.085243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64773356 ORDER BY `unit` DESC [ RunTime:0.053913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64773356 LIMIT 2 [ RunTime:0.053044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773356 ORDER BY `minOrder` ASC [ RunTime:0.005672s ]
select * from pdf where partno='20028106-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.032208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028106-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.040985s ]
SELECT `id` FROM `stock` WHERE `id` <> 64773356 AND `partno` = '20028106-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.056840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64530867 LIMIT 5 [ RunTime:0.039490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64530867 ORDER BY `minOrder` ASC [ RunTime:0.060217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64530867 ORDER BY `unit` DESC [ RunTime:0.040840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64530867 LIMIT 2 [ RunTime:0.025226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64530867 ORDER BY `minOrder` ASC [ RunTime:0.031465s ]
select * from pdf where partno='20028' and brandshort='Brady Corporation' limit 1 [ RunTime:0.029060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.044685s ]
SELECT `id` FROM `stock` WHERE `id` <> 64530867 AND `partno` = '20028' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.029972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554689 [ RunTime:0.032614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64080919 LIMIT 5 [ RunTime:0.027059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64080919 ORDER BY `minOrder` ASC [ RunTime:0.042918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64080919 ORDER BY `unit` DESC [ RunTime:0.034006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64080919 LIMIT 2 [ RunTime:0.032152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64080919 ORDER BY `minOrder` ASC [ RunTime:0.050519s ]
select * from pdf where partno='20028981-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.106193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028981-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.028949s ]
SELECT `id` FROM `stock` WHERE `id` <> 64080919 AND `partno` = '20028981-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.077627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63269879 LIMIT 5 [ RunTime:0.035002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269879 ORDER BY `minOrder` ASC [ RunTime:0.026934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63269879 ORDER BY `unit` DESC [ RunTime:0.038103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63269879 LIMIT 2 [ RunTime:0.051384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63269879 ORDER BY `minOrder` ASC [ RunTime:0.026874s ]
select * from pdf where partno='20028223-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.088004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028223-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.039744s ]
SELECT `id` FROM `stock` WHERE `id` <> 63269879 AND `partno` = '20028223-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.034392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49418211 LIMIT 5 [ RunTime:0.017351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49418211 ORDER BY `minOrder` ASC [ RunTime:0.042352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49418211 ORDER BY `unit` DESC [ RunTime:0.024634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49418211 LIMIT 2 [ RunTime:0.055063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49418211 ORDER BY `minOrder` ASC [ RunTime:0.002042s ]
select * from pdf where partno='20028964-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.014521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028964-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.036585s ]
SELECT `id` FROM `stock` WHERE `id` <> 49418211 AND `partno` = '20028964-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.048505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36612265 [ RunTime:0.030893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36612265 LIMIT 5 [ RunTime:0.028774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36612265 ORDER BY `minOrder` ASC [ RunTime:0.034117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36612265 ORDER BY `unit` DESC [ RunTime:0.037084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36612265 LIMIT 2 [ RunTime:0.032972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36612265 ORDER BY `minOrder` ASC [ RunTime:0.013537s ]
select * from pdf where partno='20028964-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.005315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028964-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.023090s ]
SELECT `id` FROM `stock` WHERE `id` <> 36612265 AND `partno` = '20028964-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.005935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49418211 [ RunTime:0.020500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32555106 LIMIT 5 [ RunTime:0.023090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32555106 ORDER BY `minOrder` ASC [ RunTime:0.021933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32555106 ORDER BY `unit` DESC [ RunTime:0.013831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32555106 LIMIT 2 [ RunTime:0.011534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32555106 ORDER BY `minOrder` ASC [ RunTime:0.004791s ]
select * from pdf where partno='20028258-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.015043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028258-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.010291s ]
SELECT `id` FROM `stock` WHERE `id` <> 32555106 AND `partno` = '20028258-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.026011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32535882 LIMIT 5 [ RunTime:0.017019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32535882 ORDER BY `minOrder` ASC [ RunTime:0.001257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32535882 ORDER BY `unit` DESC [ RunTime:0.010506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32535882 LIMIT 2 [ RunTime:0.006164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32535882 ORDER BY `minOrder` ASC [ RunTime:0.018030s ]
select * from pdf where partno='20028165-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.007667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028165-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.004985s ]
SELECT `id` FROM `stock` WHERE `id` <> 32535882 AND `partno` = '20028165-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.007699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32535881 LIMIT 5 [ RunTime:0.007195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32535881 ORDER BY `minOrder` ASC [ RunTime:0.013005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32535881 ORDER BY `unit` DESC [ RunTime:0.008611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32535881 LIMIT 2 [ RunTime:0.013002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32535881 ORDER BY `minOrder` ASC [ RunTime:0.018527s ]
select * from pdf where partno='20028167-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.016634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028167-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.006893s ]
SELECT `id` FROM `stock` WHERE `id` <> 32535881 AND `partno` = '20028167-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.007783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32375971 LIMIT 5 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32375971 ORDER BY `minOrder` ASC [ RunTime:0.010501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32375971 ORDER BY `unit` DESC [ RunTime:0.015364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32375971 LIMIT 2 [ RunTime:0.018398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32375971 ORDER BY `minOrder` ASC [ RunTime:0.002173s ]
select * from pdf where partno='20028300-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.006650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20028300-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.011553s ]
SELECT `id` FROM `stock` WHERE `id` <> 32375971 AND `partno` = '20028300-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.008776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32345794 LIMIT 5 [ RunTime:0.014339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32345794 ORDER BY `minOrder` ASC [ RunTime:0.003861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32345794 ORDER BY `unit` DESC [ RunTime:0.010316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32345794 LIMIT 2 [ RunTime:0.001996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32345794 ORDER BY `minOrder` ASC [ RunTime:0.009119s ]
select * from pdf where partno='200280-00' and brandshort='Dwyer' limit 1 [ RunTime:0.004789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '200280-00' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.006898s ]
SELECT `id` FROM `stock` WHERE `id` <> 32345794 AND `partno` = '200280-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.005225s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014022s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001266s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003934s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015198s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001427s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006605s ]
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 '20028%' OR `brand` LIKE '20028%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001322s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20028%' OR `brand` LIKE '20028%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005364s ]