SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002636s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027172s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415710 LIMIT 5 [ RunTime:0.015000s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415710 ORDER BY `minOrder` ASC [ RunTime:0.010208s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16415710 ORDER BY `unit` DESC [ RunTime:0.013111s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16415710 LIMIT 2 [ RunTime:0.009004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415710 ORDER BY `minOrder` ASC [ RunTime:0.003130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669365 LIMIT 5 [ RunTime:0.007992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669365 ORDER BY `minOrder` ASC [ RunTime:0.033712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669365 ORDER BY `unit` DESC [ RunTime:0.009744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669365 LIMIT 2 [ RunTime:0.006862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669365 ORDER BY `minOrder` ASC [ RunTime:0.008536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14398995 LIMIT 5 [ RunTime:0.030042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14398995 ORDER BY `minOrder` ASC [ RunTime:0.027907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14398995 ORDER BY `unit` DESC [ RunTime:0.021989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14398995 LIMIT 2 [ RunTime:0.026540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14398995 ORDER BY `minOrder` ASC [ RunTime:0.030602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14398994 LIMIT 5 [ RunTime:0.032747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14398994 ORDER BY `minOrder` ASC [ RunTime:0.031293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14398994 ORDER BY `unit` DESC [ RunTime:0.027809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14398994 LIMIT 2 [ RunTime:0.033315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14398994 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13528988 LIMIT 5 [ RunTime:0.019090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13528988 ORDER BY `minOrder` ASC [ RunTime:0.064628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13528988 ORDER BY `unit` DESC [ RunTime:0.027569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13528988 LIMIT 2 [ RunTime:0.037598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13528988 ORDER BY `minOrder` ASC [ RunTime:0.016153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13528980 LIMIT 5 [ RunTime:0.038282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13528980 ORDER BY `minOrder` ASC [ RunTime:0.022249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13528980 ORDER BY `unit` DESC [ RunTime:0.045201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13528980 LIMIT 2 [ RunTime:0.061060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13528980 ORDER BY `minOrder` ASC [ RunTime:0.005271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415336 LIMIT 5 [ RunTime:0.019597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415336 ORDER BY `minOrder` ASC [ RunTime:0.015141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16415336 ORDER BY `unit` DESC [ RunTime:0.036347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16415336 LIMIT 2 [ RunTime:0.009744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415336 ORDER BY `minOrder` ASC [ RunTime:0.012574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14399008 LIMIT 5 [ RunTime:0.020634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14399008 ORDER BY `minOrder` ASC [ RunTime:0.006975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14399008 ORDER BY `unit` DESC [ RunTime:0.024580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14399008 LIMIT 2 [ RunTime:0.013857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14399008 ORDER BY `minOrder` ASC [ RunTime:0.010806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617456 LIMIT 5 [ RunTime:0.013157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617456 ORDER BY `minOrder` ASC [ RunTime:0.009487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12617456 ORDER BY `unit` DESC [ RunTime:0.001339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12617456 LIMIT 2 [ RunTime:0.015421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12617456 ORDER BY `minOrder` ASC [ RunTime:0.003908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454388 LIMIT 5 [ RunTime:0.017341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454388 ORDER BY `minOrder` ASC [ RunTime:0.033325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454388 ORDER BY `unit` DESC [ RunTime:0.008222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454388 LIMIT 2 [ RunTime:0.017968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454388 ORDER BY `minOrder` ASC [ RunTime:0.019759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415578 LIMIT 5 [ RunTime:0.034976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415578 ORDER BY `minOrder` ASC [ RunTime:0.032117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16415578 ORDER BY `unit` DESC [ RunTime:0.037660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16415578 LIMIT 2 [ RunTime:0.045284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16415578 ORDER BY `minOrder` ASC [ RunTime:0.028656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672387 LIMIT 5 [ RunTime:0.056735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672387 ORDER BY `minOrder` ASC [ RunTime:0.028141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672387 ORDER BY `unit` DESC [ RunTime:0.014970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672387 LIMIT 2 [ RunTime:0.048328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672387 ORDER BY `minOrder` ASC [ RunTime:0.018425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672353 LIMIT 5 [ RunTime:0.038476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672353 ORDER BY `minOrder` ASC [ RunTime:0.050432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672353 ORDER BY `unit` DESC [ RunTime:0.021924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672353 LIMIT 2 [ RunTime:0.006170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672353 ORDER BY `minOrder` ASC [ RunTime:0.013198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672259 LIMIT 5 [ RunTime:0.019437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672259 ORDER BY `minOrder` ASC [ RunTime:0.046568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672259 ORDER BY `unit` DESC [ RunTime:0.032162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672259 LIMIT 2 [ RunTime:0.017340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672259 ORDER BY `minOrder` ASC [ RunTime:0.007201s ]
select * from pdf where partno='1918153-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672122 LIMIT 5 [ RunTime:0.009064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672122 ORDER BY `minOrder` ASC [ RunTime:0.040209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672122 ORDER BY `unit` DESC [ RunTime:0.007100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672122 LIMIT 2 [ RunTime:0.016264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672122 ORDER BY `minOrder` ASC [ RunTime:0.016608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672121 LIMIT 5 [ RunTime:0.011329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672121 ORDER BY `minOrder` ASC [ RunTime:0.008468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672121 ORDER BY `unit` DESC [ RunTime:0.026569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672121 LIMIT 2 [ RunTime:0.060909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672121 ORDER BY `minOrder` ASC [ RunTime:0.025600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672091 LIMIT 5 [ RunTime:0.031560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672091 ORDER BY `minOrder` ASC [ RunTime:0.003701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672091 ORDER BY `unit` DESC [ RunTime:0.003389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672091 LIMIT 2 [ RunTime:0.010788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672091 ORDER BY `minOrder` ASC [ RunTime:0.013857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672061 LIMIT 5 [ RunTime:0.030236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672061 ORDER BY `minOrder` ASC [ RunTime:0.010439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672061 ORDER BY `unit` DESC [ RunTime:0.017172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672061 LIMIT 2 [ RunTime:0.018946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672061 ORDER BY `minOrder` ASC [ RunTime:0.007909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19672055 LIMIT 5 [ RunTime:0.018500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672055 ORDER BY `minOrder` ASC [ RunTime:0.015839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19672055 ORDER BY `unit` DESC [ RunTime:0.010357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19672055 LIMIT 2 [ RunTime:0.009153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19672055 ORDER BY `minOrder` ASC [ RunTime:0.025220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671115 LIMIT 5 [ RunTime:0.005498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671115 ORDER BY `minOrder` ASC [ RunTime:0.002539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671115 ORDER BY `unit` DESC [ RunTime:0.007999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671115 LIMIT 2 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671115 ORDER BY `minOrder` ASC [ RunTime:0.001839s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281320 LIMIT 5 [ RunTime:0.012116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281320 ORDER BY `minOrder` ASC [ RunTime:0.008900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281320 ORDER BY `unit` DESC [ RunTime:0.006892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281320 LIMIT 2 [ RunTime:0.002674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281320 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='19183-0019' and brandshort='molex' limit 1 [ RunTime:0.019618s ]
select foldpath,foldpath2,filename from pdf_file where id=1692099 limit 1 [ RunTime:0.015394s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19183-0019' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.014129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32265607 LIMIT 5 [ RunTime:0.010487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32265607 ORDER BY `minOrder` ASC [ RunTime:0.015493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32265607 ORDER BY `unit` DESC [ RunTime:0.009833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32265607 LIMIT 2 [ RunTime:0.005217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32265607 ORDER BY `minOrder` ASC [ RunTime:0.002311s ]
select * from pdf where partno='1918153-1' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.001063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918153-1' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.009985s ]
SELECT `id` FROM `stock` WHERE `id` <> 32265607 AND `partno` = '1918153-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.015139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51103552 LIMIT 5 [ RunTime:0.023742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51103552 ORDER BY `minOrder` ASC [ RunTime:0.014975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51103552 ORDER BY `unit` DESC [ RunTime:0.001661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51103552 LIMIT 2 [ RunTime:0.007838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51103552 ORDER BY `minOrder` ASC [ RunTime:0.002195s ]
select * from pdf where partno='1918' and brandshort='adafruit' limit 1 [ RunTime:0.002498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.000562s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54171290 LIMIT 5 [ RunTime:0.005623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54171290 ORDER BY `minOrder` ASC [ RunTime:0.006653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54171290 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54171290 LIMIT 2 [ RunTime:0.004451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54171290 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='19189-0004' and brandshort='Molex' limit 1 [ RunTime:0.002180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19189-0004' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53814159 LIMIT 5 [ RunTime:0.005333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53814159 ORDER BY `minOrder` ASC [ RunTime:0.003155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53814159 ORDER BY `unit` DESC [ RunTime:0.004523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53814159 LIMIT 2 [ RunTime:0.012318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53814159 ORDER BY `minOrder` ASC [ RunTime:0.002427s ]
select * from pdf where partno='1918177-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918177-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005637s ]
SELECT `id` FROM `stock` WHERE `id` <> 53814159 AND `partno` = '1918177-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.014426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669365 [ RunTime:0.008336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49338009 LIMIT 5 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49338009 ORDER BY `minOrder` ASC [ RunTime:0.003517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49338009 ORDER BY `unit` DESC [ RunTime:0.002040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49338009 LIMIT 2 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49338009 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='1918910000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918910000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002725s ]
SELECT `id` FROM `stock` WHERE `id` <> 49338009 AND `partno` = '1918910000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415336 [ RunTime:0.001496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36530058 LIMIT 5 [ RunTime:0.005003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36530058 ORDER BY `minOrder` ASC [ RunTime:0.001260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36530058 ORDER BY `unit` DESC [ RunTime:0.008093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36530058 LIMIT 2 [ RunTime:0.006422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36530058 ORDER BY `minOrder` ASC [ RunTime:0.004927s ]
select * from pdf where partno='1918910000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918910000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000714s ]
SELECT `id` FROM `stock` WHERE `id` <> 36530058 AND `partno` = '1918910000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415336 [ RunTime:0.022494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49339724 LIMIT 5 [ RunTime:0.007640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339724 ORDER BY `minOrder` ASC [ RunTime:0.012300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49339724 ORDER BY `unit` DESC [ RunTime:0.022327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49339724 LIMIT 2 [ RunTime:0.004518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339724 ORDER BY `minOrder` ASC [ RunTime:0.007995s ]
select * from pdf where partno='1918580000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918580000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.023328s ]
SELECT `id` FROM `stock` WHERE `id` <> 49339724 AND `partno` = '1918580000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13528988 [ RunTime:0.007337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49339712 LIMIT 5 [ RunTime:0.009805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339712 ORDER BY `minOrder` ASC [ RunTime:0.006327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49339712 ORDER BY `unit` DESC [ RunTime:0.001776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49339712 LIMIT 2 [ RunTime:0.001637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339712 ORDER BY `minOrder` ASC [ RunTime:0.001340s ]
select * from pdf where partno='1918660000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918660000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004896s ]
SELECT `id` FROM `stock` WHERE `id` <> 49339712 AND `partno` = '1918660000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14398995 [ RunTime:0.000688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49339710 LIMIT 5 [ RunTime:0.015120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339710 ORDER BY `minOrder` ASC [ RunTime:0.013127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49339710 ORDER BY `unit` DESC [ RunTime:0.013930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49339710 LIMIT 2 [ RunTime:0.008957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339710 ORDER BY `minOrder` ASC [ RunTime:0.001764s ]
select * from pdf where partno='1918630000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918630000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002747s ]
SELECT `id` FROM `stock` WHERE `id` <> 49339710 AND `partno` = '1918630000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14398994 [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49339709 LIMIT 5 [ RunTime:0.002650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339709 ORDER BY `minOrder` ASC [ RunTime:0.006163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49339709 ORDER BY `unit` DESC [ RunTime:0.008503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49339709 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339709 ORDER BY `minOrder` ASC [ RunTime:0.011741s ]
select * from pdf where partno='1918610000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918610000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007033s ]
SELECT `id` FROM `stock` WHERE `id` <> 49339709 AND `partno` = '1918610000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13528980 [ RunTime:0.008258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36531770 LIMIT 5 [ RunTime:0.003812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531770 ORDER BY `minOrder` ASC [ RunTime:0.012104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36531770 ORDER BY `unit` DESC [ RunTime:0.009152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36531770 LIMIT 2 [ RunTime:0.021165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531770 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
select * from pdf where partno='1918580000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918580000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018316s ]
SELECT `id` FROM `stock` WHERE `id` <> 36531770 AND `partno` = '1918580000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.012001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13528988 [ RunTime:0.005943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36531758 LIMIT 5 [ RunTime:0.005964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531758 ORDER BY `minOrder` ASC [ RunTime:0.007013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36531758 ORDER BY `unit` DESC [ RunTime:0.002958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36531758 LIMIT 2 [ RunTime:0.010769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531758 ORDER BY `minOrder` ASC [ RunTime:0.010883s ]
select * from pdf where partno='1918660000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918660000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001614s ]
SELECT `id` FROM `stock` WHERE `id` <> 36531758 AND `partno` = '1918660000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14398995 [ RunTime:0.005167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36531756 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531756 ORDER BY `minOrder` ASC [ RunTime:0.013842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36531756 ORDER BY `unit` DESC [ RunTime:0.004032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36531756 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531756 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
select * from pdf where partno='1918630000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918630000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000458s ]
SELECT `id` FROM `stock` WHERE `id` <> 36531756 AND `partno` = '1918630000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14398994 [ RunTime:0.001853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36531755 LIMIT 5 [ RunTime:0.002422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531755 ORDER BY `minOrder` ASC [ RunTime:0.002175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36531755 ORDER BY `unit` DESC [ RunTime:0.004445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36531755 LIMIT 2 [ RunTime:0.016850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531755 ORDER BY `minOrder` ASC [ RunTime:0.001631s ]
select * from pdf where partno='1918610000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918610000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005010s ]
SELECT `id` FROM `stock` WHERE `id` <> 36531755 AND `partno` = '1918610000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13528980 [ RunTime:0.007579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49339733 LIMIT 5 [ RunTime:0.003201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339733 ORDER BY `minOrder` ASC [ RunTime:0.002685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49339733 ORDER BY `unit` DESC [ RunTime:0.000817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49339733 LIMIT 2 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49339733 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
select * from pdf where partno='1918890000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918890000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011332s ]
SELECT `id` FROM `stock` WHERE `id` <> 49339733 AND `partno` = '1918890000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14399008 [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36531779 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531779 ORDER BY `minOrder` ASC [ RunTime:0.004594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36531779 ORDER BY `unit` DESC [ RunTime:0.004913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36531779 LIMIT 2 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36531779 ORDER BY `minOrder` ASC [ RunTime:0.006212s ]
select * from pdf where partno='1918890000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918890000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000537s ]
SELECT `id` FROM `stock` WHERE `id` <> 36531779 AND `partno` = '1918890000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14399008 [ RunTime:0.002870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53086881 LIMIT 5 [ RunTime:0.004422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53086881 ORDER BY `minOrder` ASC [ RunTime:0.004774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53086881 ORDER BY `unit` DESC [ RunTime:0.005414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53086881 LIMIT 2 [ RunTime:0.000864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53086881 ORDER BY `minOrder` ASC [ RunTime:0.004507s ]
select * from pdf where partno='1918' and brandshort='Pololu' limit 1 [ RunTime:0.000692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.001334s ]
SELECT `id` FROM `stock` WHERE `id` <> 53086881 AND `partno` = '1918' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.002203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12617456 [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37430647 LIMIT 5 [ RunTime:0.001882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37430647 ORDER BY `minOrder` ASC [ RunTime:0.006060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37430647 ORDER BY `unit` DESC [ RunTime:0.000774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37430647 LIMIT 2 [ RunTime:0.003188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37430647 ORDER BY `minOrder` ASC [ RunTime:0.008403s ]
select * from pdf where partno='1918' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.002027s ]
SELECT `id` FROM `stock` WHERE `id` <> 37430647 AND `partno` = '1918' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.004863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510056 [ RunTime:0.012399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50233691 LIMIT 5 [ RunTime:0.007937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50233691 ORDER BY `minOrder` ASC [ RunTime:0.006033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50233691 ORDER BY `unit` DESC [ RunTime:0.002706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50233691 LIMIT 2 [ RunTime:0.005234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50233691 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
select * from pdf where partno='1918' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000482s ]
SELECT `id` FROM `stock` WHERE `id` <> 50233691 AND `partno` = '1918' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.002009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510056 [ RunTime:0.015107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55296873 LIMIT 5 [ RunTime:0.007205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55296873 ORDER BY `minOrder` ASC [ RunTime:0.001837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55296873 ORDER BY `unit` DESC [ RunTime:0.002089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55296873 LIMIT 2 [ RunTime:0.016771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55296873 ORDER BY `minOrder` ASC [ RunTime:0.005981s ]
select * from pdf where partno='1918934-5' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918934-5' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.025068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53814184 LIMIT 5 [ RunTime:0.029381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53814184 ORDER BY `minOrder` ASC [ RunTime:0.014184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53814184 ORDER BY `unit` DESC [ RunTime:0.002247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53814184 LIMIT 2 [ RunTime:0.012654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53814184 ORDER BY `minOrder` ASC [ RunTime:0.013233s ]
select * from pdf where partno='1918931-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918931-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007265s ]
SELECT `id` FROM `stock` WHERE `id` <> 53814184 AND `partno` = '1918931-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454388 [ RunTime:0.000784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49340496 LIMIT 5 [ RunTime:0.008980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49340496 ORDER BY `minOrder` ASC [ RunTime:0.010214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49340496 ORDER BY `unit` DESC [ RunTime:0.002390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49340496 LIMIT 2 [ RunTime:0.003175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49340496 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='1918500000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1918500000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005761s ]
SELECT `id` FROM `stock` WHERE `id` <> 49340496 AND `partno` = '1918500000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.015365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16415578 [ RunTime:0.013128s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001456s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006069s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003468s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002186s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001178s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001305s ]
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 '1918%' OR `brand` LIKE '1918%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002469s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1918%' OR `brand` LIKE '1918%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005305s ]